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

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

How to get oledb connection?

3 Answers  


Describe the disconnected architecture of ADO.NET’s data access model.

0 Answers  


Explain what are the steps to connect to a database?

0 Answers  


Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging.

3 Answers   Directi,


What is difference between sqldatareader and sqldataadapter?

0 Answers  






how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?

0 Answers  


How to pass values into a datatable?

0 Answers  


What does datareader object do?

0 Answers  


Features and disadvantages of dataset?

2 Answers   CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,


Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

0 Answers  


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

0 Answers  


If a table contains 20000 records. In a page at each time 100 records to be displayed.

0 Answers  


Categories