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
How to retrieve the user id which is provided while windows authentication?
How to Read, Add, Update and Delete record in Entity Framework ?
What are the data providers used in ado.net
What are the major challenges in accessing data from a database?
What is sql command in ado net?
What is ado full form?
What are different layers of ADO.Net?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is ado net stands for?
How can we add relation between tables in a dataset?
How to identify the updated rows in a dataset?
How do you implement locking concept for dataset?
What are three methods for displaying data in a syncfusion datagrid
What is execute scalar in ado.net?
What are the Features of a dataset