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

GenericTask

RowCountTask

Implements

ITask

Inherited Members

GenericTask.TaskType

GenericTask.NLogger

GenericTask.ConnectionManager

GenericTask.ConnectionType

GenericTask.QB

GenericTask.QE

GenericTask._disableLogging

GenericTask.DisableLogging

GenericTask.TaskHash

GenericTask.CopyTaskProperties(ITask)

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 : GenericTask, ITask

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

Declaration

public string Condition { get; set; }

Property Value

Type	Description
System.String

HasCondition

Declaration

public bool HasCondition { get; }

Property Value

Type	Description
System.Boolean

HasRows

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

Declaration

public int? Rows { get; }

Property Value

Type	Description
System.Nullable<System.Int32>

Sql

Declaration

public string Sql { get; }

Property Value

Type	Description
System.String

TableName

Declaration

public string TableName { get; set; }

Property Value

Type	Description
System.String

TaskName

Declaration

public override string TaskName { get; }

Property Value

Type	Description
System.String

Overrides

GenericTask.TaskName

TN

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()

Declaration

public void Execute()

Implements

ITask