Class RowCountTask

Count the row in a table. This task normally uses the COUNT(*) method (could take some time on big tables). You can pass a a filter condition for the count.

Inheritance
System.Object
LoggableTask
ControlFlowTask
RowCountTask
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 class RowCountTask : ControlFlowTask, ILoggableTask
Examples
int count = RowCountTask.Count("tableName").Value;

Constructors

RowCountTask()

Declaration
public RowCountTask()

RowCountTask(String)

Declaration
public RowCountTask(string tableName)
Parameters
Type Name Description
System.String tableName

RowCountTask(String, RowCountOptions)

Declaration
public RowCountTask(string tableName, RowCountOptions options)
Parameters
Type Name Description
System.String tableName
RowCountOptions options

RowCountTask(String, String)

Declaration
public RowCountTask(string tableName, string condition)
Parameters
Type Name Description
System.String tableName
System.String condition

RowCountTask(String, String, RowCountOptions)

Declaration
public RowCountTask(string tableName, string condition, RowCountOptions options)
Parameters
Type Name Description
System.String tableName
System.String condition
RowCountOptions options

Properties

Condition

Part of the sql where condition which restrict which rows are counted

Declaration
public string Condition { get; set; }
Property Value
Type Description
System.String

HasRows

Indicates if the table contains rows - only has a value after the execution

Declaration
public bool? HasRows { get; }
Property Value
Type Description
System.Nullable<System.Boolean>

NoLock

NoLock does a normal COUNT(*) using the nolock - option which avoid tables locks when reading from the table (but while counting the tables new data could be inserted, which could lead to wrong results).

Declaration
public bool NoLock { get; set; }
Property Value
Type Description
System.Boolean

QuickQueryMode

For Sql Server, you can set the QuickQueryMode to true. This will query the sys.partition table which can be much faster.

Declaration
public bool QuickQueryMode { get; set; }
Property Value
Type Description
System.Boolean

Rows

Will hold the number of counted rows after execution

Declaration
public int? Rows { get; }
Property Value
Type Description
System.Nullable<System.Int32>

Sql

The sql that is executed to count the rows in the table - will change depending on your parameters.

Declaration
public string Sql { get; }
Property Value
Type Description
System.String

TableName

Name of the table on which the rows are counted

Declaration
public string TableName { get; set; }
Property Value
Type Description
System.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; }
Property Value
Type Description
System.String
Overrides

TN

The formatted table table name

Declaration
public ObjectNameDescriptor TN { get; }
Property Value
Type Description
ObjectNameDescriptor

Methods

Count()

Declaration
public RowCountTask Count()
Returns
Type Description
RowCountTask

Count(IConnectionManager, String)

Declaration
public static int? Count(IConnectionManager connectionManager, string tableName)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName
Returns
Type Description
System.Nullable<System.Int32>

Count(IConnectionManager, String, RowCountOptions)

Declaration
public static int? Count(IConnectionManager connectionManager, string tableName, RowCountOptions options)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName
RowCountOptions options
Returns
Type Description
System.Nullable<System.Int32>

Count(IConnectionManager, String, String)

Declaration
public static int? Count(IConnectionManager connectionManager, string tableName, string condition)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName
System.String condition
Returns
Type Description
System.Nullable<System.Int32>

Count(IConnectionManager, String, String, RowCountOptions)

Declaration
public static int? Count(IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options)
Parameters
Type Name Description
IConnectionManager connectionManager
System.String tableName
System.String condition
RowCountOptions options
Returns
Type Description
System.Nullable<System.Int32>

Count(String)

Declaration
public static int? Count(string tableName)
Parameters
Type Name Description
System.String tableName
Returns
Type Description
System.Nullable<System.Int32>

Count(String, RowCountOptions)

Declaration
public static int? Count(string tableName, RowCountOptions options)
Parameters
Type Name Description
System.String tableName
RowCountOptions options
Returns
Type Description
System.Nullable<System.Int32>

Count(String, String)

Declaration
public static int? Count(string tableName, string condition)
Parameters
Type Name Description
System.String tableName
System.String condition
Returns
Type Description
System.Nullable<System.Int32>

Count(String, String, RowCountOptions)

Declaration
public static int? Count(string tableName, string condition, RowCountOptions options)
Parameters
Type Name Description
System.String tableName
System.String condition
RowCountOptions options
Returns
Type Description
System.Nullable<System.Int32>

Execute()

Performs the row count

Declaration
public void Execute()

Implements