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 is the provider being used to access oracle database?
Define table relations?
What are the data providers used in ado.net
How do you update a dataset in ado.net?
What is ambient transaction?
How do you merge 2 datasets into the third dataset in a simple manner?
What is the difference between OLEDB Provider and SqlClient?
How to work with disconnected data - the dataset and sqldataadapter?
What is data relation in ado.net?
What is data relation?
What is a datagridview?
Describe ado.net object model in detail.
Explain how to create dynamic gridview?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is ado rdo dao in visual basic?