MimerCommandBuilder Class

This class automatically generates SQL commands used to reconcile changes made to a DataSet with the associated data source.

For a list of all members of this type, see MimerCommandBuilder Members.

System.Object
   MarshalByRefObject
      Component
         MimerCommandBuilder

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Remarks

The MimerDataAdapter does not automatically generate the SQL statements required to reconcile changes made to a DataSet associated with the data source. However, you can create an MimerCommandBuilder object that generates SQL statements for single-table updates by setting the SelectCommand property of the MimerDataAdapter. Then, the MimerCommandBuilder generates any additional SQL statements that you do not set.

The relationship between an MimerDataAdapter and its corresponding MimerCommandBuilder is always one-to-one. To create this correspondence, you set the MimerDataAdapter property of the MimerCommandBuilder object. This causes the MimerCommandBuilder to register itself as a listener, which produces the output of RowUpdating events that affect the DataSet.

To generate INSERT, UPDATE, or DELETE statements, the MimerCommandBuilder uses the SelectCommand property to retrieve a required set of metadata. If you change the value of SelectCommand after the metadata has been retrieved (for example, after the first update), you then should call the RefreshSchema method to update the metadata.

The MimerCommandBuilder also uses the Connection, CommandTimeout, and Transaction properties referenced by the SelectCommand. The user should call RefreshSchema if any of these properties are modified, or if the value of the SelectCommand property itself is changed. Otherwise the InsertCommand, UpdateCommand, and DeleteCommand properties retain their previous values.

If you call Dispose, the MimerCommandBuilder is disassociated from the MimerDataAdapter, and the generated commands are no longer used.

Requirements

Namespace: Mimer.Data.Client

Assembly: Mimer.Data.Client (in Mimer.Data.Client.dll)

See Also

MimerCommandBuilder Members | Mimer.Data.Client Namespace

---