DbDump Class

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public MustInherit Class DbDump 
   Inherits System.ComponentModel.Component
   Implements System.ComponentModel.IComponent, System.IDisposable

public abstract class DbDump : System.ComponentModel.Component, System.ComponentModel.IComponent, System.IDisposable

Remarks

Abstract DbDump class implements some of DbDump functionality that is DBMS-independent.

Example

This 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

DbDump Members
Devart.Common Namespace
SQLiteDump Class

Send Feedback