INTERVIEW QUESTIONS MICROSOFT DOTNET DETAILS

Question: Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?

Answer: The points of difference are as follows:

1. ADO.Net dataset can contain data from two or more data sources and relate it in memory. For example you may retrieve emp table from SQL Server 2000 database and salary table from an Excel sheet, relate them, perform any logical operations and put the integrated data to a new database in SQL server. Whereas, ADO recordset will contain records resulting from one query to one data source only.
2. ADO.Net objects are represented using XML, so they can travel through networks and firewalls. That is not the case with ADO recordsets which are COM objects.
3. Because of XML representation ADO.Net objects are lightweight as compared to ADO recordsets, so application scalability improves. The .net objects can be stored in session variables without much impact on scalability of the application.

The similarities in these two are that both of them can be disconnected (actually ADO.Net follows disconnected architecture, while ADO recordsets CAN BE disconnected, although many times they are used in a connected manner). Both of them offer sorting, filtering and batch updates.

The points of difference are as follows:

1. ADO.Net dataset can contain data from two or more data sources and relate it in memory. For example you may retrieve emp table from SQL Server 2000 database and salary table from an Excel sheet, relate them, perform any logical operations and put the integrated data to a new database in SQL server. Whereas, ADO recordset will contain records resulting from one query to one data source only.
2. ADO.Net objects are represented using XML, so they can travel through networks and firewalls. That is not the case with ADO recordsets which are COM objects.
3. Because of XML representation ADO.Net objects are lightweight as compared to ADO recordsets, so application scalability improves. The .net objects can be stored in session variables without much impact on scalability of the application.

The similarities in these two are that both of them can be disconnected (actually ADO.Net follows disconnected architecture, while ADO recordsets CAN BE disconnected, although many times they are used in a connected manner). Both of them offer sorting, filtering and batch updates. Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question