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 |
How to get oledb connection?
Describe the disconnected architecture of ADO.NET’s data access model.
Explain what are the steps to connect to a database?
Can a DataReader be used as a DataSource for a GridView. If it is so how will you handle paging.
What is difference between sqldatareader and sqldataadapter?
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 to pass values into a datatable?
What does datareader object do?
Features and disadvantages of dataset?
2 Answers CarrizalSoft Technologies, Infosys, Microsoft, Sampath Software,
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
If a table contains 20000 records. In a page at each time 100 records to be displayed.