Class UnionQuery<TResult>
A runnable union: the branches, the combine mode, and the combined ordering and paging.
public sealed class UnionQuery<TResult>
Type Parameters
TResultThe common result shape.
- Inheritance
-
UnionQuery<TResult>
- Inherited Members
Properties
All
Whether duplicates are kept (UNION ALL) or collapsed (UNION).
public bool All { get; }
Property Value
Branches
The branches, in order.
public IReadOnlyList<UnionBranch<TResult>> Branches { get; }
Property Value
- IReadOnlyList<UnionBranch<TResult>>
Limit
The maximum number of combined rows, when set.
public int? Limit { get; }
Property Value
- int?
Offset
The number of combined rows skipped, when set.
public int? Offset { get; }
Property Value
- int?
Order
The combined ordering over projected members, in order.
public IReadOnlyList<UnionOrder> Order { get; }
Property Value
Methods
OrderBy(Expression<Func<TResult, object?>>)
Orders the combined result by a projected member, ascending.
public UnionQuery<TResult> OrderBy(Expression<Func<TResult, object?>> member)
Parameters
memberExpression<Func<TResult, object>>The projected member.
Returns
- UnionQuery<TResult>
OrderByDescending(Expression<Func<TResult, object?>>)
Orders the combined result by a projected member, descending.
public UnionQuery<TResult> OrderByDescending(Expression<Func<TResult, object?>> member)
Parameters
memberExpression<Func<TResult, object>>The projected member.
Returns
- UnionQuery<TResult>
Skip(int)
Skips count combined rows — applied after the union, on the store, with Take(int).
public UnionQuery<TResult> Skip(int count)
Parameters
countintThe number of rows skipped.
Returns
- UnionQuery<TResult>
Take(int)
Limits the combined result to count rows — applied after the union, on the store.
public UnionQuery<TResult> Take(int count)
Parameters
countintThe maximum number of rows.
Returns
- UnionQuery<TResult>