13-08-2012, 12:53 PM
Microsoft® ADO.NET
ADO.NET.ppt (Size: 156.5 KB / Downloads: 32)
Command Object
Information submitted to a database as a query via a Connection object
Two provider-specific classes
SqlCommand
OleDbCommand
Input and output parameters are supported, along with return values as part of the command syntax
Results are returned in the form of streams. Accessed by:
DataReader object
DataSet object via a DataAdapter
DataReader Object
Provides methods and properties that deliver a forward-only stream of data rows from a data source
When a DataReader is used, parts of the ADO.NET model are cut out, providing faster and more efficient data access
DataAdapter Object
Provides a set of methods and properties to retrieve and save data between a DataSet and its source data store
Allows the use of stored procedures
Connects to the database to fill the DataSet and also update the database
DataSet Object
Replaces the ADO Recordset
Represents a cache of data that contains tables, columns, relationships, and constraints, just like a database
Regardless of where the source data comes from, data can all be placed into DataSet objects
Tracks changes that are made to the data it holds before updating the source data
DataSet are also fully XML-featured
Works with all current models of data storage: flat, relational, and hierarchical