View Source

Class Query<T>

Represents a query builder.

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

A query builder translates Linq queries into Sql queries.

Constructors

View Source

Query(ISqlContext)

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

Methods

View Source

GetWhereClauses()

Returns all translated where clauses and their sql parameters

Declaration
public IEnumerable<Tuple<string, object[]>> GetWhereClauses()
Returns
Type Description
IEnumerable<Tuple<string, object[]>>
View Source

Where(Expression<Func<T, bool>>?)

Adds a where clause to the query.

Declaration
public virtual IQuery<T> Where(Expression<Func<T, bool>>? predicate)
Parameters
Type Name Description
Expression<Func<T, bool>> predicate
Returns
Type Description
IQuery<T>
View Source

WhereAny(IEnumerable<Expression<Func<T, bool>>>?)

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
IEnumerable<Expression<Func<T, bool>>> predicates
Returns
Type Description
IQuery<T>
View Source

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<Func<T, object>> fieldSelector
IEnumerable values
Returns
Type Description
IQuery<T>
View Source

WhereNotIn(Expression<Func<T, object>>?, IEnumerable?)

Adds a where-not-in clause to the query.

Declaration
public virtual IQuery<T> WhereNotIn(Expression<Func<T, object>>? fieldSelector, IEnumerable? values)
Parameters
Type Name Description
Expression<Func<T, object>> fieldSelector
IEnumerable values
Returns
Type Description
IQuery<T>