What is the difference between connected and disconnected architecture in asp.net

It is amazing and wonderful to visit your site. Thanks for sharing this information,this is useful. I have read your blog its very attractive and impressive. I like it your blog. Real Time Experts Training in Bangalore center address bangalore. Thank you for sharing nice blog sql course in uttam nagar. Thanks for a marvelous posting! I seriously enjoyed reading it, you are a great author.

I will be sure to bookmark your blog and will often come back in the future. I want to encourage yourself to continue your great job, have a nice weekend! Excellent content! Thanks for sharing such a useful information.

Fantastic blog! Thanks for sharing a very interesting post, I appreciate to blogger for an amazing post. That's really impressive and helpful information you have given, very valuable content. We are also into education and you also can take advantage really awesome job oriented courses. Great post. Thank you for sharing such useful information.

Post a Comment. October 14, Connected Architecture of ADO. The architecture of ADO. Connected architecture was built on the classes connection, command, datareader and transaction.

Chapter 2 examines. NET data providers in more detail and describes the way in which they provide connected functionality and serve as a bridge to disconnected functionality. Skip to main content. Start your free trial. Connected and Disconnected Data.

Connected Classes. Connection Maintains information required to connect to the data source through a connection string. Command Executes SQL statements or stored procedures against the data source. DataReader Provides connected forward-only, read-only access to the data source. Parameter Allows parameters for both parameterized queries and stored procedures to be defined and set to appropriate values.

Transaction Allows transactions to be created on a connection so that multiple changes to data in a data source are treated as a single unit of work and either all committed or cancelled. Disconnected Classes. DataSet Provides a consistent way to deal with disconnected data completely independently of the data source. DataTable Allows disconnected data to be examined and modified through a collection of DataColumn and DataRow classes.

DataColumn Corresponds to a column in a table. Toggle navigation. Connected and Disconnected architecture in Ado. Jul 08, Ado. NET architecture, Views. The Ado. Connected Architecture As the name suggests, connected architecture refers to the fact that the connection is established for the full time between the database and application. Connected architecture is forward only and read-only.

This means the connected mode will work only in one particular direction i. You could minimize it to the Task Bar or whatever , and make the updates any time. The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Getting Started with ASP. NET question on a topic that's not covered by one of the other more specific forums - ask it here. Sign in to vote. User posted hi ll can anyone tell me what is connected and disconnected architecture is..

Wednesday, December 31, AM. User posted Hi chithrar, Disconnected architecture is a method of retrieving a record set from the database and storing it giving you the ability to do many CRUD Create, Read, Update, Delete operations on the data in memory, then it can be re-synchronized with the database when reconnecting.