Template:ADO.NET Diagram

• Connection - used to connect the data consumer ASP.NEt to a Data Provider
• Command - used to issue SQL commands to a Data Provider
• DataReader - A fast forward only DataSet that holds one or more resultsets.Fast and efficient
• DataSet - can contain multiple tables and relationships between tables
• DataAdapter - Passes Data from a Connection object to a DataSet and updates that data. ( A bridge used to fill dataSets with DataAdapter.Fill and DataAdapter.Update)
• DataTable - structure that holds a set of rows and columns
• DataRelation - holds relations between DataTables in a DataSet
• DataRow - data within data row
• DataView - a specific view of the DataTables within a Dataset

Connection
DataAdapter	DataReader
DataSet DataTable DataView DataRow DataRow DataRow DataTable DataRow DataRow DataRow DataTable DataRow DataRow DataRow