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
RowCountTask
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 RowCountTask : ControlFlowTask, ILoggableTask
Examples#
int count = RowCountTask.Count("tableName").Value;
Constructors
RowCountTask()#
Declaration
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
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 | |
DirtyRead#
Will do the row count also on uncommitted reads.
Declaration
public bool DirtyRead { get; set; }
Property Value
Type | Description |
---|
System.Boolean | |
HasAnyRows#
Indicates if the table contains rows - only has a value after the execution
Declaration
public bool? HasAnyRows { get; }
Property Value
Type | Description |
---|
System.Nullable<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; set; }
Property Value
Type | Description |
---|
System.String | |
Overrides
The formatted table table name
Declaration
public ObjectNameDescriptor TN { get; }
Property Value
Methods
Count()#
Declaration
public RowCountTask Count()
Returns
Count(IConnectionManager, String)#
Declaration
public static int Count(IConnectionManager connectionManager, string tableName)
Parameters
Returns
Type | Description |
---|
System.Int32 | |
Count(IConnectionManager, String, RowCountOptions)#
Declaration
public static int Count(IConnectionManager connectionManager, string tableName, RowCountOptions options)
Parameters
Returns
Type | Description |
---|
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.Int32 | |
Count(IConnectionManager, String, String, RowCountOptions)#
Declaration
public static int Count(IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options)
Parameters
Returns
Type | Description |
---|
System.Int32 | |
Count(String)#
Declaration
public static int Count(string tableName)
Parameters
Type | Name | Description |
---|
System.String | tableName | |
Returns
Type | Description |
---|
System.Int32 | |
Count(String, RowCountOptions)#
Declaration
public static int Count(string tableName, RowCountOptions options)
Parameters
Returns
Type | Description |
---|
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.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.Int32 | |
HasRows()#
Checks if the table has at least one (matching) row.
Declaration
public RowCountTask HasRows()
Returns
HasRows(IConnectionManager, String)#
Declaration
public static bool HasRows(IConnectionManager connectionManager, string tableName)
Parameters
Returns
Type | Description |
---|
System.Boolean | |
HasRows(IConnectionManager, String, RowCountOptions)#
Declaration
public static bool HasRows(IConnectionManager connectionManager, string tableName, RowCountOptions options)
Parameters
Returns
Type | Description |
---|
System.Boolean | |
HasRows(IConnectionManager, String, String)#
Declaration
public static bool HasRows(IConnectionManager connectionManager, string tableName, string condition)
Parameters
Type | Name | Description |
---|
IConnectionManager | connectionManager | |
System.String | tableName | |
System.String | condition | |
Returns
Type | Description |
---|
System.Boolean | |
HasRows(IConnectionManager, String, String, RowCountOptions)#
Declaration
public static bool HasRows(IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options)
Parameters
Returns
Type | Description |
---|
System.Boolean | |
HasRows(String)#
Declaration
public static bool HasRows(string tableName)
Parameters
Type | Name | Description |
---|
System.String | tableName | |
Returns
Type | Description |
---|
System.Boolean | |
HasRows(String, RowCountOptions)#
Declaration
public static bool HasRows(string tableName, RowCountOptions options)
Parameters
Returns
Type | Description |
---|
System.Boolean | |
HasRows(String, String)#
Declaration
public static bool HasRows(string tableName, string condition)
Parameters
Type | Name | Description |
---|
System.String | tableName | |
System.String | condition | |
Returns
Type | Description |
---|
System.Boolean | |
HasRows(String, String, RowCountOptions)#
Declaration
public static bool HasRows(string tableName, string condition, RowCountOptions options)
Parameters
Type | Name | Description |
---|
System.String | tableName | |
System.String | condition | |
RowCountOptions | options | |
Returns
Type | Description |
---|
System.Boolean | |
Implements#