What are advantages and disadvantages of Microsoft-provided
data provider classes in ADO.NET?
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
differance between ADO vs ADO.Net?
What is difference between datareader and dataadapter?
How do you update database through dataset?
Is it possible to load multiple tables in a Dataset?
What is the role of data provider in ado.net?
Explain the two fundamental objects in ado.net?
Which method is used to sort the data in ADO.Net?
What is ado code?
What is the difference in record set and dataset?
What is the return type of executescalar?
Explain ado.net features?
What is disconnected architecture in ado.net?
What are the Features and disadvantages of dataset
What is sqldatasource?
How to read data with the sqldatareader ?