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.
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
{{< /rawhtml >}}
```C#
public sealed class RowCountTask : ControlFlowTask, ILoggableTask
```
{{< rawhtml >}}
Examples
int count = RowCountTask.Count("tableName").Value;
Constructors
RowCountTask()
Declaration
{{< /rawhtml >}}
```C#
public RowCountTask()
```
{{< rawhtml >}}
RowCountTask(string)
Declaration
{{< /rawhtml >}}
```C#
public RowCountTask(string tableName)
```
{{< rawhtml >}}
Parameters
| Type |
Name |
Description |
| string |
tableName |
|
RowCountTask(string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public RowCountTask(string tableName, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
RowCountTask(string, string)
Declaration
{{< /rawhtml >}}
```C#
public RowCountTask(string tableName, string condition)
```
{{< rawhtml >}}
Parameters
RowCountTask(string, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public RowCountTask(string tableName, string condition, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Properties
Condition
Part of the sql where condition which restrict which rows are counted
Declaration
{{< /rawhtml >}}
```C#
public string Condition { get; set; }
```
{{< rawhtml >}}
Property Value
DirtyRead
Will do the row count also on uncommitted reads.
Declaration
{{< /rawhtml >}}
```C#
public bool DirtyRead { get; }
```
{{< rawhtml >}}
Property Value
Options
For Sql Server, you can set the QuickQueryMode to true. This will query the sys.partition table which can be much faster.
If set to DirtyRead, the count will also read uncommitted rows.
If set ReadOnlyFirstRow, the count will use a limit when running
Declaration
{{< /rawhtml >}}
```C#
public RowCountOptions Options { get; set; }
```
{{< rawhtml >}}
Property Value
QuickQueryMode
For Sql Server, you can set the QuickQueryMode to true. This will query the sys.partition table which can be much faster.
Declaration
{{< /rawhtml >}}
```C#
public bool QuickQueryMode { get; }
```
{{< rawhtml >}}
Property Value
Rows
Will hold the number of counted rows after execution
Declaration
{{< /rawhtml >}}
```C#
public int? Rows { get; }
```
{{< rawhtml >}}
Property Value
Sql
The sql that is executed to count the rows in the table - will change depending on your parameters.
Declaration
{{< /rawhtml >}}
```C#
public string Sql { get; }
```
{{< rawhtml >}}
Property Value
TN
The formatted table table name
Declaration
{{< /rawhtml >}}
```C#
public ObjectNameDescriptor TN { get; }
```
{{< rawhtml >}}
Property Value
TableName
Name of the table on which the rows are counted
Declaration
{{< /rawhtml >}}
```C#
public string TableName { get; set; }
```
{{< rawhtml >}}
Property Value
Methods
Count()
Declaration
{{< /rawhtml >}}
```C#
public int Count()
```
{{< rawhtml >}}
Returns
Count(IConnectionManager, string)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(IConnectionManager connectionManager, string tableName)
```
{{< rawhtml >}}
Parameters
Returns
Count(IConnectionManager, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(IConnectionManager connectionManager, string tableName, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
Count(IConnectionManager, string, string)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(IConnectionManager connectionManager, string tableName, string condition)
```
{{< rawhtml >}}
Parameters
Returns
Count(IConnectionManager, string, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
Count(string)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(string tableName)
```
{{< rawhtml >}}
Parameters
| Type |
Name |
Description |
| string |
tableName |
|
Returns
Count(string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(string tableName, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
Count(string, string)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(string tableName, string condition)
```
{{< rawhtml >}}
Parameters
Returns
Count(string, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static int Count(string tableName, string condition, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
CountAsync()
Declaration
{{< /rawhtml >}}
```C#
public Task CountAsync()
```
{{< rawhtml >}}
Returns
CountAsync(IConnectionManager, string)
Declaration
{{< /rawhtml >}}
```C#
public static Task CountAsync(IConnectionManager connectionManager, string tableName)
```
{{< rawhtml >}}
Parameters
Returns
CountAsync(IConnectionManager, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static Task CountAsync(IConnectionManager connectionManager, string tableName, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
CountAsync(IConnectionManager, string, string)
Declaration
{{< /rawhtml >}}
```C#
public static Task CountAsync(IConnectionManager connectionManager, string tableName, string condition)
```
{{< rawhtml >}}
Parameters
Returns
CountAsync(IConnectionManager, string, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static Task CountAsync(IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
HasRows()
Checks if the table has at least one (matching) row.
Declaration
{{< /rawhtml >}}
```C#
public bool HasRows()
```
{{< rawhtml >}}
Returns
HasRows(IConnectionManager, string)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(IConnectionManager connectionManager, string tableName)
```
{{< rawhtml >}}
Parameters
Returns
HasRows(IConnectionManager, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(IConnectionManager connectionManager, string tableName, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
HasRows(IConnectionManager, string, string)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(IConnectionManager connectionManager, string tableName, string condition)
```
{{< rawhtml >}}
Parameters
Returns
HasRows(IConnectionManager, string, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
HasRows(string)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(string tableName)
```
{{< rawhtml >}}
Parameters
| Type |
Name |
Description |
| string |
tableName |
|
Returns
HasRows(string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(string tableName, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
HasRows(string, string)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(string tableName, string condition)
```
{{< rawhtml >}}
Parameters
Returns
HasRows(string, string, RowCountOptions)
Declaration
{{< /rawhtml >}}
```C#
public static bool HasRows(string tableName, string condition, RowCountOptions options)
```
{{< rawhtml >}}
Parameters
Returns
Implements
{{< /rawhtml >}}