C# (Sharp) Programming Language Interview Question:

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

Submitted by: Administrator

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 is 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.
Submitted by: Administrator