ObjectTypes Property

In This Topic

Gets or sets a value that indicates which database objects will be included in the dump text.

Syntax

Visual Basic
C#

'Declaration
 
Public Property ObjectTypes As SQLiteDumpObjects

public SQLiteDumpObjects ObjectTypes {get; set;}

Property Value

A combination of SQLiteDumpObjects values.

Example

The following example dumps only triggers and events from the 'Test' database.

csharp

static void Main(string[] args) {

        MySqlConnection connection = new MySqlConnection("user id=root;password=root;host=localhost;port=3306;database=Test");
        connection.Open();

        MySqlDump mySqlDump = new MySqlDump(connection);
        mySqlDump.ObjectTypes = MySqlDumpObjects.Triggers | MySqlDumpObjects.Events;
        mySqlDump.Backup("D:\temp\mydump.dmp");

        connection.Close();
        Console.WriteLine("Dumped.");
        Console.ReadKey();
}

Visual Basic

Sub Main()
        Dim connection As MySqlConnection = New MySqlConnection("User Id=root;Password=root;Host=localhost;Port=3306;Database=Test;")
        connection.Open()

        Dim mySqlDump As MySqlDump = New MySqlDump(connection)
        mySqlDump.ObjectTypes = MySqlDumpObjects.Triggers Or MySqlDumpObjects.Events
        mySqlDump.Backup("D:\\temp\\mydump.dmp")

        connection.Close()
        Console.WriteLine("Dumped.")
        Console.ReadKey()
End Sub

Reference

SQLiteDump Class
SQLiteDump Members
SQLiteDumpObjects Enumeration

Send Feedback