Class CreateDatabaseTask

Will create a database if the database doesn't exists. In MySql, this will create a schema.

Inheritance

System.Object

GenericTask

CreateDatabaseTask

Implements

ITask

Inherited Members

GenericTask.TaskType

GenericTask.NLogger

GenericTask.ConnectionManager

GenericTask.ConnectionType

GenericTask.QB

GenericTask.QE

GenericTask._disableLogging

GenericTask.DisableLogging

GenericTask.TaskHash

GenericTask.CopyTaskProperties(ITask)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: ETLBox.ControlFlow.Tasks

Assembly: ETLBox.dll

Syntax

public class CreateDatabaseTask : GenericTask, ITask

Examples

CreateDatabaseTask.Create("DemoDB");

Constructors

CreateDatabaseTask()

Declaration

public CreateDatabaseTask()

CreateDatabaseTask(String)

Declaration

public CreateDatabaseTask(string databaseName)

Parameters

Type	Name	Description
System.String	databaseName

CreateDatabaseTask(String, String)

Declaration

public CreateDatabaseTask(string databaseName, string collation)

Parameters

Type	Name	Description
System.String	databaseName
System.String	collation

Properties

Collation

Declaration

public string Collation { get; set; }

Property Value

Type	Description
System.String

DatabaseName

Declaration

public string DatabaseName { get; set; }

Property Value

Type	Description
System.String

RecoveryModel

Declaration

public RecoveryModel RecoveryModel { get; set; }

Property Value

Type	Description
RecoveryModel

Sql

Declaration

public string Sql { get; }

Property Value

Type	Description
System.String

TaskName

Declaration

public override string TaskName { get; }

Property Value

Type	Description
System.String

Overrides

GenericTask.TaskName

Methods

Create()

Declaration

public void Create()

Create(IConnectionManager, String)

Declaration

public static void Create(IConnectionManager connectionManager, string databaseName)

Parameters

Type	Name	Description
IConnectionManager	connectionManager
System.String	databaseName

Create(IConnectionManager, String, String)

Declaration

public static void Create(IConnectionManager connectionManager, string databaseName, string collation)

Parameters

Type	Name	Description
IConnectionManager	connectionManager
System.String	databaseName
System.String	collation

Create(String)

Declaration

public static void Create(string databaseName)

Parameters

Type	Name	Description
System.String	databaseName

Create(String, String)

Declaration

public static void Create(string databaseName, string collation)

Parameters

Type	Name	Description
System.String	databaseName
System.String	collation

Execute()

Declaration

public void Execute()

Implements

ITask