C# 클래스 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.

상속: GenericTask, ITask

파일 보기 프로젝트 열기: etlbox/etlbox

Private Properties

프로퍼티	타입	설명
Execute	void

공개 메소드들

메소드	설명
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

비공개 메소드들

메소드	설명
Execute ( ) : void

메소드 상세

Count() 공개 메소드

Performs the row count

public Count ( ) : RowCountTask
리턴	RowCountTask

Count() 공개 정적인 메소드

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

Count() 공개 정적인 메소드

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

Count() 공개 정적인 메소드

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

Count() 공개 정적인 메소드

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

Count() 공개 정적인 메소드

public static Count ( string tableName ) : int
tableName	string
리턴	int

Count() 공개 정적인 메소드

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

Count() 공개 정적인 메소드

public static Count ( string tableName, string condition ) : int
tableName	string
condition	string
리턴	int

Count() 공개 정적인 메소드

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

HasRows() 공개 메소드

Checks if the table has at least one (matching) row.

public HasRows ( ) : RowCountTask
리턴	RowCountTask

HasRows() 공개 정적인 메소드

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

HasRows() 공개 정적인 메소드

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

HasRows() 공개 정적인 메소드

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

HasRows() 공개 정적인 메소드

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

HasRows() 공개 정적인 메소드

public static HasRows ( string tableName ) : bool
tableName	string
리턴	bool

HasRows() 공개 정적인 메소드

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

HasRows() 공개 정적인 메소드

public static HasRows ( string tableName, string condition ) : bool
tableName	string
condition	string
리턴	bool

HasRows() 공개 정적인 메소드

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

RowCountTask() 공개 메소드

public RowCountTask ( ) : ETLBox.Connection
리턴	ETLBox.Connection

RowCountTask() 공개 메소드

public RowCountTask ( string tableName ) : ETLBox.Connection
tableName	string
리턴	ETLBox.Connection

RowCountTask() 공개 메소드

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

RowCountTask() 공개 메소드

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

RowCountTask() 공개 메소드

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