IColumnMappingCollection IColumnMappingCollection IColumnMappingCollection IColumnMappingCollection Interface


Contains a collection of DataColumnMapping objects, and is implemented by the DataColumnMappingCollection, which is used in common by .NET Framework data providers.

public interface class IColumnMappingCollection : System::Collections::IList
public interface IColumnMappingCollection : System.Collections.IList
type IColumnMappingCollection = interface
    interface IList
    interface ICollection
    interface IEnumerable
Public Interface IColumnMappingCollection
Implements IList


The following example uses an instance of the derived class, DataTableMapping, to Add several DataColumnMapping objects to its ColumnMappings collection, and then displays a list of those mapped source tables. This example assumes that a DataTableMapping has already been created.

public void ShowColumnMappings() 
    // ...
    // create tableMapping
    // ...
    tableMapping.ColumnMappings.Add("Category Name","DataCategory");
    Console.WriteLine("Column Mappings");
    for(int i=0;i < tableMapping.ColumnMappings.Count;i++) 
        Console.WriteLine("  {0} {1}", i,
Public Sub ShowColumnMappings()
    ' ...
    ' create tableMapping
    ' ...
    tableMapping.ColumnMappings.Add( _
       "Category Name", "DataCategory")
    tableMapping.ColumnMappings.Add( _
       "Description", "DataDescription")
    tableMapping.ColumnMappings.Add( _
       "Picture", "DataPicture")
    Console.WriteLine("Column Mappings:")
    Dim i As Integer
    For i = 0 To tableMapping.ColumnMappings.Count - 1
        Console.WriteLine("  {0} {1}", i, _
    Next i
End Sub


The IColumnMappingCollection interface enables an inheriting class to implement a ColumnMapping collection. For more information, see DataAdapter DataTable and DataColumn Mappings.

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

Classes that inherit IColumnMappingCollection must implement all inherited members, and typically define additional members to add provider-specific functionality. For example, the IColumnMappingCollection interface defines the RemoveAt method. In turn, the DataTableMappingCollection class inherits this method, and defines two additional overloads of RemoveAt.

Notes to Implementers

When you inherit from the IColumnMappingCollection interface, you should implement the following constructor:

Item Description
ColumnMappingCollection() Creates an empty ColumnMappingCollection class.


Item[String] Item[String] Item[String] Item[String]

Gets or sets the IColumnMapping object with the specified SourceColumn name.


Add(String, String) Add(String, String) Add(String, String) Add(String, String)

Adds a ColumnMapping object to the ColumnMapping collection using the source column and DataSet column names.

Contains(String) Contains(String) Contains(String) Contains(String)

Gets a value indicating whether the DataColumnMappingCollection contains a DataColumnMapping object with the specified source column name.

GetByDataSetColumn(String) GetByDataSetColumn(String) GetByDataSetColumn(String) GetByDataSetColumn(String)

Gets the ColumnMapping object with the specified DataSet column name.

IndexOf(String) IndexOf(String) IndexOf(String) IndexOf(String)

Gets the location of the DataColumnMapping object with the specified source column name. The name is case-sensitive.

RemoveAt(String) RemoveAt(String) RemoveAt(String) RemoveAt(String)

Removes the IColumnMapping object with the specified SourceColumn name from the collection.

Extension Methods

Cast<TResult>(IEnumerable) Cast<TResult>(IEnumerable) Cast<TResult>(IEnumerable) Cast<TResult>(IEnumerable)

Casts the elements of an IEnumerable to the specified type.

OfType<TResult>(IEnumerable) OfType<TResult>(IEnumerable) OfType<TResult>(IEnumerable) OfType<TResult>(IEnumerable)

Filters the elements of an IEnumerable based on a specified type.

AsParallel(IEnumerable) AsParallel(IEnumerable) AsParallel(IEnumerable) AsParallel(IEnumerable)

Enables parallelization of a query.

AsQueryable(IEnumerable) AsQueryable(IEnumerable) AsQueryable(IEnumerable) AsQueryable(IEnumerable)

Converts an IEnumerable to an IQueryable.

Applies to