Difference Between Ado and Ado.Net :-
Ado:-
- ado is a base on COM: component object modelling based
- ado store data in binary format
- ado can't be integrated with xml because ado have limited access of xml
- in ado,data is provided by record set
- ado.net is connection oriented means it require continuous active connection.
- in ado,you can create only client side cursor
- uses the record set objects which looks like a single table.
- scans the rows sequentially.
- requires a JOIN query to combine data from multiple tables in a single result tables.
AdO.Net:-
- ado.net is based on clr:common language run time based .
- ado.net store data in xml former i.e parsing of data.
- ado.net can be integrated with xml as having robust support of xml.
- in ado.net is provided by data set or data adapter
- ado.net is disconnected does not need continuous connection.
- in ado.net you can create both client and server side cursor.
- uses the data set object, which contains one or more tables represented by data table objects.
- uses navigation model for non-sequential access to rows in a tables. tracks relationships to navigate from rows in one table to corresponding rows in another tables
- provide the data relation object for combining data from multiple data table objects without requiring a join query .
IN HINDI:-
ADO: -
- ado COM पर एक आधार है: घटक ऑब्जेक्ट मॉडलिंग आधारित
- द्विआधारी प्रारूप में एडीओ स्टोर डेटा
- एडीओ को एक्सएमएल के साथ एकीकृत नहीं किया जा सकता क्योंकि एडीओ को एक्सएमएल का सीमित एक्सेस है
- एडीओ में, डेटा रिकॉर्ड सेट द्वारा प्रदान किया जाता है
- Ado.net कनेक्शन उन्मुख है जिसका मतलब है कि यह लगातार सक्रिय कनेक्शन की आवश्यकता है।
- एडीओ में, आप केवल क्लाइंट साइड कर्सर बना सकते हैं
- Ado.net में आप क्लाइंट और सर्वर साइड कर्सर दोनों बना सकते हैं।
.Net Framework Notes
EmoticonEmoticon