Class GetViewListTask

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

Inheritance
object
LoggableTask
ControlFlowTask
GetListTask
GetViewListTask
Implements
Inherited Members
Namespace: ETLBox.ControlFlow
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()

Methods

ListAll()

Runs sql code to determine all user database names.

Declaration
    public static List<ObjectNameDescriptor> ListAll()
Returns
TypeDescription
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
List<ObjectNameDescriptor>

A list of all user database names

Implements