Export (0) Print
Expand All

ITableMapping Interface

Associates a source table with a table in a DataSet, and is implemented by the DataTableMapping class, which is used in common by .NET Framework data providers.

Namespace:  System.Data
Assembly:  System.Data (in System.Data.dll)

public interface ITableMapping

The ITableMapping type exposes the following members.

  NameDescription
Public propertySupported by the XNA FrameworkColumnMappingsGets the derived DataColumnMappingCollection for the DataTable.
Public propertySupported by the XNA FrameworkDataSetTableGets or sets the case-insensitive name of the table within the DataSet.
Public propertySupported by the XNA FrameworkSourceTableGets or sets the case-sensitive name of the source table.
Top

The ITableMapping interface allows an inheriting class to implement a TableMapping class, which associates a data source column with a DataSet column. For more information, see DataAdapter DataTable and DataColumn Mappings.

An application does not create an instance of the ITableMapping interface directly, but creates an instance of a class that inherits ITableMapping.

Classes that inherit ITableMapping must implement the inherited members, and typically define additional members to add provider-specific functionality. For example, the ITableMapping interface defines the DataSetTable property. In turn, the DataTableMapping class inherits this property, and also defines the GetDataTableBySchemaAction method.

Notes to Implementers

When you inherit from the ITableMapping interface, you should implement the following constructors:

Item

Description

DataTableMapping()

Initializes a new instance of the TableMapping class.

TableMapping(string sourceTable, string dataSetTable)

Initializes a new instance of the TableMapping class with a source when given a source table name and a DataTable name.

TableMapping(string sourceTable, string dataSetTable, DataColumnMapping[] columnMappings)

Initializes a new instance of the TableMapping class when given a source table name, a DataTable name, and an array of ColumnMapping objects.

The following example creates an instance of the derived class, DataTableMapping, and adds it to a DataTableMappingCollection collection. It then informs the user that the mapping was added to the collection and displays the parent mapping.

public void AddDataTableMapping() 
{
    // ... 
    // create tableMappings 
    // ...
    DataTableMapping mapping =
        new DataTableMapping("Categories","DataCategories");
    tableMappings.Add((Object) mapping);
    Console.WriteLine("Table {0} added to {1} table mapping collection.",
        mapping.ToString(), tableMappings.ToString());
}

.NET Framework

Supported in: 4.5.2, 4.5.1, 4.5, 4, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8.1, Windows Server 2012 R2, Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Show:
© 2014 Microsoft