Class CreateViewTask
Creates or alters a view.
Implements
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.ControlFlow.Tasks
Assembly: ETLBox.dll
Syntax
public sealed class CreateViewTask : ControlFlowTask, ILoggableTask
Examples
CreateViewTask.CreateOrAlter("viewname","SELECT value FROM table");
Constructors
CreateViewTask()
Declaration
public CreateViewTask()
Examples
CreateViewTask.CreateOrAlter("viewname","SELECT value FROM table");
CreateViewTask(string, string)
Declaration
public CreateViewTask(string viewName, string definition)
Parameters
Type | Name | Description |
---|---|---|
string | viewName | |
string | definition |
Examples
CreateViewTask.CreateOrAlter("viewname","SELECT value FROM table");
Properties
Definition
The view definition.
Declaration
public string Definition { get; set; }
Property Value
Type | Description |
---|---|
string |
Sql
The sql that is generated to create the view
Declaration
public string Sql { get; }
Property Value
Type | Description |
---|---|
string |
TaskName
A name to identify the task or component. Every component or task comes with a default name that can be overwritten.
Declaration
public override string TaskName { get; set; }
Property Value
Type | Description |
---|---|
string |
Overrides
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
Type | Description |
---|---|
string |
ViewName
The name of the view
Declaration
public string ViewName { get; set; }
Property Value
Type | Description |
---|---|
string |
VN
The formatted name of the view
Declaration
public ObjectNameDescriptor VN { get; }
Property Value
Type | Description |
---|---|
ObjectNameDescriptor |
Methods
CreateOrAlter(IConnectionManager, string, string)
Creates or alter a view.
Declaration
public static void CreateOrAlter(IConnectionManager connectionManager, string viewName, string definition)
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
public static void CreateOrAlter(string viewName, string definition)
Parameters
Type | Name | Description |
---|---|---|
string | viewName | The name of the view |
string | definition | The view definition |