SACommandBuilder class

A way to generate single-table SQL statements that reconcile changes made to a DataSet with the data in the associated database.

Visual Basic syntax

Public NotInheritable Class SACommandBuilder
    Inherits System.Data.Common.DbCommandBuilder

C# syntax

public sealed class SACommandBuilder : 
    System.Data.Common.DbCommandBuilder

Base classes

Members

All members of SACommandBuilder class, including all inherited members.

Name	Description
SACommandBuilder constructor	Initializes an SACommandBuilder object.
ApplyParameterInfo method (Inherited from System.Data.Common.DbCommandBuilder)	Allows the provider implementation of the System.Data.Common.DbCommandBuilder class to handle additional parameter properties.
DeriveParameters method	Populates the Parameters collection of the specified SACommand object.
Dispose method (Inherited from System.Data.Common.DbCommandBuilder)	Releases the unmanaged resources used by the System.Data.Common.DbCommandBuilder and optionally releases the managed resources.
GetDeleteCommand method	Returns the generated SACommand object that performs DELETE operations on the database when SADataAdapter.Update is called.
GetInsertCommand method	Returns the generated SACommand object that performs INSERT operations on the database when an Update is called.
GetParameterName method (Inherited from System.Data.Common.DbCommandBuilder)	Returns the name of the specified parameter in the format of @p#.
GetParameterPlaceholder method (Inherited from System.Data.Common.DbCommandBuilder)	Returns the placeholder for the parameter in the associated SQL statement.
GetSchemaTable method (Inherited from System.Data.Common.DbCommandBuilder)	Returns the schema table for the System.Data.Common.DbCommandBuilder.
GetUpdateCommand method	Returns the generated SACommand object that performs UPDATE operations on the database when an Update is called.
InitializeCommand method (Inherited from System.Data.Common.DbCommandBuilder)	Resets the System.Data.Common.DbCommand.CommandTimeout, System.Data.Common.DbCommand.Transaction, System.Data.Common.DbCommand.CommandType, and System.Data.UpdateRowSource properties on the System.Data.Common.DbCommand.
QuoteIdentifier method	Returns the correct quoted form of an unquoted identifier, including properly escaping any embedded quotes in the identifier.
RefreshSchema method (Inherited from System.Data.Common.DbCommandBuilder)	Clears the commands associated with this System.Data.Common.DbCommandBuilder.
RowUpdatingHandler method (Inherited from System.Data.Common.DbCommandBuilder)	Adds an event handler for the System.Data.OleDb.OleDbDataAdapter.RowUpdating event.
SetRowUpdatingHandler method (Inherited from System.Data.Common.DbCommandBuilder)	Registers the System.Data.Common.DbCommandBuilder to handle the System.Data.OleDb.OleDbDataAdapter.RowUpdating event for a System.Data.Common.DbDataAdapter.
UnquoteIdentifier method	Returns the correct unquoted form of a quoted identifier, including properly un-escaping any embedded quotes in the identifier.
CatalogLocation property (Inherited from System.Data.Common.DbCommandBuilder)	Sets or gets the System.Data.Common.CatalogLocation for an instance of the System.Data.Common.DbCommandBuilder class.
CatalogSeparator property (Inherited from System.Data.Common.DbCommandBuilder)	Sets or gets a string used as the catalog separator for an instance of the System.Data.Common.DbCommandBuilder class.
ConflictOption property (Inherited from System.Data.Common.DbCommandBuilder)	Specifies which System.Data.ConflictOption is to be used by the System.Data.Common.DbCommandBuilder.
DataAdapter property	Specifies the SADataAdapter for which to generate statements.
QuotePrefix property (Inherited from System.Data.Common.DbCommandBuilder)	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 property (Inherited from System.Data.Common.DbCommandBuilder)	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.
SchemaSeparator property (Inherited from System.Data.Common.DbCommandBuilder)	Gets or sets the character to be used for the separator between the schema identifier and any other identifiers.
SetAllValues property (Inherited from System.Data.Common.DbCommandBuilder)	Specifies whether all column values in an update statement are included or only changed ones.

SACommandBuilder constructor
DeriveParameters method
GetDeleteCommand method
GetInsertCommand method
GetUpdateCommand method
QuoteIdentifier method
UnquoteIdentifier method
DataAdapter property

Discuss this page in DocCommentXchange.