IngresCommandBuilder Class

9. Understanding .NET Data Provider Connectivity : .NET Data Provider Classes : IngresCommandBuilder Class

Share this page

The IngresCommandBuilder class automatically generates INSERT, DELETE, and UPDATE commands into an IngresDataAdapter object for a simple single-table SELECT query. These commands can be used to reconcile DataSet changes through the IngresDataAdapter associated with the Ingres or Vector database.

IngresCommandBuilder Class Declaration

The IngresCommandBuilder class can be declared as follows:

C#: public sealed class IngresCommandBuilder : DbCommandBuilder

VB.NET: NotInheritable Public Class IngresCommandBuilder
Inherits DbCommandBuilder

IngresCommandBuilder Class Properties

The IngresCommandBuilder class properties are:

Property	Accessor	Description
CatalogLocation	get set	Position of the catalog name in a qualified table name.
CatalogSeparator	get set	The string of characters that defines the separation between a catalog name and the table name.
ConflictOption	get set	Controls how to compare for update conflicts.
DataAdapter	get set	The IngresDataAdapter object that is associated with the CommandBuilder. The IngresDataAdapter contains the InsertCommand, DeleteCommand, and UpdateCommand objects that are automatically derived from the SelectCommand.
QuotePrefix	get set	The string of characters that are used as the starting delimiter of a quoted table or column name in an SQL statement.
QuoteSuffix	get set	The string of characters that are used as the ending delimiter of a quoted table or column name in an SQL statement.
SchemaSeparator	get set	The string of characters that defines the separation between a table name and column name. Always a period (.)

IngresCommandBuilder Class Methods

The public methods available to the IngresCommandBuilder class are:

Method	Description
Derive Parameters	Retrieves the parameter metadata of the database procedure specified in the IngresCommand object and populates the IngresCommand.Parameters collection.
GetDeleteCommand	Gets the generated IngresCommand to perform DELETE operations on the table.
GetInsertCommand	Gets the generated IngresCommand to perform INSERT operations on the table.
GetUpdateCommand	Gets the generated IngresCommand to perform UPDATE operations on the table.
QuoteIdentifier	Wrap quotes around an identifier.
RefreshSchema	Refreshes the IngresCommandBuilder's copy of the metadata of a possibly changed SELECT statement in the IngresDataAdapter.SelectCommand object.
UnquoteIdentifier	Removes quotes from an identifier.

IngresCommandBuilder Class Constructors

The IngresCommandBuilder class has the following constructors:

Constructor Overloads	Description
IngresCommandBuilder ()	Instantiates a new instance of the IngresCommandBuilder class using default property values
IngresCommandBuilder (IngresDataAdapter)	Instantiates a new instance of the IngresCommandBuilder class using the specified IngresDataAdapter