ETLBoxClass IfTableOrViewExistsTask
Checks if a table exists.
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 IfTableOrViewExistsTask : IfExistsTask, ILoggableTask
Constructors
IfTableOrViewExistsTask()
Declaration
public IfTableOrViewExistsTask()
IfTableOrViewExistsTask(IConnectionManager, String)
Declaration
public IfTableOrViewExistsTask(IConnectionManager connectionManager, string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| IConnectionManager | connectionManager | |
| System.String | tableName |
IfTableOrViewExistsTask(String)
Declaration
public IfTableOrViewExistsTask(string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| System.String | tableName |
Methods
IsExisting(IConnectionManager, String)
Ćhecks if the table or view exists
Declaration
public static bool IsExisting(IConnectionManager connectionManager, string objectName)
Parameters
| Type | Name | Description |
|---|---|---|
| IConnectionManager | connectionManager | The connection manager of the database you want to connect |
| System.String | objectName | The table or view name that you want to check for existence |
Returns
| Type | Description |
|---|---|
| System.Boolean | True if the table or view exists |
IsExisting(String)
Ćhecks if the table or view exists
Declaration
public static bool IsExisting(string objectName)
Parameters
| Type | Name | Description |
|---|---|---|
| System.String | objectName | The table or view name that you want to check for existence |
Returns
| Type | Description |
|---|---|
| System.Boolean | True if the table or view exists |
ThrowExceptionIfNotExists(IConnectionManager, String)
Ćhecks if the table or view exists. If the table doesn't exist, an ETLBoxException is thrown.
Declaration
public static void ThrowExceptionIfNotExists(IConnectionManager connectionManager, string objectName)
Parameters
| Type | Name | Description |
|---|---|---|
| IConnectionManager | connectionManager | The connection manager of the database you want to connect |
| System.String | objectName | The table or view name that you want to check for existence |
Exceptions
| Type | Condition |
|---|---|
| ETLBoxException |