#ctor ( dal, loadOneToMany, loadOneToOne )
Initializes a new instance of the FluentQueryT class.
| Name | Type | Description |
|---|
| dal | Componyx.Data.DAL | - |
| loadOneToMany | System.Boolean | A value indicating if one-to-many relations of the target type should be loaded. |
| loadOneToOne | System.Boolean | A value indicating if one-to-one relations of the target type should be loaded. |
And ( propertyExpressions, openGroups )
Creates a SQL AND condition in the current query.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of lambda expressions: '() => Class.Property'. |
| openGroups | System.Int32 | A value indicating the amount of groups (parentheses) to open. |
ReturnsA FluentQueryT class.
And ( propertyName, openGroups )
Creates a SQL AND condition in the current query.
| Name | Type | Description |
|---|
| propertyName | System.String | The property name of the root class, dot separated tree name for parent/child classes or empty to use previous property. |
| openGroups | System.Int32 | A value indicating the amount of groups (parentheses) to open. |
ReturnsA FluentQueryT class.
And<T> ( propertyExpression, openGroups )
Creates a SQL AND condition in the current query.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{<T>}} | A lambda expression of the form: '() => Class.Property'. |
| openGroups | System.Int32 | A value indicating the amount of groups (parentheses) to open. |
ReturnsA FluentQueryT class.
Between ( rangeStart, rangeEnd, closeGroups )
Creates a between condition in the current query.
| Name | Type | Description |
|---|
| rangeStart | System.Object | The start value to compare. |
| rangeEnd | System.Object | The end value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
Contains ( value, closeGroups )
Creates a contains condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
Distinct ()
Adds the SQL DISTINCT keyword to return only unique (different) records.
ReturnsA FluentQueryT class.
Distinct ( propertyExpressions )
Adds the SQL DISTINCT keyword to return only unique (different) records.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of lambda expressions: '() => Class.Property'. |
ReturnsA FluentQueryT class.
Distinct ( propertyExpression )
Adds the SQL DISTINCT keyword to return only unique (different) records.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{System.Object}} | A lambda expression: '() => Class.Property'. |
ReturnsA FluentQueryT class.
Distinct ( propertyName )
Adds the SQL DISTINCT keyword to return only unique (different) records.
| Name | Type | Description |
|---|
| propertyName | System.String | The property name, dot separated tree name for parent/child classes or a single dot for previous property name. |
ReturnsA FluentQueryT class.
EndsWith ( value, closeGroups )
Creates an ends with condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
EqualTo ( value, closeGroups )
Creates an equal to condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
GreaterThan ( value, closeGroups )
Creates a greater than condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
GreaterThanOrEqualTo ( value, closeGroups )
Creates a greater than or equal to condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
GroupBy ( propertyExpressions )
Creates a SQL GROUP BY statement in the current query.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of lambda expressions: '() => Class.Property'. |
ReturnsA FluentQueryT class.
GroupBy ( propertyName )
Creates a SQL GROUP BY statement in the current query.
| Name | Type | Description |
|---|
| propertyName | System.String | The property name, dot separated tree name for parent/child classes or a single dot for previous property name. |
ReturnsA FluentQueryT class.
GroupBy<T> ( propertyExpression )
Creates a SQL GROUP BY statement in the current query.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{<T>}} | A lambda expression of the form: '() => Class.Property'. |
ReturnsA FluentQueryT class.
In<T> ( values, closeGroups )
Creates an in condition in the current query.
| Name | Type | Description |
|---|
| values | System.Collections.Generic.List{<T>} | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
JoinOn ( propertyExpressions, whereClause )
Appends a filter to the SQL JOIN ON statement for the corresponding table join.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of Lambda expressions: '() => Class.Property'. |
| whereClause | System.String | A SQL WHERE clause. |
ReturnsA FluentQueryT class.
JoinOn ( propertyName, whereClause )
Appends a filter to the SQL JOIN ON statement for the corresponding table join.
| Name | Type | Description |
|---|
| propertyName | System.String | The dot separated tree name for a property of a parent/child classes. |
| whereClause | System.String | A SQL WHERE clause. |
ReturnsA FluentQueryT class.
JoinOn<T> ( propertyExpression, whereClause )
Appends a filter to the SQL JOIN ON statement for the corresponding table join.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{<T>}} | A lambda expressions: '() => Class.Property'. |
| whereClause | System.String | A SQL WHERE clause. |
ReturnsA FluentQueryT class.
LessThan ( value, closeGroups )
Creates a less than condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
LessThanOrEqualTo ( value, closeGroups )
Creates a less than or equal to condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
NotBetween ( rangeStart, rangeEnd, closeGroups )
Creates a not between condition in the current query.
| Name | Type | Description |
|---|
| rangeStart | System.Object | The start value to compare. |
| rangeEnd | System.Object | The end value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
NotContains ( value, closeGroups )
Creates a contains condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
NotEndsWith ( value, closeGroups )
Creates a not ends with condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
NotEqualTo ( value, closeGroups )
Creates a not equal to condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
NotIn<T> ( values, closeGroups )
Creates a not in condition in the current query.
| Name | Type | Description |
|---|
| values | System.Collections.Generic.List{<T>} | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
NotStartsWith ( value, closeGroups )
Creates a not starts with condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
Or ( propertyExpressions, openGroups )
Creates a SQL OR condition in the current query.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of lambda expressions: '() => Class.Property'. |
| openGroups | System.Int32 | A value indicating the amount of groups (parentheses) to open. |
ReturnsA FluentQueryT class.
Or ( propertyName, openGroups )
Creates a SQL OR condition in the current query.
| Name | Type | Description |
|---|
| propertyName | System.String | The property name of the root class, dot separated tree name for parent/child classes or empty to use previous property. |
| openGroups | System.Int32 | A value indicating the amount of groups (parentheses) to open. |
ReturnsA FluentQueryT class.
Or<T> ( propertyExpression, openGroups )
Creates a SQL OR condition in the current query.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{<T>}} | A lambda expression of the form: '() => Class.Property'. |
| openGroups | System.Int32 | A value indicating the amount of groups (parentheses) to open. |
ReturnsA FluentQueryT class.
OrderBy ( propertyExpressions, descending )
Creates a SQL ORDER BY statement in the current query.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of lambda expressions: '() => Class.Property'. |
| descending | System.Boolean | A value indicating if the order should be descending. |
ReturnsA FluentQueryT class.
OrderBy ( propertyName, descending )
Creates a SQL ORDER BY statement in the current query.
| Name | Type | Description |
|---|
| propertyName | System.String | The property name, dot separated tree name for parent/child classes or a single dot for previous property name. |
| descending | System.Boolean | A value indicating if the order should be descending. |
ReturnsA FluentQueryT class.
OrderBy<T> ( propertyExpression, descending )
Creates a SQL ORDER BY statement in the current query.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{<T>}} | A lambda expression: '() => Class.Property'. |
| descending | System.Boolean | A value indicating if the order should be descending. |
ReturnsA FluentQueryT class.
Skip ( count )
Skips a specified number of records in the result set.
| Name | Type | Description |
|---|
| count | System.Int32 | - |
ReturnsA FluentQueryT class.
SqlHaving ( text, propertyNames )
Creates the HAVING clause within the query with the specified SQL text.
| Name | Type | Description |
|---|
| text | System.String | The SQL text. Use default string format placeholders for property names. |
| propertyNames | System.Collections.Generic.List{System.String} | A list of property names to replace through string format within the specified SQL text. |
ReturnsA FluentQueryT class.
SqlOrderBy ( text, propertyNames )
Appends the current ORDER BY clause within the query with the specified SQL text.
| Name | Type | Description |
|---|
| text | System.String | The SQL text. Use default string format placeholders for property names. |
| propertyNames | System.Collections.Generic.List{System.String} | A list of property names to replace through string format within the specified SQL text. |
ReturnsA FluentQueryT class.
SqlSelect ( text, propertyNames )
Appends the current SELECT clause within the query with the specified SQL text.
| Name | Type | Description |
|---|
| text | System.String | The SQL text. Use default string format placeholders for property names. |
| propertyNames | System.Collections.Generic.List{System.String} | A list of property names to replace through string format within the specified SQL text. |
ReturnsA FluentQueryT class.
SqlWhere ( text, propertyNames, addOperator )
Appends the current WHERE or JOIN clause within the query with the specified SQL text.
| Name | Type | Description |
|---|
| text | System.String | The SQL text. Use default string format placeholders for property names. |
| propertyNames | System.Collections.Generic.List{System.String} | A list of property names to replace through string format within the specified SQL text. |
| addOperator | System.Boolean | A value indicating if the AND operator is added to the SQL Where clause if the text does not start with an AND/OR operator. |
ReturnsA FluentQueryT class.
StartsWith ( value, closeGroups )
Creates a starts with condition in the current query.
| Name | Type | Description |
|---|
| value | System.Object | The value to compare. |
| closeGroups | System.Int32 | A value indicating the amount of groups (parentheses) to close. |
ReturnsA FluentQueryT class.
Take ( count )
Takes a specified number of records from the result set.
| Name | Type | Description |
|---|
| count | System.Int32 | - |
ReturnsA FluentQueryT class.
TakePage ( pageIndex )
Takes the specified page from the result set.
| Name | Type | Description |
|---|
| pageIndex | System.Int32 | - |
ReturnsA FluentQueryT class.
ToDataSet ()
Executes the generated query and returns the result as dataset.
ToDataSetAsync ()
Executes the generated query and returns the result as dataset.
ToList ()
Executes the generated query and returns the result as a list of T.
ToListAsync ()
Executes the generated query and returns the result as a list of T.
Where ( propertyExpressions, addOperator, handleGroups )
Creates a SQL WHERE statement.
| Name | Type | Description |
|---|
| propertyExpressions | System.Collections.Generic.List{System.Linq.Expressions.Expression{System.Func{System.Object}}} | A list of Lambda expressions: '() => Class.Property'. |
| addOperator | System.Boolean | A value indicating if the AND operator is added to the SQL Where clause if the text does not start with an AND/OR operator. |
| handleGroups | System.Boolean | A value indicating if groups (parentheses) are closed and/or opened. |
ReturnsA FluentQueryT class.
Where ( propertyName, addOperator, handleGroups )
Creates a SQL WHERE statement.
| Name | Type | Description |
|---|
| propertyName | System.String | The property name of the root class or dot separated tree name for a property of a parent/child classes. |
| addOperator | System.Boolean | A value indicating if the AND operator is added to the SQL Where clause if the text does not start with an AND/OR operator. |
| handleGroups | System.Boolean | A value indicating if groups (parentheses) are closed and/or opened. |
ReturnsA FluentQueryT class.
Where<T> ( propertyExpression, addOperator, handleGroups )
Creates a SQL WHERE statement.
| Name | Type | Description |
|---|
| propertyExpression | System.Linq.Expressions.Expression{System.Func{<T>}} | A lambda expression: '() => Class.Property'. |
| addOperator | System.Boolean | A value indicating if the AND operator is added to the SQL Where clause if the text does not start with an AND/OR operator. |
| handleGroups | System.Boolean | A value indicating if groups (parentheses) are closed and/or opened. |
ReturnsA FluentQueryT class.