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
If a table contains 20000 records. In a page at each time 100 records to be displayed.
What is ole2 format?
What is the meaning of executenonquery?
What do you mean by ‘batch updates’?
how Sequence to connect and retrieve data from database using dataset?
What is ado asp?
What is disconnected architecture in ado.net?
What you mean by filtering of data?
What is commandbuilder in ado.net?
Which is faster entity framework or ado.net?
What does executequery return?
Which is faster sqldataadapter and sqldatareader?
What are all features of ADO.Net?
Is it possible to load multiple tables in a Dataset?
Define Execute Scalar?