dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlLoader Class
Members Example

In This Topic
    MySqlLoader Class
    In This Topic
    Serves to load external data into MySQL.
    Syntax
    'Declaration
     
    Public NotInheritable Class MySqlLoader 
       Inherits Devart.Common.DbLoader
       Implements System.ComponentModel.IComponentSystem.IDisposable 
    Remarks

    MySqlLoader work is based on generation of INSERT statements that insert data by several rows at the same time. To specify the name of loading table set TableName property. Use Columns property to access individual columns. Performance of MySqlLoader greatly exceeds performance of other data access components.

    This class is available only in Professional and Developer Editions. It is not available in Standard and Mobile Editions.

    Example
    The following example creates a MySqlLoader, then populates Columns collection from table description, loads data, flushes the buffer, and disposes internal MySqlLoader structures. The MySqlLoader requires an open connection.
    public void LoadData(MySqlConnection myConnection)
    {
      myConnection.Open();
      myConnection.Database = "Test";
      MySqlLoader loader = new MySqlLoader();
      loader.Connection = myConnection;
      loader.TableName = "load_table";
      try
      {
        loader.CreateColumns();
        loader.Open();
        for (int i = 1; i <= 10000; i++)
        {
          loader.SetValue("id", i);
          loader.SetValue(1, "test string");
          loader.SetValue("date_field", DateTime.Now);
          loader.NextRow();
        }
        loader.Close();
      }
      finally
      {
        myConnection.Close();
      }
    }
    Public Sub LoadData(ByVal myConnection As MySqlConnection)
      myConnection.Open()
      myConnection.Database = "Test"
      Dim loader As MySqlLoader
      loader = New MySqlLoader
      loader.Connection = myConnection
      loader.TableName = "load_table"
      Try
        loader.CreateColumns()
        loader.Open()
        Dim i As Integer
        For i = 1 To 10000
          loader.SetValue("id", i)
          loader.SetValue(1, "test string")
          loader.SetValue("date_field", DateTime.Now)
          loader.NextRow()
        Next i
        loader.Close()
      Finally
        myConnection.Close()
      End Try
    End Sub
    Inheritance Hierarchy

    System.Object
       System.MarshalByRefObject
          System.ComponentModel.Component
             Devart.Common.DbLoader
                Devart.Data.MySql.MySqlLoader

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also