ADO.NET in Disconnected Mode

ADO.NET in Disconnected ModeYou see how ADO.NET differs from its predecessor when you start working in disconnected mode. ADO 2.x permits you to work in disconnected mode using client-side static recordsets opened in optimistic batch update mode. This was one of the great new features of ADO that has proved to be a winner in client/ server applications of any size. As a matter of fact, working in disconnected mode is the most scalable technique you can adopt because it takes resources on the client (instead of on the server) and, above all, it doesn”t enforce any locks on database tables (except for the short-lived locks that are created during the update operation).

…
Exploring the DataSet Object Model
The DataSet is the root and the most important object in the object hierarchy that includes almost all the objects in the System.Data namespace. Figure 21-1 shows the most important classes in this hierarchy, with the name of the property that returns each object.
An important feature of the DataSet class is its ability to define relationships between its DataTable objects, much like what you do in a real database. For example, you can create a relationship between the Publishers and the Titles DataTable objects by using the PubId DataColumn that they have in common. After you define a DataRelation object, you can navigate from one table to another, using the DataTable’’s ChildRelations and ParentRelations properties.
A DataSet object consists of one or more DataTable objects, each one containing data coming from a database query, an XML stream, or code added programmatically. Table 21-1 summarizes the most important members of the DataSet class.
…

Website: www.vbmigration.com | Filesize: 4864kb
No of Page(s): 96
Click here to download ADO.NET in Disconnected Mode.

Related Copyrighted Books

Related Tutorial

Filed Under C#, Database 

Tags: , , , ,

Comments

Leave a Reply