MagentoCommandBuilder Class

On this page

Automatically generates single-table commands used to reconcile changes made to a System.Data.DataSet with the Adobe Commerce.

Syntax

Visual Basic
C#


'Declaration Public Class MagentoCommandBuilder Inherits Devart.Data.SqlShimCommandBuilder Implements System.ComponentModel.IComponent, System.IDisposable


public class MagentoCommandBuilder : Devart.Data.SqlShimCommandBuilder, System.ComponentModel.IComponent, System.IDisposable

Remarks

The MagentoDataAdapter does not automatically generate the SQL statements required to reconcile changes made to a System.Data.DataSet associated with Adobe Commerce. However, you can create a MagentoCommandBuilder object that generates SQL statements for single-table updates. After assigning the MagentoDataAdapter to the MagentoCommandBuilder, it begins to generate any additional SQL statements that you do not set.

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

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

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

If you assign null to corresponding property of MagentoDataAdapter, the MagentoCommandBuilder will be disassociated from the MagentoDataAdapter, and the generated commands will no longer be used.

Note: This class is not available in .NET Standard 1.3 compatible assembly. It is available only in the assembly for full .NET Framework and .NET Standard 2.0 compatible assembly.

Example

The following example uses MagentoCommand, along with MagentoDataAdapter and MagentoConnection, to select rows from Adobe Commerce. The example is passed an initialized System.Data.DataSet, a connection string, a query string that is SQL SELECT statement, and a string that is the name of the Adobe Commerce table. The example then creates a MagentoCommandBuilder.

csharp


public DataSet SelectMagentoSrvRows(DataSet myDataSet,string adobe commerceConnection,string mySelectQuery,string myTableName) { MagentoConnection myConn = new MagentoConnection(adobe commerceConnection); MagentoDataAdapter myDataAdapter = new MagentoDataAdapter(); myDataAdapter.SelectCommand = new MagentoCommand(mySelectQuery, myConn); MagentoCommandBuilder adobe commerceCommandBuilder = new MagentoCommandBuilder(myDataAdapter); myConn.Open(); DataSet myDataSet = new DataSet(); myDataAdapter.Fill(myDataSet, "Departments"); //code to modify data in dataset here //Without the MagentoCommandBuilder this line would fail myDataAdapter.Update(myDataSet, "Departments"); myConn.Close(); return myDataSet; }

public DataSet SelectMagentoSrvRows(DataSet myDataSet,string adobe commerceConnection,string mySelectQuery,string myTableName)
{
  MagentoConnection myConn = new MagentoConnection(adobe commerceConnection);
  MagentoDataAdapter myDataAdapter = new MagentoDataAdapter();
  myDataAdapter.SelectCommand = new MagentoCommand(mySelectQuery, myConn);
  MagentoCommandBuilder adobe commerceCommandBuilder = new MagentoCommandBuilder(myDataAdapter);

  myConn.Open();

  DataSet myDataSet = new DataSet();
  myDataAdapter.Fill(myDataSet, "Departments");

  //code to modify data in dataset here

  //Without the MagentoCommandBuilder this line would fail
  myDataAdapter.Update(myDataSet, "Departments");

  myConn.Close();

  return myDataSet;
}

Visual Basic


Public Function SelectMagentoSrvRows(myDataSet As DataSet, adobe commerceConnection As String, mySelectQuery As String, myTableName As String) As DataSet Dim myConn As New MagentoConnection(adobe commerceConnection) Dim myDataAdapter As New MagentoDataAdapter() myDataAdapter.SelectCommand = New MagentoCommand(mySelectQuery, myConn) Dim adobe commerceCommandBuilder As MagentoCommandBuilder = New MagentoCommandBuilder(myDataAdapter) myConn.Open() Dim myDataSet As DataSet = New DataSet myDataAdapter.Fill(myDataSet, "Departments") ' Code to modify data in DataSet here ' Without the MagentoCommandBuilder this line would fail. myDataAdapter.Update(myDataSet, "Departments") myConn.Close() SelectMagentoSrvRows = myDataSet End Function

Public Function SelectMagentoSrvRows(myDataSet As DataSet, adobe commerceConnection As String, mySelectQuery As String, myTableName As String) As DataSet
  Dim myConn As New MagentoConnection(adobe commerceConnection)
  Dim myDataAdapter As New MagentoDataAdapter()
  myDataAdapter.SelectCommand = New MagentoCommand(mySelectQuery, myConn)
  Dim adobe commerceCommandBuilder As MagentoCommandBuilder = New MagentoCommandBuilder(myDataAdapter)

  myConn.Open()

  Dim myDataSet As DataSet = New DataSet
  myDataAdapter.Fill(myDataSet, "Departments")

  ' Code to modify data in DataSet here

  ' Without the MagentoCommandBuilder this line would fail.
  myDataAdapter.Update(myDataSet, "Departments")

  myConn.Close()

  SelectMagentoSrvRows = myDataSet
End Function

Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.Common.DbCommandBuilder
            Devart.Common.DbCommandBuilderBase
               Devart.Common.DbCommandBuilder
                  Devart.Data.SqlShimCommandBuilder
                     Devart.Data.Magento.MagentoCommandBuilder

Reference

MagentoCommandBuilder Members
Devart.Data.Magento Namespace
MagentoDataAdapter Class
MagentoConnection Class
MagentoCommand Class

Send Feedback