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

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

ADO ADO.NET
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

Regards,

Visit Authors blog for more  .SQL / .NET interview questions
About these ads

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.
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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s