Saturday, August 25, 2007

ADO.net > In-Memory Data Container Objects

IN-MEMORY DATA CONTAINER OBJECTS
• The System.Data namespace contains several collection-like objects that, combined, provide an in-memory representation of the DBMS relational programming model
• The DataSet is an in-memory cache of data made of tables, relations and constraints. Serializable and remotable, it can be filled from a variety of data sources and works regardless of which one is used
• DataTable represents a relational table of data with a collection of columns and rows
• DataRow represents a row in a DataTable object
• DataColumn represents a column in the DataTable object
• DataRelation class represents a relationship between two tables in the same DataSet. The relation is set on a common column
• DataView is defined on top of a table, it creates a filtered view of data. Can be configured to support editing and sorting. The data view is not a copy of the data - just a mask

No comments: