dotConnect for MySQL Documentation
Devart.Data.MySql Namespace / MySqlDump Class / UseExtSyntax Property
Example

In This Topic
    UseExtSyntax Property
    In This Topic
    Determines whether to use extended syntax of INSERT on data insertion.
    Syntax
    'Declaration
     
    Public Property UseExtSyntax As Boolean
    public bool UseExtSyntax {get; set;}

    Property Value

    true, if extended syntax of INSERT on data insertion is used; otherwise, false. The default value is false.
    Remarks

    When set to true, all data in the table will be inserted within a single SQL statement. This form of INSERT statement requires less amount of data to transfer and may execute faster.

    Example
    This sample demonstrates dumping of two tables (Dept and Emp). The script is written to a file after the operation is complete.
    public void DumpIt(MySqlConnection myConnection)
    {
      myConnection.Open();
      MySqlDump mySqlDump = new MySqlDump();
      mySqlDump.Connection = myConnection;
      myConnection.Database = "Test";
      mySqlDump.UseExtSyntax = true;
      mySqlDump.Tables = "Emp;Dept";
      mySqlDump.Backup();
      StreamWriter stream = new StreamWriter("d:\\tmp\\mysqldump.dmp");
      stream.WriteLine(mySqlDump.DumpText);
      stream.Close();
      Console.WriteLine("Dumped.");
      myConnection.Close();
    }
    Public Sub DumpIt(ByVal myConnection As MySqlConnection)
      myConnection.Open()
      Dim mySqlDump As MySqlDump = New MySqlDump
      mySqlDump.Connection = myConnection
      mySqlDump.UseExtSyntax = True
      mySqlDump.Tables = "Emp;Dept"
      mySqlDump.Backup()
      Dim stream As StreamWriter = New StreamWriter("d:\tmp\mysqldump.dmp")
      stream.WriteLine(mySqlDump.DumpText)
      stream.Close()
      Console.WriteLine("Dumped.")
      myConnection.Close()
    End Sub
    See Also