Mimer SQL Data Provider help
MimerCommandBuilder Class
Members 




Mimer.Data.Client Namespace : MimerCommandBuilder Class
This class automatically generates SQL commands used to reconcile changes made to a System.Data.DataSet or System.Data.DataTable with the associated database server.
Object Model
MimerCommandBuilder Class
Syntax
'Declaration
 
Public NotInheritable Class MimerCommandBuilder 
   Inherits System.Data.Common.DbCommandBuilder
public sealed class MimerCommandBuilder : System.Data.Common.DbCommandBuilder 
public class MimerCommandBuilder = class(System.Data.Common.DbCommandBuilder)sealed; 
public sealed class MimerCommandBuilder extends System.Data.Common.DbCommandBuilder
public __gc __sealed class MimerCommandBuilder : public System.Data.Common.DbCommandBuilder 
Remarks
The MimerDataAdapter does not automatically generate the SQL statements required to reconcile changes made to a System.Data.DataSet. However, you can create a MimerCommandBuilder object that generates SQL statements for single-table updates by setting the MimerDataAdapter.SelectCommand property of the MimerDataAdapter. Then, the MimerCommandBuilder generates any additional SQL statements that you do not set.

The relationship between a MimerDataAdapter and its corresponding MimerCommandBuilder is always one-to-one. To create this correspondence, you set the DataAdapter property of the MimerCommandBuilder object. This causes the MimerCommandBuilder to register itself as a listener, which produces the output of MimerDataAdapter.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, MimerCommand.CommandTimeout, and MimerCommand.Transaction properties referenced by the SelectCommand. You should call RefreshSchema if any of these properties are modified, or if the value of the SelectCommand property itself is changed. Otherwise the MimerDataAdapter.InsertCommand, MimerDataAdapter.UpdateCommand, and MimerDataAdapter.DeleteCommand properties retain their previous values.

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

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbCommandBuilder
            Mimer.Data.Client.MimerCommandBuilder

Requirements

.NET Framework
Version 2.0 or later

See Also

Reference

MimerCommandBuilder Members
Mimer.Data.Client Namespace