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
Afficher le fichier Open project: etlbox/etlbox

Private Properties

Свойство Type Description
Execute void

Méthodes publiques

Méthode 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

Méthode Description
Execute ( ) : void

Method Details

Count() public méthode

Performs the row count
public Count ( ) : RowCountTask
Résultat RowCountTask

Count() public static méthode

public static Count ( IConnectionManager connectionManager, string tableName ) : int
connectionManager IConnectionManager
tableName string
Résultat int

Count() public static méthode

public static Count ( IConnectionManager connectionManager, string tableName, RowCountOptions options ) : int
connectionManager IConnectionManager
tableName string
options RowCountOptions
Résultat int

Count() public static méthode

public static Count ( IConnectionManager connectionManager, string tableName, string condition ) : int
connectionManager IConnectionManager
tableName string
condition string
Résultat int

Count() public static méthode

public static Count ( IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options ) : int
connectionManager IConnectionManager
tableName string
condition string
options RowCountOptions
Résultat int

Count() public static méthode

public static Count ( string tableName ) : int
tableName string
Résultat int

Count() public static méthode

public static Count ( string tableName, RowCountOptions options ) : int
tableName string
options RowCountOptions
Résultat int

Count() public static méthode

public static Count ( string tableName, string condition ) : int
tableName string
condition string
Résultat int

Count() public static méthode

public static Count ( string tableName, string condition, RowCountOptions options ) : int
tableName string
condition string
options RowCountOptions
Résultat int

HasRows() public méthode

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

HasRows() public static méthode

public static HasRows ( IConnectionManager connectionManager, string tableName ) : bool
connectionManager IConnectionManager
tableName string
Résultat bool

HasRows() public static méthode

public static HasRows ( IConnectionManager connectionManager, string tableName, RowCountOptions options ) : bool
connectionManager IConnectionManager
tableName string
options RowCountOptions
Résultat bool

HasRows() public static méthode

public static HasRows ( IConnectionManager connectionManager, string tableName, string condition ) : bool
connectionManager IConnectionManager
tableName string
condition string
Résultat bool

HasRows() public static méthode

public static HasRows ( IConnectionManager connectionManager, string tableName, string condition, RowCountOptions options ) : bool
connectionManager IConnectionManager
tableName string
condition string
options RowCountOptions
Résultat bool

HasRows() public static méthode

public static HasRows ( string tableName ) : bool
tableName string
Résultat bool

HasRows() public static méthode

public static HasRows ( string tableName, RowCountOptions options ) : bool
tableName string
options RowCountOptions
Résultat bool

HasRows() public static méthode

public static HasRows ( string tableName, string condition ) : bool
tableName string
condition string
Résultat bool

HasRows() public static méthode

public static HasRows ( string tableName, string condition, RowCountOptions options ) : bool
tableName string
condition string
options RowCountOptions
Résultat bool

RowCountTask() public méthode

public RowCountTask ( ) : ETLBox.Connection
Résultat ETLBox.Connection

RowCountTask() public méthode

public RowCountTask ( string tableName ) : ETLBox.Connection
tableName string
Résultat ETLBox.Connection

RowCountTask() public méthode

public RowCountTask ( string tableName, RowCountOptions options ) : ETLBox.Connection
tableName string
options RowCountOptions
Résultat ETLBox.Connection

RowCountTask() public méthode

public RowCountTask ( string tableName, string condition ) : ETLBox.Connection
tableName string
condition string
Résultat ETLBox.Connection

RowCountTask() public méthode

public RowCountTask ( string tableName, string condition, RowCountOptions options ) : ETLBox.Connection
tableName string
condition string
options RowCountOptions
Résultat ETLBox.Connection