what are advantages and disadvantages of Microsoft-provided
data provider classes in ADO.NET?



what are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?..

Answer / madduri

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 ?    1 Yes 0 No

Post New Answer

More C Sharp Interview Questions

Explain the difference between proc. Sent by val and by sub?

0 Answers  


what is Encapsulation?

7 Answers   IBM, Tech Mahindra,


What is the correct way of declaring an xml namespace?

0 Answers  


How to find Percentage, name ,College from a resume or document ? How to export these values to other page in C#?

0 Answers   CDC,


What are virtual classes in c#?

0 Answers  






Why use “using” in c#?

0 Answers  


What is the difference between dataset and datatable in c#?

0 Answers  


Which is faster iqueryable or ienumerable?

0 Answers  


directcast(123.34,integer) - should it throw an error? Why or why not?

2 Answers   Wipro,


Explain About Global.asax

0 Answers   Keane India Ltd,


Explain the Abstract class in c#.net

0 Answers  


Why dictionary is used in c#?

0 Answers  


Categories