dotConnect for SQLite Documentation
SQLiteCommandBuilder Class
Members  Example  See Also  Send comments on this topic.
Devart.Data.SQLite Namespace : SQLiteCommandBuilder Class

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

Inheritance Hierarchy



Visual Basic (Declaration) 
Public Class SQLiteCommandBuilder 
   Inherits Devart.Common.DbCommandBuilder
   Implements IComponentIDisposable 
public class SQLiteCommandBuilder : Devart.Common.DbCommandBuilder, IComponentIDisposable  


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

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

To generate INSERT, UPDATE, or DELETE statements, the SQLiteCommandBuilder uses the SQLiteDataAdapter.SelectCommand property to retrieve a required set of metadata. If you change the value of SQLiteDataAdapter.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 SQLiteCommandBuilder also uses the Connection, CommandTimeout, and System.Data.Common.DbCommand.Transaction properties referenced by the SQLiteDataAdapter.SelectCommand. The user should call Devart.Common.DbCommandBuilderBase.RefreshSchema if any of these properties are modified, or value of the SQLiteDataAdapter.SelectCommand property itself is changed. Otherwise the SQLiteDataAdapter.InsertCommand, SQLiteDataAdapter.UpdateCommand, and SQLiteDataAdapter.DeleteCommand properties retain their previous values.

If you assign null to corresponding property of SQLiteDataAdapter, the SQLiteCommandBuilder will be disassociated from the SQLiteDataAdapter, 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.


The following example uses SQLiteCommand, along with SQLiteDataAdapter and SQLiteConnection, to select rows from SQLite. 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 SQLite table. The example then creates a SQLiteCommandBuilder.
C#csharpCopy Code
public DataSet SelectSQLiteSrvRows(DataSet myDataSet,string sqConnection,string mySelectQuery,string myTableName)
  SQLiteConnection myConn = new SQLiteConnection(sqConnection);
  SQLiteDataAdapter myDataAdapter = new SQLiteDataAdapter();
  myDataAdapter.SelectCommand = new SQLiteCommand(mySelectQuery, myConn);
  SQLiteCommandBuilder sqCommandBuilder = new SQLiteCommandBuilder(myDataAdapter);


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

  //code to modify data in dataset here

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


  return myDataSet;
C#Visual BasicCopy Code
Public Function SelectSQLiteSrvRows(myDataSet As DataSet, sqConnection As String, mySelectQuery As String, myTableName As String) As DataSet
  Dim myConn As New SQLiteConnection(sqConnection)
  Dim myDataAdapter As New SQLiteDataAdapter()
  myDataAdapter.SelectCommand = New SQLiteCommand(mySelectQuery, myConn)
  Dim sqCommandBuilder As SQLiteCommandBuilder = New SQLiteCommandBuilder(myDataAdapter)


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

  ' Code to modify data in DataSet here

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


  SelectSQLiteSrvRows = myDataSet
End Function


Namespace: Devart.Data.SQLite

Platforms:Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family, Windows 7, Windows 8, Windows 10, Windows Server 2012 family.

See Also