%META:TOPICPARENT{name="NETDataProvidersClassImplementation"}%

===<nop>OPLCommandBuilder===

Automatically generates single-table commands used to reconcile changes made to a <nop>DataSet with the associated data source.

{{{
public sealed class OPLCommandBuilder : Component
}}}

====Constructors====

{{{
public OPLCommandBuilder ();
}}}

Initializes a new instance of the <nop>OPLCommandBuilder class.

{{{
public OPLCommandBuilder (OPLDataAdapter adapter);
}}}

Initializes a new instance of the <nop>OPLCommandBuilder class with the associated OPLDataAdapter object.

====Methods====

{{{
public static void DeriveParameters (OPLCommand command);
}}}

Retrieves parameter information from the stored procedure specified in the OPLCommand and populates the Parameters collection of the specified OPLCommand object.

{{{
protected override void Dispose (bool disposing);
}}}

Releases the resources used by the <nop>OPLCommandBuilder.

{{{
public OPLCommand GetDeleteCommand ();
}}}

Gets the automatically generated OPLCommand object required to perform deletions at the data source.

{{{
public OPLCommand GetInsertCommand ();
}}}

Gets the automatically generated OPLCommand object required to perform insertions at the data source.

{{{
public OPLCommand GetUpdateCommand ();
}}}

Gets the automatically generated OPLCommand object required to perform updates at the data source.

{{{
public void RefreshSchema ();
}}}

Refreshes the database schema information used to generate INSERT, UPDATE, or DELETE statements.

====Properties====

{{{
public OPLDataAdapter DataAdapter {get; set;}
}}}

Gets or sets an OPLDataAdapter object for which this <nop>OPLCommandBuilder object will generate SQL statements.

{{{
public string QuotePrefix {get; set;}
}}}

Gets or sets the beginning character or characters to use when working with database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.

{{{
public string QuoteSuffix {get; set;}
}}}

Gets or sets the ending character or characters to use when working with database objects, (for example, tables or columns), whose names contain characters such as spaces or reserved tokens.