Class Query<T>

Represents a query builder.

Inheritance
System.Object
Namespace: Umbraco.Cms.Infrastructure.Persistence.Querying
Assembly: cs.temp.dll.dll
Syntax
public class Query<T> : IQuery<T>
Type Parameters
Name Description
T
Remarks

A query builder translates Linq queries into Sql queries.

Constructors

Query(ISqlContext)

Declaration
public Query(ISqlContext sqlContext)
Parameters
Type Name Description
ISqlContext sqlContext

Methods

GetWhereClauses()

Returns all translated where clauses and their sql parameters

Declaration
public IEnumerable<Tuple<string, object[]>> GetWhereClauses()
Returns
Type Description
System.Collections.Generic.IEnumerable<System.Tuple<System.String, System.Object[]>>

Where(Expression<Func<T, Boolean>>)

Adds a where clause to the query.

Declaration
public virtual IQuery<T> Where(Expression<Func<T, bool>> predicate)
Parameters
Type Name Description
Expression<System.Func<T, System.Boolean>> predicate
Returns
Type Description
IQuery<T>

WhereAny(IEnumerable<Expression<Func<T, Boolean>>>)

Adds a set of OR-ed where clauses to the query.

Declaration
public virtual IQuery<T> WhereAny(IEnumerable<Expression<Func<T, bool>>> predicates)
Parameters
Type Name Description
System.Collections.Generic.IEnumerable<Expression<System.Func<T, System.Boolean>>> predicates
Returns
Type Description
IQuery<T>

WhereIn(Expression<Func<T, Object>>, IEnumerable)

Adds a where-in clause to the query.

Declaration
public virtual IQuery<T> WhereIn(Expression<Func<T, object>> fieldSelector, IEnumerable values)
Parameters
Type Name Description
Expression<System.Func<T, System.Object>> fieldSelector
System.Collections.Generic.IEnumerable values
Returns
Type Description
IQuery<T>