SelectQuery Methods
The SelectQuery type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
|
AddOrderByBoolTextSegment(String, OrderByTypes, String, String, Boolean) |
Adds the order by bool text segment.
|
|
|
AddOrderByBoolTextSegment(QueryTable, String, OrderByTypes, String, String, Boolean) |
Adds the order by bool text segment.
|
|
|
AddOrderByEnumSegment<(Of <<'(T>)>>)(String, OrderByTypes, Boolean) |
Adds an order by enumerator segment.
|
|
|
AddOrderByEnumSegment<(Of <<'(T>)>>)(QueryTable, String, OrderByTypes, Boolean) |
Adds an order by enumerator segment.
|
|
|
AddOrderByFormulaSegment |
Adds a formula order by segment.
|
|
|
AddOrderBySegment(String, OrderByTypes, Boolean) |
Adds an order by segment.
|
|
|
AddOrderBySegment(QueryTable, String, OrderByTypes, Boolean) |
Adds an order by segment.
|
|
|
AddPrimaryJoinTable(JoinTypes, String) |
Adds a primary join table.
|
|
|
AddPrimaryJoinTable(JoinTypes, QueryTable, String) |
Adds a primary join table.
|
|
|
AddPrimaryJoinTable(JoinTypes, String, String) |
Adds a primary join table.
|
|
|
AddPrimaryJoinTable(JoinTypes, QueryTable, String, String) |
Adds a primary join table.
|
|
|
AddSelectBooleanColumn(String, String, String, String) |
Adds the select boolean column.
|
|
|
AddSelectBooleanColumn(QueryTable, String, String, String, String) |
Adds the select boolean column.
|
|
|
AddSelectColumn(String, Boolean) |
Adds a column to the columns list.
|
|
|
AddSelectColumn(String, String, Boolean) |
Adds a column to the columns list.
|
|
|
AddSelectColumn(String, QueryTable, Boolean) |
Adds a column to the columns list.
|
|
|
AddSelectColumn(String, QueryTable, String, Boolean) |
Adds a column to the columns list.
|
|
|
AddSelectEnumColumn<(Of <<'(T>)>>)(String, String) |
Creates an enumerator column and adds it to the columns list.
|
|
|
AddSelectEnumColumn<(Of <<'(T>)>>)(QueryTable, String, String) |
Creates an enumerator column and adds it to the columns list.
|
|
|
AddSelectFormulaColumn |
Creates a formula column and adds it to the columns list.
|
|
|
AddWhereItem(String, Conditions, String, Boolean, ValueTypes) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(QueryTable, String, Conditions, String, Boolean, ValueTypes) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(String, Conditions, DateTime, DbDateTypes) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(QueryTable, String, Conditions, DateTime, DbDateTypes) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(String, Conditions, Int32) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(QueryTable, String, Conditions, Int32) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(String, Conditions, Double) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(QueryTable, String, Conditions, Double) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(String, Conditions, Boolean) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(QueryTable, String, Conditions, Boolean) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItem(QueryTable, String, Conditions, String, ValueTypes, DbDateTypes) |
Creates a where item object and adds it to the WhereItems list.
|
|
|
AddWhereItemBoolText(String, Conditions, String, String, String) |
Adds the where item bool text.
|
|
|
AddWhereItemBoolText(QueryTable, String, Conditions, String, String, String) |
Adds the where item bool text.
|
|
|
AddWhereItemCheckNull |
Adds the where item check null.
|
|
|
AddWhereItemEnum<(Of <<'(T>)>>)(String, Conditions, String) |
Creates an enumerator where item and adds it to the where items list.
|
|
|
AddWhereItemEnum<(Of <<'(T>)>>)(QueryTable, String, Conditions, String) |
Creates an enumerator where item and adds it to the where items list.
|
|
|
AddWhereItemFormula(String, Conditions, String) |
Creates a where item formula object and adds it to the WhereItems list.
|
|
|
AddWhereItemFormula(String, Conditions, DateTime, DbDateTypes) |
Creates a where item formula object and adds it to the WhereItems list.
|
|
|
AddWhereItemFormula(String, Conditions, Int32) |
Creates a where item formula object and adds it to the WhereItems list.
|
|
|
AddWhereItemFormula(String, Conditions, Double) |
Creates a where item formula object and adds it to the WhereItems list.
|
|
|
AddWhereItemFormula(String, Conditions, Boolean) |
Creates a where item formula object and adds it to the WhereItems list.
|
|
|
AddWhereItemFormula(String) |
Creates a where item formula object and adds it to the WhereItems list. Used for formulas that have no condition or value.
|
|
BoolToString |
Bools to string.
|
|
|
CopySelectColumnsToTopLevelQuery |
Copies the select columns to top level query.
|
|
|
RemoveWhereItem |
Removes the where item.
|
|
|
SetMaxRecords |
Sets the maximum number of records to retrieve.
|