CreateViewTask

Class CreateViewTask

Creates or alters a view.

Inheritance
CreateViewTask
Implements
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public sealed class CreateViewTask : ControlFlowTask, ILoggableTask
Examples
CreateViewTask.CreateOrAlter("viewname","SELECT value FROM table");

Constructors

CreateViewTask()

Declaration
    public CreateViewTask()

CreateViewTask(string, string)

Declaration
    public CreateViewTask(string viewName, string definition)
Parameters
TypeNameDescription
stringviewName
stringdefinition

Properties

Definition

The view definition.

Declaration
    public string Definition { get; set; }
Property Value
TypeDescription
string

Sql

The sql that is generated to create the view

Declaration
    public string Sql { get; }
Property Value
TypeDescription
string

VN

The formatted name of the view

Declaration
    public ObjectNameDescriptor VN { get; }
Property Value
TypeDescription
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
    public string ViewAttributes { get; set; }
Property Value
TypeDescription
string

ViewName

The name of the view

Declaration
    public string ViewName { get; set; }
Property Value
TypeDescription
string

Methods

CreateOrAlter(IConnectionManager, string, string)

Creates or alter a view.

Declaration
    public static void CreateOrAlter(IConnectionManager connectionManager, string viewName, string definition)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

stringviewName

The name of the view

stringdefinition

The view definition

CreateOrAlter(string, string)

Creates or alter a view.

Declaration
    public static void CreateOrAlter(string viewName, string definition)
Parameters
TypeNameDescription
stringviewName

The name of the view

stringdefinition

The view definition

Implements