BeginRestore(String) Method
Starts an asynchronous invocation of a
Restore(String) method.
'Declaration
Public Overloads Function BeginRestore( _
ByVal As String _
) As IAsyncResult
Parameters
- fileName
- The name of the file to load the script from.
Return Value
An
System.IAsyncResult interface that represents the asynchronous operation started by calling this method.
This sample demonstrates performing async backup and restore operations.
public void DumpIt(PgSqlConnection conn)
{
conn.Open();
PgSqlDump pgSqlDump = new PgSqlDump();
pgSqlDump.Connection = conn;
pgSqlDump.Schema = "public";
pgSqlDump.Tables = "dept;emp";
pgSqlDump.IncludeDrop = true;
IAsyncResult Result = pgSqlDump.BeginBackup("d:\\dump.dmp");
while (!Result.IsCompleted)
{
Console.Write(".");
//Perform here any operation you need
}
pgSqlDump.EndBackup(Result);
Console.WriteLine("Dumped.");
conn.Close();
}
public void UnDumpIt(PgSqlConnection conn)
{
conn.Open();
PgSqlDump pgSqlDump = new PgSqlDump();
pgSqlDump.Connection = conn;
IAsyncResult Result = pgSqlDump.BeginRestore("d:\\dump.dmp");
while (!Result.IsCompleted)
{
Console.Write(".");
//Perform here any operation you need
}
pgSqlDump.EndRestore(Result);
Console.WriteLine("Restored.");
conn.Close();
}
Public Sub DumpIt(conn As PgSqlConnection)
conn.Open()
Dim pgSqlDump As New PgSqlDump()
pgSqlDump.Connection = conn
pgSqlDump.Schema = "public"
pgSqlDump.Tables = "dept;emp"
pgSqlDump.IncludeDrop = True
Dim Result As IAsyncResult = pgSqlDump.BeginBackup("d:\dump.dmp")
While Not Result.IsCompleted
'Perform here any operation you need
Console.Write(".")
End While
pgSqlDump.EndBackup(Result)
Console.WriteLine("Dumped.")
conn.Close()
End Sub
Public Sub UnDumpIt(conn As PgSqlConnection)
conn.Open()
Dim pgSqlDump As New PgSqlDump()
pgSqlDump.Connection = conn
Dim Result As IAsyncResult = pgSqlDump.BeginRestore("d:\dump.dmp")
While Not Result.IsCompleted
'Perform here any operation you need
Console.Write(".")
End While
pgSqlDump.EndRestore(Result)
Console.WriteLine("Restored.")
conn.Close()
End Sub