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



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

Answer / 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

More C Sharp Interview Questions

what is dynamic sql

2 Answers   TCS, Wipro,


what is the need of using interface in program ex:if we have a program like this interface1() { void method1(); void method(); } class a1 : interface1 { a1 b = new b(); b.method1(); b.method2(); } so without using interface also we can achieve this then wat is the need to use the interface? plz give me the answer

1 Answers  


What is hashtable in c# with example?

0 Answers  


What are Generics?

5 Answers   TCS,


Which controls do not have events?

0 Answers  






Tell me the difference between call by value and call by reference.

0 Answers   NIIT,


How do you specify a custom attribute for the entire assembly?

0 Answers  


What is desktop GUI application?

0 Answers  


What does public mean in c#?

0 Answers  


What is type checking in c#?

0 Answers  


Which is more efficient for loop or while loop?

0 Answers  


Is overriding of a function possible in the same class?

0 Answers  


Categories