what are advantages and disadvantages of Microsoft-provided data provider class

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

Question Posted / madduri

1 Answers
3854 Views
4Cplus, I also Faced
E-Mail Answers

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