All You Need to Know about ADO.NET: Part 2/2
page 7 of 27
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 90526/ 170

ADO.NET's Disconnected Architecture
We have been continuously stressing that ADO.NET uses a disconnected architecture. With the ever-increasing demand on the Web, data requirements are changing. Now, scalability has become a major issue thanks to the ever growing population of the web. Another aspect is availability of an open connection for the data all of the time. Both these issues require that applications should connect to the data source, read required data and disconnect the connection, process the data, reconnect and save the changes. Using disconnected RecordSets is tedious with ADO due to marshalling issues. All this was leading to disconnected architecture for quite some time now.

It was but natural that Microsoft would introduce this architecture in the latest version of ADO, which is ADO.NET. We have just seen how to use a Connection object, a Command object and a DataReader to perform database operations. This is good enough when you want to process only one row at a time. In practice however, one needs to process or display multiple rows at a time. In such cases, it is difficult to use the DataReader. Therefore, ADO.NET provides other objects for such operations. These objects are mostly use in a disconnected environment.

View Entire Article

User Comments

Title: disconnected architecture   
Name: kinjalpadashala
Date: 2012-02-14 3:19:39 AM
p/z help me how to select the data in grid and bind of textbox.
Title: thank you   
Name: kartik
Date: 2011-03-24 1:04:35 AM
is it posibile to insert the record enter at the 1st row of database every time?
Title: Connected Architecture   
Name: Vidhya Patel, India(mota)
Date: 2011-03-08 11:27:53 PM
I use this content in my's very useful for me....... so thanks a lot
Name: Manimegalai
Date: 2010-09-15 3:31:43 AM
That is great collection
thank u;;;;;;;;;;;;;;
Title: Thanks   
Name: Amin Anwar
Date: 2009-05-14 5:19:09 AM
That isgr8 collection;;;
Name: Saurabh Shrivastava
Date: 2007-02-20 11:46:46 AM
Brilliant Work,It could be more useful by giving some code in it.
Title: Thank you   
Name: Jayalakshmi baskaran
Date: 2006-05-30 5:39:23 AM
I want to create the sqldataAdapter and the Dataset in Code
Can you please help it out
Title: Ado.Net   
Name: Rohan Ragoo
Date: 2006-01-09 12:37:59 PM
Excellent Overview. All topics are dicussed in an effective timeline.
Title: XML   
Name: Rajesh Medackel,India
Date: 2005-10-01 5:26:30 AM
Good write up .... Thanx
Title: ADO.Net   
Name: k
Date: 2005-05-03 11:31:30 AM
to the authors thanks a lot for the unselfish information

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-07-15 4:53:07 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search