Db Builder Command
Db Builder Command
Db Builder Command
Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated database. This is an abstract class that can only be inherited.
public ref class DbCommandBuilder abstract : System::ComponentModel::Component
public abstract class DbCommandBuilder : System.ComponentModel.Component
type DbCommandBuilder = class inherit Component
Public MustInherit Class DbCommandBuilder Inherits Component
The DbCommandBuilder class is provided for the convenience of provider writers creating their own command builders. By inheriting from this class, developers can implement provider specific behavior in their own code.
The DbDataAdapter does not automatically generate the SQL statements required to reconcile changes made to a DataSet with the associated data source. However, you can create a DbCommandBuilder object to automatically generate SQL statements for single-table updates if you set the SelectCommand property of the DbDataAdapter. Then, any additional SQL statements that you do not set are generated by the DbCommandBuilder.
The DbCommandBuilder registers itself as a listener for RowUpdating events whenever you set the DataAdapter property. You can only associate one DbDataAdapter or DbCommandBuilder object with each other at one time.
To generate INSERT, UPDATE, or DELETE statements, the DbCommandBuilder uses the SelectCommand property to retrieve a required set of metadata automatically. If you change the SelectCommand after the metadata has been retrieved (for example, after the first update), you should call the RefreshSchema method to update the metadata.
SelectCommand must also return at least one primary key or unique column. If none exist, an InvalidOperationException exception is generated, and the commands are not generated.
The DbCommandBuilder also uses the Connection, CommandTimeout, and Transaction properties referenced by the SelectCommand. The user should call RefreshSchema if any of these properties are modified, or if the SelectCommand itself is replaced. Otherwise the InsertCommand, UpdateCommand, and DeleteCommand properties retain their previous values.
|DbCommandBuilder() DbCommandBuilder() DbCommandBuilder() DbCommandBuilder()||
Initializes a new instance of a class that inherits from the DbCommandBuilder class.
|CanRaiseEvents CanRaiseEvents CanRaiseEvents CanRaiseEvents||
Gets a value indicating whether the component can raise an event.(Inherited from Component)
|CatalogLocation CatalogLocation CatalogLocation CatalogLocation|
|CatalogSeparator CatalogSeparator CatalogSeparator CatalogSeparator||
Sets or gets a string used as the catalog separator for an instance of the DbCommandBuilder class.
|ConflictOption ConflictOption ConflictOption ConflictOption|
|Container Container Container Container||Component)|
|DataAdapter DataAdapter DataAdapter DataAdapter||
Gets or sets a DbDataAdapter object for which Transact-SQL statements are automatically generated.
|DesignMode DesignMode DesignMode DesignMode||
Gets a value that indicates whether the Component is currently in design mode.(Inherited from Component)
|Events Events Events Events||
Gets the list of event handlers that are attached to this Component.(Inherited from Component)
|QuotePrefix QuotePrefix QuotePrefix QuotePrefix||
Gets or sets the beginning character or characters to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.
|QuoteSuffix QuoteSuffix QuoteSuffix QuoteSuffix||
Gets or sets the ending character or characters to use when specifying database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.
|SchemaSeparator SchemaSeparator SchemaSeparator SchemaSeparator||
Gets or sets the character to be used for the separator between the schema identifier and any other identifiers.
|SetAllValues SetAllValues SetAllValues SetAllValues||
Specifies whether all column values in an update statement are included or only changed ones.
|Site Site Site Site||Component)|
|Disposed Disposed Disposed Disposed||
Occurs when the component is disposed by a call to the Dispose() method.(Inherited from Component)