Class CreateDatabaseTask

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

Inheritance

object

LoggableTask

ControlFlowTask

CreateDatabaseTask

Implements

ILoggableTask

Inherited Members

ControlFlowTask.ConnectionManager

ControlFlowTask.ConnectionType

ControlFlowTask.QB

ControlFlowTask.QE

LoggableTask.TaskType

LoggableTask.TaskName

LoggableTask.DisableLogging

LoggableTask.LogThreshold

LoggableTask.TaskHash

LoggableTask.LogInstance

LoggableTask.ParentTask

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.ControlFlow

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public sealed class CreateDatabaseTask : ControlFlowTask, ILoggableTask ``` {{< rawhtml >}}

Examples

CreateDatabaseTask.Create("DemoDB");

Constructors

CreateDatabaseTask()

Declaration

{{< /rawhtml >}} ```C# public CreateDatabaseTask() ``` {{< rawhtml >}}

CreateDatabaseTask(string)

Declaration

{{< /rawhtml >}} ```C# public CreateDatabaseTask(string databaseName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	databaseName

CreateDatabaseTask(string, string)

Declaration

{{< /rawhtml >}} ```C# public CreateDatabaseTask(string databaseName, string collation) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	databaseName
string	collation

Properties

Collation

The default collation for the database

Declaration

{{< /rawhtml >}} ```C# public string Collation { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

ON

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor ON { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
ObjectNameDescriptor

ObjectName

The name of the database (In MySql: The schema name)

Declaration

{{< /rawhtml >}} ```C# public string ObjectName { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

RecoveryModel

Sql Server only: The recovery model of the database

Declaration

{{< /rawhtml >}} ```C# public RecoveryModel RecoveryModel { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
RecoveryModel

Sql

The sql code that is used to generate the database

Declaration

{{< /rawhtml >}} ```C# public string Sql { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Methods

Create()

Runs the sql code to create the database. Throws an exception if the database already exists.

Declaration

{{< /rawhtml >}} ```C# public void Create() ``` {{< rawhtml >}}

Create(IConnectionManager, string)

Creates a database. In MySql or MariaDb, this will create a schema. Will throw an exception if the database already exists.

Declaration

{{< /rawhtml >}} ```C# public static void Create(IConnectionManager connectionManager, string databaseName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the server you want to connect. Make sure this points to a database that does exist (e.g. a system database)
string	databaseName	The name of the database

Create(IConnectionManager, string, string)

Creates a database. In MySql or MariaDb, this will create a schema. Will throw an exception if the database already exists.

Declaration

{{< /rawhtml >}} ```C# public static void Create(IConnectionManager connectionManager, string databaseName, string collation) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the server you want to connect. Make sure this points to a database that does exist (e.g. a system database)
string	databaseName	The name of the database
string	collation	The default collation of the database.

Create(string)

Creates a database. In MySql or MariaDb, this will create a schema. Will throw an exception if the database already exists. Make sure that your default connection string points to the server itself and to an existing database (e.g. a system database).

Declaration

{{< /rawhtml >}} ```C# public static void Create(string databaseName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	databaseName	The name of the database

Create(string, string)

Declaration

{{< /rawhtml >}} ```C# public static void Create(string databaseName, string collation) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	databaseName	The name of the database
string	collation	The default collation of the database.

CreateIfNotExists()

Runs the sql code to create the database if the database doesn't exist yet.

Declaration

{{< /rawhtml >}} ```C# public void CreateIfNotExists() ``` {{< rawhtml >}}

CreateIfNotExists(IConnectionManager, string)

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

Declaration

{{< /rawhtml >}} ```C# public static void CreateIfNotExists(IConnectionManager connectionManager, string databaseName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the server you want to connect. Make sure this points to a database that does exist (e.g. a system database)
string	databaseName	The name of the database

CreateIfNotExists(IConnectionManager, string, string)

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

Declaration

{{< /rawhtml >}} ```C# public static void CreateIfNotExists(IConnectionManager connectionManager, string databaseName, string collation) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the server you want to connect. Make sure this points to a database that does exist (e.g. a system database)
string	databaseName	The name of the database
string	collation	The default collation of the database.

CreateIfNotExists(string)

Creates a database if the database doesn't exists. In MySql or MariaDb, this will create a schema. Make sure that your default connection string points to the server itself and to an existing database (e.g. a system database).

Declaration

{{< /rawhtml >}} ```C# public static void CreateIfNotExists(string databaseName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	databaseName	The name of the database

CreateIfNotExists(string, string)

Declaration

{{< /rawhtml >}} ```C# public static void CreateIfNotExists(string databaseName, string collation) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	databaseName	The name of the database
string	collation	The default collation of the database.

Implements

ILoggableTask