Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere .NET 2.0 API Reference » iAnywhere.Data.SQLAnywhere namespace (.NET 2.0) » SACommandBuilder class

 

SACommandBuilder members

Public constructors
Member name Description

SACommandBuilder constructors

Initializes a new instance of the SACommandBuilder class.

Public properties
Member name Description

[external link] CatalogLocation (inherited from DbCommandBuilder)

Sets or gets the [external link] CatalogLocation for an instance of the [external link] DbCommandBuilder.

[external link] CatalogSeparator (inherited from DbCommandBuilder)

Sets or gets a string used as the catalog separator for an instance of the [external link] DbCommandBuilder.

[external link] ConflictOption (inherited from DbCommandBuilder)

Specifies which [external link] ConflictOption is to be used by the [external link] DbCommandBuilder.

DataAdapter property

Specifies the SADataAdapter for which to generate statements.

[external link] QuotePrefix (inherited from 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.

[external link] QuoteSuffix (inherited from 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.

[external link] SchemaSeparator (inherited from DbCommandBuilder)

Gets or sets the character to be used for the separator between the schema identifier and any other identifiers.

[external link] SetAllValues (inherited from DbCommandBuilder)

Specifies whether all column values in an update statement are included or only changed ones.

Public methods
Member name Description

DeriveParameters method

Populates the Parameters collection of the specified SACommand object. This is used for the stored procedure specified in the SACommand.

GetDeleteCommand methods

Returns the generated SACommand object that performs DELETE operations on the database when SADataAdapter.Update is called.

GetInsertCommand methods

Returns the generated SACommand object that performs INSERT operations on the database when an Update is called.

GetUpdateCommand methods

Returns the generated SACommand object that performs UPDATE operations on the database when an Update is called.

QuoteIdentifier method

Returns the correct quoted form of an unquoted identifier, including properly escaping any embedded quotes in the identifier.

[external link] RefreshSchema (inherited from DbCommandBuilder)

Clears the commands associated with this [external link] DbCommandBuilder.

UnquoteIdentifier method

Returns the correct unquoted form of a quoted identifier, including properly un-escaping any embedded quotes in the identifier.

See also