dotConnect for SQLite Documentation
Devart.Common Namespace / DbDump Class
Members Example

DbDump Class
Serves to store a database or its parts as a script and also to restore database from the received script.
Syntax
'Declaration
 
Public MustInherit Class DbDump 
   Inherits System.ComponentModel.Component
   Implements System.ComponentModel.IComponentSystem.IDisposable 
 
Remarks
Abstract DbDump class implements some of DbDump functionality that is DBMS-independent.
Example
This sample demonstrates performing backup and restore operations.
public void DumpIt(SQLiteConnection conn)
{
        conn.Open();
        SQLiteDump sqSqlDump = new SQLiteDump();
        sqSqlDump.Connection = conn;
        sqSqlDump.IncludeDrop = true;
        sqSqlDump.Backup("d:\\dump.dmp");
        conn.Close();
}

public void UnDumpIt(SQLiteConnection conn)
{
        conn.Open();
        SQLiteDump sqSqlDump = new SQLiteDump();
        sqSqlDump.Connection = conn;
        sqSqlDump.Restore("d:\\dump.dmp");
        conn.Close();
}
Public Sub DumpIt(conn As SQLiteConnection)
        conn.Open()
        Dim sqSqlDump As New SQLiteDump()
        sqSqlDump.Connection = conn
        sqSqlDump.IncludeDrop = True
        sqSqlDump.Backup("d:\dump.dmp")
        conn.Close()
End Sub

Public Sub UnDumpIt(conn As SQLiteConnection)
        conn.Open()
        Dim sqSqlDump As New SQLiteDump()
        sqSqlDump.Connection = conn
        sqSqlDump.Restore("d:\dump.dmp")
        conn.Close()
End Sub
Inheritance Hierarchy

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         Devart.Common.DbDump
            Devart.Data.SQLite.SQLiteDump

See Also