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
What is openquery?
Define ado.net?
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?
How can we add relation between tables in a dataset?
What is disconnected scenario in entity framework?
What is a serialized object?
how we can fire event in databound coulm in datagfrid withot using button?
What is the use of Dataview?
What does executereader return?
What are the uses of Stored Procedure?
What is difference between ado and other data object?
What is datasource in ado.net?
What is row state?
How to work with disconnected data - the dataset and sqldataadapter?
Explain advantages of ado.net?