AseCommandBuilder Class

Automatically builds SQL insert, update, and delete statements for a single-table based on a SQL select statement.

Component

IDisposable

• AseCommandBuilder Constructors
  Initializes an AseCommandBuilder object.
• DataAdapter Property
  The AseDataAdapter for which to generate statements.
• DeleteCommand Property
  An AseCommand object that is executed against the database when Update() is called to delete rows in the database that correspond to deleted rows in the DataSet.
• DeriveParameters Method
  Populates the Parameters collection of the specified AseCommand object. This is used for the stored procedure specified in the AseCommand.
• Dispose Method
  Frees the resources associated with the object.
• GetDeleteCommand Method
  A generated AseCommand object, performs Delete operations on the database when AseDataAdapter.Update() is called.
• GetInsertCommand Method
  A generated AseCommand object, performs Insert operations on the database when an AseDataAdapter.Update() is called.
• GetUpdateCommand Method
  A generated AseCommand object, performs Update operations on the database when an AseDataAdapter.Update() is called.
• InsertCommand Property
  An AseCommand that is executed against the database when an Update() is called that adds rows to the database to correspond to rows that were inserted in the DataSet.
• PessimisticUpdate Property
  Indicates whether to implement pessimistic or optimistic update.
• QuotePrefix Property
  The beginning character or characters to use when specifying database object names that contain characters such as spaces.
• QuoteSuffix Property
  The ending character or characters to use when specifying database objects whose names contain characters such as spaces.
• RefreshSchema Method
  Refreshes the database schema information used to generate Insert, Update, or Delete statements.
• SelectCommand Property
  An AseCommand that is used during Fill or FillSchema to obtain a result set from the database for copying into a DataSet.
• UpdateCommand Property
  An AseCommand that is executed against the database when Update() is called to update rows in the database that correspond to updated rows in the DataSet.