Class CreateViewTask

Creates or alters a view.

Inheritance

object

LoggableTask

ControlFlowTask

CreateViewTask

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 CreateViewTask : ControlFlowTask, ILoggableTask ``` {{< rawhtml >}}

Examples

CreateViewTask.CreateOrAlter("viewname","SELECT value FROM table");

Constructors

CreateViewTask()

Declaration

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

CreateViewTask(string, string)

Declaration

{{< /rawhtml >}} ```C# public CreateViewTask(string viewName, string definition) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	viewName
string	definition

Properties

Definition

The view definition.

Declaration

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

Property Value

Type	Description
string

Sql

The sql that is generated to create the view

Declaration

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

Property Value

Type	Description
string

VN

The formatted name of the view

Declaration

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

Property Value

Type	Description
ObjectNameDescriptor

ViewAttributes

Optional, will set the view attributes, e.g. "WITH SCHEMABINDING". This part is put after the CREATE VIEW [viewname] statement and before the AS statement.

Declaration

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

Property Value

Type	Description
string

ViewName

The name of the view

Declaration

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

Property Value

Type	Description
string

Methods

CreateOrAlter(IConnectionManager, string, string)

Creates or alter a view.

Declaration

{{< /rawhtml >}} ```C# public static void CreateOrAlter(IConnectionManager connectionManager, string viewName, string definition) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the database you want to connect
string	viewName	The name of the view
string	definition	The view definition

CreateOrAlter(string, string)

Creates or alter a view.

Declaration

{{< /rawhtml >}} ```C# public static void CreateOrAlter(string viewName, string definition) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	viewName	The name of the view
string	definition	The view definition

Implements

ILoggableTask