C# (Sharp) Programming Language Question:
Download Questions PDF

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

Answer:

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.

Download C# (Sharp) Programming Language Interview Questions And Answers PDF

Previous QuestionNext Question
What is the advantage of using System.Text.StringBuilder over System.String?Why do I get a security exception when I try to run my C# app?