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

Explain attributes in c#?

639


What are Memory foot print of an exe?

704


What does f mean in c#?

688


What is the default value of singleordefault?

685


Can you declare a class or a struct as constant?

767


What are the 3 types of comments in c#?

721


What is cookies c#?

676


Why do we need to serialize data?

671


What is the main purpose of linq?

685


Is it possible to nest cfml conditional tags?

730


Does c# support a variable number of arguments?

782


To allow an element to be accessed using a unique key which .NET collection class is used ?

842


What is cache memory in c#?

662


Can you have more than one namespace in c#?

689


Why do we use stringbuilder in c#?

708