Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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 (ADO.NET).

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, 3.5, 3.0, 2.0, 1.1, 1.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.