DataAdapter.MissingMappingAction Property

Definition

Namespace:

System.Data.Common

Assemblies:

netstandard.dll, System.Data.Common.dll

Source:

DataAdapter.cs

Determines the action to take when incoming data does not have a matching table or column.

public:
 property System::Data::MissingMappingAction MissingMappingAction { System::Data::MissingMappingAction get(); void set(System::Data::MissingMappingAction value); };

public System.Data.MissingMappingAction MissingMappingAction { get; set; }

member this.MissingMappingAction : System.Data.MissingMappingAction with get, set

Public Property MissingMappingAction As MissingMappingAction

Property Value

MissingMappingAction

One of the MissingMappingAction values. The default is Passthrough.

Implements

MissingMappingAction

Exceptions

ArgumentException

The value set is not one of the MissingMappingAction values.

Examples

The following example creates a derived class, OleDbDataAdapter and sets some of its properties.

// Assumes a valid connection string to an Access database.
static void CreateOleDbAdapter(string connectionString)
{
    OleDbDataAdapter adapter = new OleDbDataAdapter();
    adapter.SelectCommand =
        new OleDbCommand("SELECT * FROM Categories ORDER BY CategoryID");
    adapter.SelectCommand.Connection =
        new OleDbConnection(connectionString);
    adapter.MissingMappingAction = MissingMappingAction.Error;
    adapter.MissingSchemaAction = MissingSchemaAction.Error;
}

' Assumes a valid connection string to an Access database.
Private Sub CreateOleDbDataAdapter(ByVal connectionString As String)
    Dim adapter As New OleDbDataAdapter()
    adapter.SelectCommand = _
       New OleDbCommand("SELECT * FROM Categories ORDER BY CategoryID")
    adapter.SelectCommand.Connection = New OleDbConnection _
       (connectionString)
    adapter.MissingMappingAction = MissingMappingAction.Error
    adapter.MissingSchemaAction = MissingSchemaAction.Error
End Sub

Remarks

The TableMappings property provides the primary mapping between the returned records and the DataSet.

See also

• MissingSchemaAction
• ADO.NET Overview