Interface IFilteredQuery<T>

Represent result of filter (where) operation.

Inherited Members
Namespace: Kros.KORM.Query
Assembly: Kros.KORM.dll
Syntax
public interface IFilteredQuery<T> : IQueryBase<T>, IOrderedQueryable<T>, IQueryable<T>, IEnumerable<T>, IOrderedQueryable, IQueryable, IEnumerable
Type Parameters
Name Description
T

Type of model class.

Methods

GroupBy(String)

Add group by statement to sql query.

Declaration
IGroupedQuery<T> GroupBy(string groupBy)
Parameters
Type Name Description
System.String groupBy

The group by statement.
Returns
Type Description
IGroupedQuery<T>

Query for enumerable models.
Examples
                var people = database.Query<Person>().GroupBy("FirstName, LastName");
Exceptions
Type Condition
System.ArgumentNullException

if groupBy is null or white string.

OrderBy(String)

Add order by statement to sql.

Declaration
IOrderedQuery<T> OrderBy(string orderBy)
Parameters
Type Name Description
System.String orderBy

The order by statement.
Returns
Type Description
IOrderedQuery<T>

Query for enumerable models.
Examples
                var people = database.Query<Person>().OrderBy("FirstName DESC, LastName");
Exceptions
Type Condition
System.ArgumentNullException

if orderBy is null or white string.

See Also