Connectivity Guide > Connectivity Guide > Understanding .NET Data Provider Connectivity > .NET Data Provider Classes > IngresCommandBuilder Class
Was this helpful?
IngresCommandBuilder Class
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
Last modified date: 01/30/2023