C# Class ETLBox.ControlFlow.Tasks.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: GenericTask, ITask
Datei anzeigen Open project: etlbox/etlbox

Private Properties

Property Type Description
Execute void

Public Methods

Method Description
Count ( ) : RowCountTask

Performs the row count
Count ( IConnectionManager connectionManager, string tableName ) : int
Count ( IConnectionManager connectionManager, string tableName, RowCountOptions options ) : int
Count ( IConnectionManager connectionManager, string tableName, string condition ) : int
Count ( IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options ) : int
Count ( string tableName ) : int
Count ( string tableName, RowCountOptions options ) : int
Count ( string tableName, string condition ) : int
Count ( string tableName, string condition, RowCountOptions options ) : int
HasRows ( ) : RowCountTask

Checks if the table has at least one (matching) row.
HasRows ( IConnectionManager connectionManager, string tableName ) : bool
HasRows ( IConnectionManager connectionManager, string tableName, RowCountOptions options ) : bool
HasRows ( IConnectionManager connectionManager, string tableName, string condition ) : bool
HasRows ( IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options ) : bool
HasRows ( string tableName ) : bool
HasRows ( string tableName, RowCountOptions options ) : bool
HasRows ( string tableName, string condition ) : bool
HasRows ( string tableName, string condition, RowCountOptions options ) : bool
RowCountTask ( ) : ETLBox.Connection
RowCountTask ( string tableName ) : ETLBox.Connection
RowCountTask ( string tableName, RowCountOptions options ) : ETLBox.Connection
RowCountTask ( string tableName, string condition ) : ETLBox.Connection
RowCountTask ( string tableName, string condition, RowCountOptions options ) : ETLBox.Connection

Private Methods

Method Description
Execute ( ) : void

Method Details

Count() public method

Performs the row count
public Count ( ) : RowCountTask
return RowCountTask

Count() public static method

public static Count ( IConnectionManager connectionManager, string tableName ) : int
connectionManager IConnectionManager
tableName string
return int

Count() public static method

public static Count ( IConnectionManager connectionManager, string tableName, RowCountOptions options ) : int
connectionManager IConnectionManager
tableName string
options RowCountOptions
return int

Count() public static method

public static Count ( IConnectionManager connectionManager, string tableName, string condition ) : int
connectionManager IConnectionManager
tableName string
condition string
return int

Count() public static method

public static Count ( IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options ) : int
connectionManager IConnectionManager
tableName string
condition string
options RowCountOptions
return int

Count() public static method

public static Count ( string tableName ) : int
tableName string
return int

Count() public static method

public static Count ( string tableName, RowCountOptions options ) : int
tableName string
options RowCountOptions
return int

Count() public static method

public static Count ( string tableName, string condition ) : int
tableName string
condition string
return int

Count() public static method

public static Count ( string tableName, string condition, RowCountOptions options ) : int
tableName string
condition string
options RowCountOptions
return int

HasRows() public method

Checks if the table has at least one (matching) row.
public HasRows ( ) : RowCountTask
return RowCountTask

HasRows() public static method

public static HasRows ( IConnectionManager connectionManager, string tableName ) : bool
connectionManager IConnectionManager
tableName string
return bool

HasRows() public static method

public static HasRows ( IConnectionManager connectionManager, string tableName, RowCountOptions options ) : bool
connectionManager IConnectionManager
tableName string
options RowCountOptions
return bool

HasRows() public static method

public static HasRows ( IConnectionManager connectionManager, string tableName, string condition ) : bool
connectionManager IConnectionManager
tableName string
condition string
return bool

HasRows() public static method

public static HasRows ( IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options ) : bool
connectionManager IConnectionManager
tableName string
condition string
options RowCountOptions
return bool

HasRows() public static method

public static HasRows ( string tableName ) : bool
tableName string
return bool

HasRows() public static method

public static HasRows ( string tableName, RowCountOptions options ) : bool
tableName string
options RowCountOptions
return bool

HasRows() public static method

public static HasRows ( string tableName, string condition ) : bool
tableName string
condition string
return bool

HasRows() public static method

public static HasRows ( string tableName, string condition, RowCountOptions options ) : bool
tableName string
condition string
options RowCountOptions
return bool

RowCountTask() public method

public RowCountTask ( ) : ETLBox.Connection
return ETLBox.Connection

RowCountTask() public method

public RowCountTask ( string tableName ) : ETLBox.Connection
tableName string
return ETLBox.Connection

RowCountTask() public method

public RowCountTask ( string tableName, RowCountOptions options ) : ETLBox.Connection
tableName string
options RowCountOptions
return ETLBox.Connection

RowCountTask() public method

public RowCountTask ( string tableName, string condition ) : ETLBox.Connection
tableName string
condition string
return ETLBox.Connection

RowCountTask() public method

public RowCountTask ( string tableName, string condition, RowCountOptions options ) : ETLBox.Connection
tableName string
condition string
options RowCountOptions
return ETLBox.Connection