What are advantages and disadvantages of Microsoft-provided data provider class

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

Question Posted / guest

2 Answers
11255 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / destiny

Disadvantages
• Easily gets virus, and spyware.
• does not come with many useful software already
installed,
• Easily disrupted by other programs.
• Expensive to purchase.
• has bugs (slowly being fixed though)
• Multiple security issues.
Advantages
. Alot of games already on computer
.

Is This Answer Correct ?

4 Yes

3 No

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

Answer / guest

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 ?

2 Yes

6 No

Post New Answer

More ADO.NET Interview Questions

What is sqldatareader?

0 Answers

What?s the role of the DataReader class in ADO.NET connections?

7 Answers Honeywell, Ksb,

What is the difference between an ADO.NET Dataset and an ADO Recordset?

0 Answers

What is the difference between oledbreader and datasetwhile connecting?