SQLiteDump Class

In This Topic

Syntax
Remarks
Example
Inheritance Hierarchy
Requirements
See Also

Serves to store a database or its parts as a script and also to restore database from the received script.

Syntax

Visual Basic
C#

public class SQLiteDump : Devart.Common.DbDump, System.ComponentModel.IComponent, System.IDisposable

'Declaration
 
Public Class SQLiteDump 
   Inherits Devart.Common.DbDump
   Implements System.ComponentModel.IComponent, System.IDisposable

Remarks

Use Tables property to specify a list of tables to be stored. If Tables property is an empty string all tables will be included into the dump text. To generate a script call Backup method. The produced script can be viewed in DumpText. To execute the dump script call the Restore method.

Note: This class is not available in .NET Standard 1.3 compatible assembly. It is available only in the assembly for full .NET Framework and .NET Standard 2.0 compatible assembly.

This class is available only in Professional Edition.

Note: To increase performance of the Restore method, call it inside a transaction. For example, call the SQLiteConnection.BeginTransaction method before Restore and call SQLiteConnection.Commit after Restore.

Example

The following sample demonstrates performing backup and restore operations.

csharp

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();
}

Visual Basic

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

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

Reference

SQLiteDump Members
Devart.Data.SQLite Namespace

Send Feedback