MySqlLoader Class

In This Topic

Serves to load external data into MySQL.

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class MySqlLoader 
   Inherits Devart.Common.DbLoader
   Implements System.ComponentModel.IComponent, System.IDisposable

public sealed class MySqlLoader : Devart.Common.DbLoader, System.ComponentModel.IComponent, System.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.

csharp

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();
  }
}

Visual Basic

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

Reference

MySqlLoader Members
Devart.Data.MySql Namespace
MySqlLoaderColumn Class
MySqlLoaderColumnCollection Class

Send Feedback