What are advantages and disadvantages of Microsoft-provided
data provider classes in ADO.NET?
Answers were Sorted based on User's Feedback
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 |
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 |
Explain the difference between data reader and data set?
Explain what is datagrid with an example?
What is microsoft ado.net?
What is the role of data provider in ado.net?
Diff B/W DataSet vs DataTable
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is an orm, and why would you use one instead of plain old ado.net?
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?
How to read data with the sqldatareader ?
What is XML serialization
Can you explain how to enable and disable connection pooling?
We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?
6 Answers Accenture, FastStream,
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)