ISSelectQueryBuilder Class

A utility class to assist building an SQL Select Query.
Used in 2 samples
Basic Query with Security Filters Complex WHERE Clauses

Methods

Name Description
Clear Clear the builder.
Clone Clone this object.
ExecuteAppendDataTable Execute Select Query and return a DataTable OR, if an existing DataTable is supplied, append the records to it.
ExecuteDataReader System Use Only Obsolete Execute Select Query and return a DataReader. Only a single connected DataReader can be open at any one time on most databases hence the option to use a disconnected reader based upon a DataTable.
ExecuteDataReader2 System Use Only Executes the SELECT Query and return a DataReader. If called from a Script or external application, a disconnected DataReader will be returned - you should use the ExecuteDisconnectedDataReader function instead.").
ExecuteDataSet Execute Select Query and return a DataSet.
ExecuteDataTable Execute Select Query and return a DataTable.
ExecuteDisconnectedDataReader ' Executes the SELECT Query and return a disconnected DataReader. '
GetRecordCount Retrieve a count of records in a Table.
GetScalarBinary Execute the query to retrieve a Binary Data value.
GetScalarBoolean Execute the query to retrieve a single Boolean value.
GetScalarDate Execute the query to retrieve a single Date value.
GetScalarDecimal Execute the query to retrieve a single Decimal value.
GetScalarEnum ' Execute the query to retrieve a single Double value. '
GetScalarInteger Execute the query to retrieve a single Integer value.
GetScalarIntegerBoolean Execute the query to retrieve a single Boolean value that is represented by an Integer (1 or 0) on the Database.
GetScalarString Execute the query to retrieve a single String value.
GetScalarUtcDate Execute the query to retrieve a single UTC Date value.
GetSql Creates an SQL Select Query.

Properties

Name Description
DistinctType The type of Distinct parameter to include after the SQL Select statement.
Fields Read-Only A collection of fields to include in the SQL Select Query.
GroupByFields Read-Only A collection of fields to group the SQL Select Query by.
Joins Read-Only A collection of table joins to include in the SQL Select Query.
OrderByFields Read-Only A collection of fields to order the SQL Select Query by.
SqlWhere Read-Only The SQL Where builder.
Table The main database Table to select from.
TableAlias An Alias for the main database Table to select from.
TableHintNoLock Applies the "NO LOCK" hint to Tables in the query (where the database provider supports). USE WITH EXTREME CAUTION.
TopLimit The Top number of records to Limit the Select Query by.
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0