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
What are the different methods by which we can populate a dataset?
What is ado or jdbc?
Which method in OLEDBAdapter is used to populate dataset with records?
What is the difference between ADO and ADO.Net?
What Is Difference Between Ado And Ado.net?
How can you add or remove rows from the datatable object of dataset?
What is data control techniques?
What DataReader class do in ADO.NET ?
What is ole in vb?
Explain the difference between an ado.net dataset and an ado recordset?
What is ole word?
How to add a check box or a dropdown list to a column in a datagrid?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Describe briefly an ADO.NET Dataset ?
What is ado code?