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 is the difference between protected and internal in c#?

468


Explain About stateless and state full web service

570


What is msil in c#?

555


What is a statement c#?

508


Explain acid rule of thumb for transactions in c#.

526






Which control cannot be placed in mdi?

531


What is string programming language?

444


What is activator c#?

480


Name the property of the textbox which cannot be changed at runtime?

528


Define satellite Assembly?

559


What is difference between class and abstract class in c#?

463


Why do we need generics in c#?

512


What is deferred execution in c#?

516


How to override a function in c#?

549


What is the lock statement in c#?

538