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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the Configuration files in .net?

509


Is versioning applicable to private assemblies?

563


How do you declare a variable in c#?

512


Where is the main method in c#?

522


Explain circular reference in c#?

542






what is IFormatable

576


What is difference between the "throw" and "throw ex" in .net?

484


What is action in c# 3.5?

528


What are the steps to make an assembly to public?

495


what are the contents of an assembly ?

544


What is regex c#?

481


Why should you override the tostring() method?

586


What is Assembly. and Describe type of assembly. why most developer happy with private assembly.

571


How to get the sum of last 3 items in a list using lambda expressions?

506


How to transpose multi-dimensional array?

551