INTERVIEW QUESTIONS MICROSOFT ADO.NET DETAILS

Question: What is the difference between ADO and ADO.NET?

Answer: ADO is used in windows based application and ADO.NET is used in web based application.

ADO is used in windows based application and ADO.NET is used in web based application. Source: CoolInterview.com

ADO is mainly used for data Access and its an Connection Oriented.
where as ADO.Net is also used for Data Access and its an Connectionless Oriented. Source: CoolInterview.com

ADO:-
--------

-Ado is a connected architecture.
-Ado is supported by Lock Types.

ADO.Net:-
----------
-Ado.Net is a Disconnected Architecture.
-Ado.Net is not supported by Lock Types. Source: CoolInterview.com

Main difference is that ADO.Net is mainly XML based and by using datasets we can get disconnected recordset. Source: CoolInterview.com

1.Ado is created using COM technology,whereas Ado.net is implemented by using .NET framework technology.

2.In ADO we can store only one table,whereas in ado.net we can store multiple tables in the dataset.

3.In ADO we can't generate relations whereas in ADO.NET we can generate relations.

4.In ADO we can't generate SQL statements whereas in ADO.NET we can generate SQL statements.

5.ADO is connection-oriented,but ADO.NET is connectionless. Source: CoolInterview.com

ADO:
1)ActiveX data object is a connection oriented
2)No connection with XML
Advantage:
i) 24/7 online
ii) updated information
Disadvantage:
1)slow processing

ADO.NET:
1)It's disconnected architecture
2)connection with xml & sql server only
Advantage:
i)fast processing
Disadvantage:
No update information Source: CoolInterview.com

ADO:
it use RecordSet
ADO.NET:
it uses Dataset
Source: CoolInterview.com

1.In case of ADO memory represantation of data is record set,
and In case of ADO.NET memory represantation of data is dataset.
2.uses of xml is very restricted in ADO.
We can use xml in ADO.NET. Source: CoolInterview.com

1.ADO is a connection oriented architecture where as ADO.NET is a connection less architecture.

2.In ADO we can use recordset on the other hand in ADO.NET we can use Data set.
Data set can hold table in bulk
The ADO Recordset object is used to hold a set of records from a single table Source: CoolInterview.com

ADO allows you to create client-side cursors only.
whereas ADO.NETgives you to choice either using client side or server side cursors. Source: CoolInterview.com

difference between ado and ado.net 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