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 |
What is ODP.NET?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
Can you explain how to enable and disable connection pooling?
What is the meaning of executenonquery?
Define the executescalar method?
What are the key features of ado.net?
How to pass multiple tables in datasets simultaneously?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
What you mean by filtering of data?
How many commands does the oledbcommand takes?what are they?
What happens when we issue Dataset.ReadXml command?
Give few examples of datareader that is used in different dataproviders.
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)