1. Categories >> Software >> Microsoft Related >> ADO.NET
  2. Suggest New Category

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

Question Posted / guest

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 a datatable?

8 Answers   State Bank Of India SBI,

what is a dataset?

9 Answers   Choice Solutions,

Which architecture does Datasets follow?

0 Answers  

Whate are different types of Commands available with DataAdapter ?

2 Answers  

What is sqldatareader?

0 Answers  




What is the difference in an abstract class and an interface?

0 Answers  

Define table relations?

0 Answers  

Which database is the ado.net sql connection object designed for?

0 Answers  

How to check if a datareader is closed or opened? IsClosed()

0 Answers  

What is ole data type?

0 Answers  

What is ado net stands for?

0 Answers  

Diff B/W DataSet vs DataTable

6 Answers   Star Wire,

For more ADO.NET Interview Questions Click Here
Categories