What two types of data providers does ADO.NET supply? What determines which one you should use?



What two types of data providers does ADO.NET supply? What determines which one you should use?..

Answer / Neetu Kuma

ADO.NET supplies two main types of data providers: SQL Server provider and OLE DB provider. The choice between the two depends on your specific database system. If you are working with a Microsoft SQL Server, you would typically use the SQL Server provider for better performance. If you need to access multiple databases or are unsure about the underlying database system, you might opt for the OLE DB provider.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ADO.NET Interview Questions

Differentiate between Dataset and Recordset.

2 Answers  


What is a sqldataadapter?

1 Answers  


What are the different ado.net namespaces are available in .net?

1 Answers  


What is ado data control?

1 Answers  


What are the usages of the command object in ado.net?

1 Answers  


describe about the ado.net object model

4 Answers   TCS,


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

1 Answers  


What is openrowset?

1 Answers  


How to identify the updated rows in a dataset?

1 Answers  


Give an example of a .net application which connects to microsoft access database using ado.net classes.

1 Answers  


what is the syntax code for oldb to connect oracle

3 Answers   IBM,


differences between ADO and ADO.NET

1 Answers   Microsoft,


Categories