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()
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 |
|
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; set; }
Property Value
Type |
Description |
System.String |
|
Overrides
TN
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.Nullable<System.Int32> |
|
Count(IConnectionManager, String, RowCountOptions)
Declaration
public static int? Count(IConnectionManager connectionManager, string tableName, RowCountOptions options)
Parameters
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
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
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()
Declaration
Implements