BeginBackup(String) Method

In This Topic

Syntax
Remarks
Example
See Also

Starts an asynchronous invocation of a Backup(String) method.

Syntax

Visual Basic
C#

public IAsyncResult BeginBackup( 
   string fileName
)

'Declaration
 
Public Overloads Function BeginBackup( _
   ByVal fileName As String _
) As IAsyncResult

Parameters

fileName: The name of the file to write the script to.

Return Value

An System.IAsyncResult interface that represents the asynchronous operation started by calling this method.

Remarks

BeginBackup(String) method enables you to perform a backup operation without having current thread blocked. In other words, your program can continue execution while the backup runs in background so you do not have to wait for it.

To start the backup operation, you have to call BeginBackup(String) method, which in turn invokes appropriate actions in another thread. Return value of this method must be assigned to an System.IAsyncResult object. After executing this method, the program flow continues.

When you are ready to finish the backup operation, call EndBackup. If at the moment you call this function the backup has not yet been finished, application stops and waits till the function returns.

Example

This sample demonstrates performing async backup and restore operations.

csharp

public void DumpIt(SQLiteConnection conn)
{
        conn.Open();
        SQLiteDump sqSqlDump = new SQLiteDump();
        sqSqlDump.Connection = conn;
        sqSqlDump.IncludeDrop = true;
        IAsyncResult Result = sqSqlDump.BeginBackup("d:\\dump.dmp");
        while (!Result.IsCompleted)
        {
                Console.Write(".");
                //Perform here any operation you need
        }
        sqSqlDump.EndBackup(Result);
        Console.WriteLine("Dumped.");
        conn.Close();
}

public void UnDumpIt(SQLiteConnection conn)
{
        conn.Open();
        SQLiteDump sqSqlDump = new SQLiteDump();
        sqSqlDump.Connection = conn;
        IAsyncResult Result = sqSqlDump.BeginRestore("d:\\dump.dmp");
        while (!Result.IsCompleted)
        {
                Console.Write(".");
                //Perform here any operation you need
        }
        sqSqlDump.EndRestore(Result);
        Console.WriteLine("Restored.");
        conn.Close();
}

Visual Basic

Public Sub DumpIt(conn As SQLiteConnection)
        conn.Open()
        Dim sqSqlDump As New SQLiteDump()
        sqSqlDump.Connection = conn
        sqSqlDump.IncludeDrop = True
        Dim Result As IAsyncResult = sqSqlDump.BeginBackup("d:\dump.dmp")
        While Not Result.IsCompleted
                'Perform here any operation you need
                Console.Write(".")
        End While
        sqSqlDump.EndBackup(Result)
        Console.WriteLine("Dumped.")
        conn.Close()
End Sub

Public Sub UnDumpIt(conn As SQLiteConnection)
        conn.Open()
        Dim sqSqlDump As New SQLiteDump()
        sqSqlDump.Connection = conn
        Dim Result As IAsyncResult = sqSqlDump.BeginRestore("d:\dump.dmp")
        While Not Result.IsCompleted
                'Perform here any operation you need
                Console.Write(".")
        End While
        sqSqlDump.EndRestore(Result)
        Console.WriteLine("Restored.")
        conn.Close()
End Sub

Reference

DbDump Class
DbDump Members
Overload List

Send Feedback