Class GetViewListTask

Returns a list of all tables in the currently connected database.
Make sure to connect with the correct permissions!

Inheritance
System.Object
GetViewListTask
Implements
Inherited Members
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 sealed class GetViewListTask : GetListTask, ILoggableTask
Examples
    
List<ETLBox.Helper.ObjectNameDescriptor> allviews = GetViewListTask.List();
foreach (var on in allviews) {
    Console.WriteLine("Schema:" + on.UnquotatedSchemaName);
    Console.WriteLine("ViewName:" + on.UnquotatedObjectName);
    Console.WriteLine("Full qualified name:" + on.QuotatedFullName);
}

Constructors

GetViewListTask()

Declaration
    public GetViewListTask()

Properties

TaskName

Declaration
    public override string TaskName { get; set; }
Property Value
TypeDescription
System.String
Overrides

Methods

ListAll()

Runs sql code to determine all user database names.

Declaration
    public static List<ObjectNameDescriptor> ListAll()
Returns
TypeDescription
System.Collections.Generic.List<ObjectNameDescriptor>

A list of all user database names

ListAll(IConnectionManager)

Runs sql code to determine all user database names.

Declaration
    public static List<ObjectNameDescriptor> ListAll(IConnectionManager connectionManager)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the server you want to connect

Returns
TypeDescription
System.Collections.Generic.List<ObjectNameDescriptor>

A list of all user database names

Implements