SqlIdFilterHelperT Constructor (String, String, IEnumerableT, SQLBuilder, SqlConnection, SqlTransaction)

public SqlIdFilterHelper(
	string parameterName,
	string tempTable,
	IEnumerable<T> ids,
	SQLBuilder sql,
	SqlConnection dbConnection,
	SqlTransaction dbTransaction
)

Parameters

parameterName

Type: SystemString
Name of the Id sql parameters (each will be prefixed with "@" and postfixed with an index) used when an "where id in (@Id1, @Id2, @Id3)" is generated. Must not start with @. The specified parameterName must only be used once for the same query (relevant if the SqlIdFilterHelper class is used multiple times for building a query).

tempTable

Type: SystemString
Name of the temp table. The temp table gets a single column named "Id" (with datatype integer or uniqueidentifier). Used when there are too many ids for an "where id in (xxx)". Must not start with #.

ids

Type: System.Collections.GenericIEnumerableT
The ids list to be filtered on.

sql

Type: SQLBuilder
The id-where-clause will be added to this sql builder.

dbConnection

Type: System.Data.SqlClientSqlConnection

dbTransaction

Type: System.Data.SqlClientSqlTransaction

Reference