Working with Data—ADO.NET Classes
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
| CSharp-Online.NET:Articles |
| Database Articles |
|
© 2006 Jeffery Suddeth |
The ADO.NET Classes
ADO.NET is the portion of the .NET library that deals with databases. Table 15.3 lists some of the common ADO.NET classes.
Table 15.3 – Classes of ADO.NET
| Class | Description | |
DataSet
| A set of database tables that can be filled from a database and used as a disconnected database | |
DataTable
| A collection data rows and the columns that define their structure | |
DataRow
| A database Record | |
DataView
| A view of the data. Can be filtered for search criteria and sorted | |
DataRowView
| A single row from a DataView | |
DataRelation
| A parent-child relationship between tables |
The classes in Table 15.3 organize the data into table structures. They are declared within the System.Data namespace. The DataSet class is one of the most useful classes in .NET; because, it encapsulates a collection of tables and the relationships between those tables. It is essentially a mini database that you can use in memory. You can also fill the DataSet with tables and data from some other database, giving you a local cache of data.
 
|
