What are advantages and disadvantages of Microsoft-provided
data provider classes in ADO.NET?
- 2 Answers
- 11837 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
SQLServer.NET data provider is high-speed and robust, but
requires SQL Server license purchased from Microsoft.
OLE-DB.NET is universal for accessing other sources, like
Oracle, DB2, Microsoft Access and Informix, but it?s a .NET
layer on top of OLE layer, so not the fastest thing in the
world. ODBC.NET is a deprecated layer provided for backward
compatibility to ODBC engines.
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How to Read, Add, Update and Delete record in Entity Framework ?
What is DataRowCollection?
Can we connect two dataadapters to same data source using single connection at same time?
How to generate a single aggregate?
What is the difference between data grid and data repeater?
Which method is used to sort the data in ADO.Net?
What is the difference between Datareader and Dataset?
What is ado code?
What is ole word?
What we do with the object of ado.net dataset after using it?
What is an ado connection?
What is ado.net and its features?
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
