What are advantages and disadvantages of Microsoft-provided
data provider classes in ADO.NET?
Answer Posted / 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 View All Answers
Describe datareader object of ado.net with example.
How to maintain the relation between two tables in ADO.NET?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
How will you fill the gridview by using datatable object at runtime?
Explain executenonquery?
What is sqldatareader?
What is difference between ado.net and asp net?
What are two important objects of ADO.Net?
Explain the difference between sqlcommand object and command behavior object?
What is the difference between ado.net and entity framework?
Which property is used to check whether a DataReader is closed or opened?
How does ado.net work?
How to add a check box or a dropdown list to a column in a datagrid?
What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
What are the uses of Stored Procedure?