Showing posts with label what is ADO and ADO.net. Show all posts
Showing posts with label what is ADO and ADO.net. Show all posts

Wednesday, March 30, 2016

What is the difference between ADO and ADO.Net?


ADO
ADO.Net
Used connected data usage
Used disconnected data environment
Provided by record set
Provided by data set
Data is stored in binary format
Data is stored in XML format
It is COM based library
It is CLR based library
XML integration is not possible
XML integration is possible
ADO allows to create client-side cursors only
ADO.NET gives you the choice of either using client-side or server-side cursors
Join cannot be allow
Allow
Constraint cannot allow
Allow
Trigger cannot allow
Allow