SqlIdFilterHelperT Properties

Connection string for the database. Can be null.

DbCommandTimeout is applied to SqlCommand objects created using CreateSqlCommand(). The DbCommandTimeout value is (normally) passed on to other controllers created by the controller. If DbCommandTimeout is Zero then the DB default will be used as timeout.

Consider using CreateCommand() instead of accessing DbConnection directly. DbConnection and DbTransaction are either specified when constucting the controller or the controller constructs them itself (by using ConnectionString) when calling DoInConnection or DoInTransaction. If the caller specified DbConnection and DbTransaction when constucting the controller then the caller is responsible for the management of the connection.

Consider using CreateCommand() instead of accessing DbTransaction directly. DbConnection and DbTransaction are either specified when constucting the controller or the controller constructs them itself (by using ConnectionString) when calling DoInConnection or DoInTransaction. If the caller specified DbConnection and DbTransaction when constucting the controller then the caller is responsible for the management of the connection.

Factory class for creating controller instances.

The ids to be filtered on.

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 Sql query where the Id filtering is going to be applied

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 #.