DB2 Version 10.1 for Linux, UNIX, and Windows

DB2CommandBuilder Members

The following tables list the members exposed by the DB2CommandBuilder class.

Public Constructors

Name Description
DB2®CommandBuilder()

Initializes a new instance of the DB2CommandBuilder class.

DB2CommandBuilder(DB2DataAdapter)

Initializes a new instance of the DB2CommandBuilder class with the associated DB2DataAdapter object.

Public Properties

Property Description
public property CatalogLocation Gets the CatalogLocation for this DB2CommandBuilder instance.
public property CatalogSeparator Gets the string representing a catalog separator for this DB2CommandBuilder instance.
public property ConflictOption Sets a value that specifies how conflicting changes to the data source gets detected and resolved.
public property Container (inherited from Component) Gets the IContainer that contains the Component.
public property DataAdapter Gets or sets a DB2DataAdapter object for which this DB2CommandBuilder object will generate SQL statements.
public property QuotePrefix Gets or sets the beginning character or characters to use when working with database objects (for example, tables or columns) whose names contain characters such as spaces or reserved tokens.
public property QuoteSuffix Gets or sets the ending character or characters to use when working with database objects, (for example, tables or columns), whose names contain characters such as spaces or reserved tokens.
public property SchemaSeparator Gets the string representing a schema separator for this DB2CommandBuilder instance.
public property Site (inherited from Component) Gets or sets the ISite of the Component.

Public Methods

Method Description
public method CreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public method static (Shared in Visual Basic) DeriveParameters Retrieves parameter information from the stored procedure specified in the DB2Command and populates the Parameters collection of the specified DB2Command object.
public method Dispose (inherited from Component) Overloaded. Releases the resources used by the Component.
public method Equals (inherited from Object) Overloaded. Determines whether two Object instances are equal.
public method GetDeleteCommand Gets the automatically generated DB2Command object required to perform deletions at the database.
public method GetHashCode (inherited from Object) Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public method GetInsertCommand Gets the automatically generated DB2Command object required to perform insertions at the database.
public method GetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public method GetType (inherited from Object) Gets the Type of the current instance.
public method GetUpdateCommand Gets the automatically generated DB2Command object required to perform updates at the database.
public method InitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public method QuoteIdentifier Accepts an unquoted identifier and returns the identifier in a quoted form.
public method RefreshSchema Refreshes the database schema information used to generate INSERT, UPDATE, or DELETE statements.
public method UnquoteIdentifier Accepts a quoted identifier and returns the identifier in an unquoted form.
public method ToString (inherited from Object) Returns a String that represents the current Object.

Public Events

Event Description
public event Disposed (inherited from Component) Adds an event handler to listen to the Disposed event on the component.

Protected Properties

Property Description
protected property DesignMode (inherited from Component) Gets a value that indicates whether the Component is currently in design mode.
protected property Events (inherited from Component) Gets the list of event handlers that are attached to this Component.

Protected Methods

Method Description
protected method ApplyParameterInfo Overloaded. Assigns a value to the DbParameter.DbType property using the data type from the DataRow. Used internally by DbCommandBuilder.
protected method Dispose Overloaded. Overridden. Releases the resources used by the DB2CommandBuilder.
protected method GetParameterName Overloaded. Returns the full name of the parameter using the partial parameter name.
protected method GetParameterPlaceholder Returns the placeholder for the parameter in the associated SQL statement.
protected method GetService (inherited from Component) Returns an object that represents a service provided by the Component or by its Container.
protected method MemberwiseClone (inherited from Object) Creates a shallow copy of the current Object.
protected method SetRowUpdatingHandler Registers the DB2CommandBuilder to handle the RowUpdating event for a DB2DataAdapter.