dotConnect for MySQL Documentation
Devart.Common Namespace / DbDump Class / EndRestore Method
The System.IAsyncResult returned by BeginRestore.
Example

In This Topic
    EndRestore Method
    In This Topic
    Ends an asynchronous invocation of the Restore method.
    Syntax
    'Declaration
     
    Public Sub EndRestore( _
       ByVal result As IAsyncResult _
    ) 
    public void EndRestore( 
       IAsyncResult result
    )

    Parameters

    result
    The System.IAsyncResult returned by BeginRestore.
    Remarks
    The function ends an asynchronous backup that is started with BeginRestore. A pair of asynchronous functions (BeginRestore and EndRestore) can be used instead of the synchronous function Restore to gain more performance and flexibility in your application.
    Example
    This sample demonstrates performing async backup and restore operations.
    public void DumpIt(MySqlConnection myConnection) {
            myConnection.Open();
            MySqlDump mySqlDump = new MySqlDump();
            mySqlDump.Connection = myConnection;
            myConnection.Database = "Test";
            mySqlDump.IncludeDrop = true;
            mySqlDump.GenerateHeader = true;
            mySqlDump.Tables = "Dept;Emp";
            IAsyncResult myResult = mySqlDump.BeginBackup("d:\\tmp\\mysqldump.dmp");
            while (!myResult.IsCompleted) {
                    Console.Write(".");
                    //Perform here any operation you need
            }
            mySqlDump.EndBackup(myResult);
            Console.WriteLine("Dumped.");
            myConnection.Close();
    }
    
    public void UnDumpIt(MySqlConnection myConnection) {
            myConnection.Open();
            MySqlDump mySqlDump = new MySqlDump();
    
            mySqlDump.Connection = myConnection;
            myConnection.Database = "Test";
            IAsyncResult myResult = mySqlDump.BeginRestore("d:\\tmp\\mysqldump.dmp");
            while (!myResult.IsCompleted)
            {
                    Console.Write(".");
                    //Perform here any operation you need
            }
            mySqlDump.EndRestore(myResult);
            Console.WriteLine("Restored.");
            myConnection.Close();
    }
    Public Sub DumpIt(myConnection As MySqlConnection)
            myConnection.Open()
            Dim mySqlDump As New MySqlDump()
            mySqlDump.Connection = myConnection
            myConnection.Database = "Test"
            mySqlDump.IncludeDrop = True
            mySqlDump.GenerateHeader = True
            mySqlDump.Tables = "Dept;Emp"
            Dim myResult As IAsyncResult = mySqlDump.BeginBackup("d:\tmp\mysqldump.dmp")
            While Not myResult.IsCompleted
                    'Perform here any operation you need
                    Console.Write(".")
            End While
            mySqlDump.EndBackup(myResult)
            Console.WriteLine("Dumped.")
            myConnection.Close()
    End Sub
    
    Public Sub UnDumpIt(myConnection As MySqlConnection)
            myConnection.Open()
            Dim mySqlDump As New MySqlDump()
    
            mySqlDump.Connection = myConnection
            myConnection.Database = "Test"
            Dim myResult As IAsyncResult = mySqlDump.BeginRestore("d:\tmp\mysqldump.dmp")
            While Not myResult.IsCompleted
                    'Perform here any operation you need
                    Console.Write(".")
            End While
            mySqlDump.EndRestore(myResult)
            Console.WriteLine("Restored.")
            myConnection.Close()
    End Sub
    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