SQL and .NET interview Question – How ADO.NET differs from general ADO?

Answer:ADO.NET differs from general  ADO in the following way –

ADO works with connected data. This means that when you access data,
such as viewing and updating data, it is real-time, with a connection
being used all the time.
ADO. NET uses data in a disconnected fashion. When you access data,
ADO.NET makes a copy of the data using XML.
ADO allows you to create client-side cursors only. ADO.NET gives you the choice of either using client-side or
server-side cursors.
ADO allows you to persist records in XML format. ADO.NET allows you to manipulate your data using XML as the primary
means. This is nice when you are working with other business applications
and also helps when you are working with firewalls because data is passed
as HTML and XML.
ADO is statefull (TCP/IP). ADO.NET is stateless (Internet).
In ADO, we have a recordset. In ADO.NET, we have both recordset and dataset.
In recordset we can only have one table. If we want to accommodate
more than one tables we need to do inner join and fill the recordset.
Dataset can have multiple tables.

You will be also interested in watching the below video, which are also
asked in most of the interviews and favorable question of interviewers.

Please click here to see more  SQL /.NET interview questions


Visit Authors blog for more  .SQL / .NET interview questions

About c# and .NET Interview questions

This blog is for developers who want to crack .NET and C# interviews. It has all tips and tricks needed to crack .NET interviews , C# interview , SQL Server interview , Java interview , WCF Interview , Silverlight interview , WPF interview , LINQ interview , Entity framework Interview. Do not forget to watch our Learn step by step video series. Learn MVC in 16 hours:- https://www.youtube.com/watch?v=Lp7nSImO5vk Learn AngularJS Step by Step:- https://www.youtube.com/watch?v=0kmdjqgO9IY Learn Design Pattern in 8 hours:- https://www.youtube.com/watch?v=YDobmucohqk Learn C# and .NET in 60 days:- https://www.youtube.com/watch?v=yh2SrzCkNQA Learn MSBI in 32 hours:- https://www.youtube.com/watch?v=mGPJx3ocFgg Learn SharePoint Step by Step in 8 hours:- https://youtu.be/C2fW76SwJNU
This entry was posted in Uncategorized and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s