Class EntityBuilder<TEntity>

Namespace

NextORM.Core

Assembly

nextorm.core.dll

Fluent, immutable query builder over a mapped entity type; created by IDataContext.From<TEntity>().

public class EntityBuilder<TEntity> : ICloneable

Type Parameters

TEntity

The mapped entity type the query projects.

Inheritance

object

EntityBuilder<TEntity>

Implements

ICloneable

Derived

JoinedEntityBuilder<T1, T2>

JoinedEntityBuilder<T1, T2, T3>

JoinedEntityBuilder<T1, T2, T3, T4>

JoinedEntityBuilder<T1, T2, T3, T4, T5>

JoinedEntityBuilder<T1, T2, T3, T4, T5, T6>

JoinedEntityBuilder<T1, T2, T3, T4, T5, T6, T7>

JoinedEntityBuilder<T1, T2, T3, T4, T5, T6, T7, T8>

TvfEntityBuilder<T>

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

ClickHouseEntityBuilderExtensions.AntiJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

ClickHouseEntityBuilderExtensions.AntiJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, QueryCommand<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

ClickHouseEntityBuilderExtensions.ArrayJoinElement<TEntity, TElement>(EntityBuilder<TEntity>, Expression<Func<TEntity, IEnumerable<TElement>>>)

ClickHouseEntityBuilderExtensions.ArrayJoin<TEntity, TArray>(EntityBuilder<TEntity>, Expression<Func<TEntity, TArray>>)

ClickHouseEntityBuilderExtensions.Final<TEntity>(EntityBuilder<TEntity>)

ClickHouseEntityBuilderExtensions.LeftArrayJoinElement<TEntity, TElement>(EntityBuilder<TEntity>, Expression<Func<TEntity, IEnumerable<TElement>>>)

ClickHouseEntityBuilderExtensions.LeftArrayJoin<TEntity, TArray>(EntityBuilder<TEntity>, Expression<Func<TEntity, TArray>>)

ClickHouseEntityBuilderExtensions.LimitBy<TEntity, TResult>(EntityBuilder<TEntity>, int, int, Expression<Func<TEntity, TResult>>)

ClickHouseEntityBuilderExtensions.LimitBy<TEntity, TResult>(EntityBuilder<TEntity>, int, Expression<Func<TEntity, TResult>>)

ClickHouseEntityBuilderExtensions.PasteJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, EntityBuilder<TJoinEntity>, Action<JoinOptions>?)

ClickHouseEntityBuilderExtensions.PasteJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, QueryCommand<TJoinEntity>, Action<JoinOptions>?)

ClickHouseEntityBuilderExtensions.PreWhere<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, bool>>)

ClickHouseEntityBuilderExtensions.SemiJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

ClickHouseEntityBuilderExtensions.SemiJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, QueryCommand<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

ClickHouseEntityBuilderExtensions.Settings<TEntity>(EntityBuilder<TEntity>, params (string Key, string Value)[])

ClickHouseEntityBuilderExtensions.WithTotals<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.AnyAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.AnyAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.AnyCommand<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.Any<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.Any<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong?>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong?>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint>>, CancellationToken, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong>>, params object[])

EntityBuilderExtensions.AvgAsync<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong>>, CancellationToken, params object[])

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, byte?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, decimal?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, double?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, short?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, int?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, long?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong?>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, sbyte>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, float>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ushort>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, uint>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong>>)

EntityBuilderExtensions.Avg<TEntity>(EntityBuilder<TEntity>, Expression<Func<TEntity, ulong>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.CountAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.CountAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.Count<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.Count<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.FirstAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.FirstAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.FirstOrDefaultAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.FirstOrDefaultAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.FirstOrDefault<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.FirstOrDefault<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.FirstOrFirstOrDefaultCommand<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.FirstOrFirstOrDefaultCommand<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.First<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.First<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.LastAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.LastAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.LastOrDefaultAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.LastOrDefaultAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.LastOrDefault<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.LastOrDefault<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Last<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.Last<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.LongCountAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.LongCountAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.LongCount<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.LongCount<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.MaxAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.MaxAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Max<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Max<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.MinAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.MinAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Min<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Min<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Prepare<TEntity>(EntityBuilder<TEntity>, PrepareOptions, CancellationToken)

EntityBuilderExtensions.SingleAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.SingleAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.SingleOrDefaultAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.SingleOrDefaultAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.SingleOrDefault<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.SingleOrDefault<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.SingleOrSingleOrDefaultCommand<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.SingleOrSingleOrDefaultCommand<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Single<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.Single<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.StdevAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params object[])

EntityBuilderExtensions.StdevAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, CancellationToken, params object[])

EntityBuilderExtensions.StdevAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.StdevAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Stdev<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>)

EntityBuilderExtensions.Stdev<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Stdev<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Stdev<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.StdevpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params object[])

EntityBuilderExtensions.StdevpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, CancellationToken, params object[])

EntityBuilderExtensions.StdevpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.StdevpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Stdevp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>)

EntityBuilderExtensions.Stdevp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Stdevp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Stdevp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.SumAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.SumAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Sum<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Sum<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.ToArrayAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.ToArrayAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.ToArray<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.ToArray<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.ToAsyncEnumerable<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.ToAsyncEnumerable<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.ToDictionaryAsync<TEntity, TKey>(EntityBuilder<TEntity>, Func<TEntity, TKey>, IEqualityComparer<TKey>?, CancellationToken, params object[])

EntityBuilderExtensions.ToDictionaryAsync<TEntity, TKey>(EntityBuilder<TEntity>, Func<TEntity, TKey>, params object[])

EntityBuilderExtensions.ToDictionaryAsync<TEntity, TKey>(EntityBuilder<TEntity>, Func<TEntity, TKey>, CancellationToken, params object[])

EntityBuilderExtensions.ToDictionary<TEntity, TKey>(EntityBuilder<TEntity>, Func<TEntity, TKey>, IEqualityComparer<TKey>?, params ReadOnlySpan<object?>)

EntityBuilderExtensions.ToDictionary<TEntity, TKey>(EntityBuilder<TEntity>, Func<TEntity, TKey>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.ToEnumerable<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.ToHashSetAsync<TEntity>(EntityBuilder<TEntity>, IEqualityComparer<TEntity>?, CancellationToken, params object[])

EntityBuilderExtensions.ToHashSetAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.ToHashSetAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.ToHashSet<TEntity>(EntityBuilder<TEntity>, IEqualityComparer<TEntity>?, params ReadOnlySpan<object?>)

EntityBuilderExtensions.ToHashSet<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.ToListAsync<TEntity>(EntityBuilder<TEntity>, params object[])

EntityBuilderExtensions.ToListAsync<TEntity>(EntityBuilder<TEntity>, CancellationToken, params object[])

EntityBuilderExtensions.ToList<TEntity>(EntityBuilder<TEntity>)

EntityBuilderExtensions.ToList<TEntity>(EntityBuilder<TEntity>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.VarAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params object[])

EntityBuilderExtensions.VarAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, CancellationToken, params object[])

EntityBuilderExtensions.VarAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.VarAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Var<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>)

EntityBuilderExtensions.Var<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Var<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Var<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.VarpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params object[])

EntityBuilderExtensions.VarpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, CancellationToken, params object[])

EntityBuilderExtensions.VarpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params object[])

EntityBuilderExtensions.VarpAsync<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, CancellationToken, params object[])

EntityBuilderExtensions.Varp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>)

EntityBuilderExtensions.Varp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult?>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.Varp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.Varp<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, params ReadOnlySpan<object?>)

EntityBuilderExtensions.WriteCsvAsync<TEntity>(EntityBuilder<TEntity>, Stream, CsvStreamOptions?, CancellationToken, params object?[])

EntityBuilderExtensions.WriteCsv<TEntity>(EntityBuilder<TEntity>, Stream, CsvStreamOptions?, CancellationToken, params ReadOnlySpan<object?>)

EntityBuilderExtensions.WriteJsonAsync<TEntity>(EntityBuilder<TEntity>, Stream, JsonStreamOptions, CancellationToken)

EntityBuilderExtensions.WriteJsonAsync<TEntity>(EntityBuilder<TEntity>, Stream, JsonStreamOptions, CancellationToken, params object?[])

EntityBuilderExtensions.WriteJsonAsync<TEntity>(EntityBuilder<TEntity>, Stream, CancellationToken)

EntityBuilderExtensions.WriteJson<TEntity>(EntityBuilder<TEntity>, Stream)

EntityBuilderExtensions.WriteJson<TEntity>(EntityBuilder<TEntity>, Stream, JsonStreamOptions)

EntityBuilderExtensions.WriteJson<TEntity>(EntityBuilder<TEntity>, Stream, JsonStreamOptions, CancellationToken, params ReadOnlySpan<object?>)

EntityExtensions.PrepareFromSql<TResult>(EntityBuilder<TResult>, string)

EntityExtensions.WithSql<TResult>(EntityBuilder<TResult>, string)

EntityExtensions.WithSql<TResult>(EntityBuilder<TResult>, string, object?)

InMemoryCommandBuilderExtensions.WithAsyncData<TEntity>(EntityBuilder<TEntity>, IAsyncEnumerable<TEntity>?)

InMemoryCommandBuilderExtensions.WithData<TEntity>(EntityBuilder<TEntity>, IEnumerable<TEntity>?)

TempTableExtensions.AsTempTable<TResult>(EntityBuilder<TResult>, CreateTableOptions?)

TempTableExtensions.AsTempTable<TResult>(EntityBuilder<TResult>, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>)

TempTableExtensions.ToTableAsync<TResult>(EntityBuilder<TResult>, string, CreateTableOptions?, CancellationToken)

TempTableExtensions.ToTableAsync<TResult>(EntityBuilder<TResult>, string, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>, CancellationToken)

TempTableExtensions.ToTableSql<TResult>(EntityBuilder<TResult>, string, CreateTableOptions?)

TempTableExtensions.ToTableSql<TResult>(EntityBuilder<TResult>, string, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>)

TempTableExtensions.ToTable<TResult>(EntityBuilder<TResult>, string, CreateTableOptions?)

TempTableExtensions.ToTable<TResult>(EntityBuilder<TResult>, string, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>)

TempTableExtensions.ToTempTableAsync<TResult>(EntityBuilder<TResult>, string, CreateTableOptions?, CancellationToken)

TempTableExtensions.ToTempTableAsync<TResult>(EntityBuilder<TResult>, string, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>, CancellationToken)

TempTableExtensions.ToTempTableSql<TResult>(EntityBuilder<TResult>, string, CreateTableOptions?)

TempTableExtensions.ToTempTableSql<TResult>(EntityBuilder<TResult>, string, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>)

TempTableExtensions.ToTempTable<TResult>(EntityBuilder<TResult>, string, CreateTableOptions?)

TempTableExtensions.ToTempTable<TResult>(EntityBuilder<TResult>, string, Func<CreateTableOptionsBuilder, CreateTableOptionsBuilder>)

TvfJoinSourceExtensions.CrossApply<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>)

TvfJoinSourceExtensions.CrossJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>)

TvfJoinSourceExtensions.FullJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>)

TvfJoinSourceExtensions.FullJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>)

TvfJoinSourceExtensions.Join<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>)

TvfJoinSourceExtensions.Join<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>)

TvfJoinSourceExtensions.LeftJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>)

TvfJoinSourceExtensions.LeftJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>)

TvfJoinSourceExtensions.OuterApply<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>)

TvfJoinSourceExtensions.RightJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>)

TvfJoinSourceExtensions.RightJoin<TEntity, TJoinEntity>(EntityBuilder<TEntity>, Expression<Func<EntityBuilder<TJoinEntity>>>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>)

ExtremeRowExtensions.SelectWhereMax<TEntity, TValue>(EntityBuilder<TEntity>, Expression<Func<TEntity, TValue>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

ExtremeRowExtensions.SelectWhereMax<TEntity, TValue, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TValue>>, Expression<Func<TEntity, TResult>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

ExtremeRowExtensions.SelectWhereMin<TEntity, TValue>(EntityBuilder<TEntity>, Expression<Func<TEntity, TValue>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

ExtremeRowExtensions.SelectWhereMin<TEntity, TValue, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TValue>>, Expression<Func<TEntity, TResult>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

SelectGroupExtensions.SelectGroupHaving<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>, Expression<Func<TResult, bool>>)

SelectGroupExtensions.SelectGroup<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

PostgresEntityBuilderExtensions.DistinctOn<TEntity, TResult>(EntityBuilder<TEntity>, Expression<Func<TEntity, TResult>>)

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Constructors

EntityBuilder()

Initializes an unbound builder: a context-independent composition of a runtime source descriptor. The chain carries no data context on purpose — no placeholder context is ever constructed — so every context-dependent operation fails explicitly through RequireContext until the source is consumed by IDataContext.From(Expression<Func<EntityBuilder<T>>>).

protected EntityBuilder()

EntityBuilder(IDataContext)

Initializes a builder over the mapped entity type; the source is resolved from entity metadata.

public EntityBuilder(IDataContext dataProvider)

Parameters

dataProvider IDataContext

The data context that creates the query command.

EntityBuilder(IDataContext, QueryCommand<TEntity>)

Initializes a builder whose source is the derived query.

public EntityBuilder(IDataContext dataProvider, QueryCommand<TEntity> query)

Parameters

dataProvider IDataContext

The data context that creates the query command.

query QueryCommand<TEntity>

The derived query to select from.

EntityBuilder(IDataContext, string)

Initializes a builder over the raw table named table.

public EntityBuilder(IDataContext dataProvider, string table)

Parameters

dataProvider IDataContext

The data context that creates the query command.

table string

The physical table name to select from.

Exceptions

ArgumentNullException

table is null.

ArgumentException

table is empty or consists only of white-space characters.

Fields

Paging

The limit/offset paging state set by Limit, Offset and Page.

public Paging Paging

Field Value

Paging

_dataProvider

The data context this builder creates commands from and resolves sources against, or null when the builder composes an unbound, context-independent source (a runtime TVF descriptor). Context-dependent operations must go through RequireContext, never this field.

protected readonly IDataContext? _dataProvider

Field Value

IDataContext

_joins

The join clauses collected so far, or null when the query has no joins.

protected List<JoinExpression>? _joins

Field Value

List<JoinExpression>

Properties

Joins

The join clauses applied to the query, or null when there are none.

public List<JoinExpression>? Joins { get; set; }

Property Value

List<JoinExpression>

RequireContext

The data context this builder is bound to. On an unbound source chain the operation is rejected with InvalidOperationException instead of executing against entity metadata or dereferencing a missing context.

protected IDataContext RequireContext { get; }

Property Value

IDataContext

Exceptions

InvalidOperationException

The builder composes an unbound source.

Sorting

The ordering keys applied by OrderBy/OrderByDescending, or null when the query is unordered.

public List<Sorting>? Sorting { get; set; }

Property Value

List<Sorting>

Methods

AliasRoot<TNext, TNextEntity>(Func<IDataContext, TNext>)

Root-alias seam (issue #160, Phase 2): re-roots a plain source builder into a caller-created builder whose projection shape names the root slot 1 lexically (for example AliasProjection_A1_Order<Order>), preserving the source's query state (physical table or derived source, CTE declarations, overrides, source options and hints). The generated .WithAlias(Alias.X) extension supplies create. It is root-only: a builder that already carries a join, JoinInto or a projection shape is rejected, and the in-memory provider fails closed because it cannot project named aliases.

public TNext AliasRoot<TNext, TNextEntity>(Func<IDataContext, TNext> create) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

Returns

TNext

A new TNext carrying this builder's source state and no joins.

Type Parameters

TNext

The generated builder type that receives the root alias.

TNextEntity

The root-alias projection type TNext is built over.

Exceptions

ArgumentNullException

create is null.

NotSupportedException

The in-memory provider cannot project named aliases, or the receiver is not the root source.

As<TResult>(Expression<Func<TEntity, TResult>>)

Projects each row with selector and exposes the result as a derived table, returning a builder that can be joined, filtered and projected further. This names an intermediate join projection (typically p => new { p.Item1.X, p.Item2.Y }) and starts a new join from it, so the fixed Projection<T1..T8> arity cap no longer terminates the chain: ...Join(...).As(p => new { ... }).Join(...) works on every arity.

public EntityBuilder<TResult> As<TResult>(Expression<Func<TEntity, TResult>> selector)

Parameters

selector Expression<Func<TEntity, TResult>>

The projection expression, for example p => new { p.Item1.Id, p.Item2.Name }.

Returns

EntityBuilder<TResult>

A builder over the derived table that can be composed further.

Type Parameters

TResult

The named projection type produced by selector.

Remarks

Implemented as DataProvider.From(Select(selector)): only the projected members stay visible to later joins, and the projection becomes a materialization boundary, so outer-join semantics across the boundary follow derived-table rules. A subsequent Join on the in-memory provider throws NotSupportedException (derived sources cannot be joined in memory).

Exceptions

NotSupportedException

A following Join/Apply on the derived source is rejected by the in-memory provider.

Asc(Expression<Func<TEntity, object?>>)

Ascending ORDER BY key of a named window declared with Window(string, Expression<Func<TEntity, object?>>[]?, NamedWindowOrderKey[]?, WindowFrame?).

public NamedWindowOrderKey Asc(Expression<Func<TEntity, object?>> expression)

Parameters

expression Expression<Func<TEntity, object>>

Returns

NamedWindowOrderKey

Clone()

Returns a copy of this builder. Because the modifier methods already return copies, this is useful to fork a query without applying a modifier.

public EntityBuilder<TEntity> Clone()

Returns

EntityBuilder<TEntity>

A new builder with the same state.

CloneImp()

Creates the copy returned by Clone() and the explicit ICloneable.Clone call. Overridden by derived builders to clone their extra state.

protected virtual object CloneImp()

Returns

object

A new builder with the same state.

CopyTo(EntityBuilder<TEntity>)

Copies this builder's state onto dst; called by CloneImp(). Protected so derived builders can extend the copy with their own state.

protected virtual void CopyTo(EntityBuilder<TEntity> dst)

Parameters

dst EntityBuilder<TEntity>

The builder that receives the state.

Remarks

Collections that no writer ever mutates in place are shared with the copy rather than duplicated: _loadSpecs and _joinIntos are always replaced wholesale by LoadWith/JoinInto, and _windows is appended to only through Window, which detaches the shared list before its first write. _arrayJoins and _joins stay copied because provider extensions (ClickHouse ArrayJoin/semi-anti join) append to them in place after a clone; the copy keeps those writes off the parent and its sibling branches.

CrossApply(string, Action<JoinOptions>?)

Adds a CROSS APPLY over the table named table without an explicit source.

public JoinedEntityBuilder<TEntity, TableAlias> CrossApply(string table, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null, empty, or whitespace-only table is rejected at the call site with ArgumentNullException / ArgumentException (ParamName == "table"), matching the explicit ctx.From(table) form.

CrossApply<TJoinEntity>(Cte<TJoinEntity>)

Applies the typed CTE cte with CROSS APPLY.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(Cte<TJoinEntity> cte)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the applied projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte is null.

CrossApply<TJoinEntity>(Cte<TJoinEntity>, Action<JoinOptions>?)

Applies the typed CTE cte with CROSS APPLY and per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(Cte<TJoinEntity> cte, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the applied projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte is null.

CrossApply<TJoinEntity>(EntityBuilder<TJoinEntity>, Action<JoinOptions>?)

Applies _ to every left-hand row (CROSS APPLY / CROSS JOIN LATERAL). There is no ON condition.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(EntityBuilder<TJoinEntity> _, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the applied entity; only its source is used.

options Action<JoinOptions>

Optional per-join configuration; an APPLY rejects strictness/GLOBAL/table hints at render time but folds a join hint into the statement-level hint comment on inline-hint dialects.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the applied projection.

Type Parameters

TJoinEntity

CrossApply<TJoinEntity>(QueryCommand<TJoinEntity>, Action<JoinOptions>?)

Applies a derived query to every left-hand row (CROSS APPLY).

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(QueryCommand<TJoinEntity> query, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

options Action<JoinOptions>

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

Type Parameters

TJoinEntity

CrossApply<TJoinEntity>(Action<JoinOptions>?)

Adds a CROSS APPLY over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(Action<JoinOptions>? options = null)

Parameters

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

CrossApply<TJoinEntity>(Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>, Action<JoinOptions>?)

Applies a correlated derived query to every left-hand row (CROSS APPLY / CROSS JOIN LATERAL). source receives the left-hand row, so the query it builds may reference its columns; there is no ON condition. The element type yielded by the applied query.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(Expression<Func<TEntity, EntityBuilder<TJoinEntity>>> source, Action<JoinOptions>? options = null)

Parameters

source Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>

options Action<JoinOptions>

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

Type Parameters

TJoinEntity

CrossApply<TJoinEntity>(Expression<Func<TEntity, QueryCommand<TJoinEntity>>>, Action<JoinOptions>?)

Applies a correlated derived query to every left-hand row (CROSS APPLY / CROSS JOIN LATERAL). source receives the left-hand row, so the query it builds may reference its columns; there is no ON condition. The element type yielded by the applied query.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossApply<TJoinEntity>(Expression<Func<TEntity, QueryCommand<TJoinEntity>>> source, Action<JoinOptions>? options = null)

Parameters

source Expression<Func<TEntity, QueryCommand<TJoinEntity>>>

options Action<JoinOptions>

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

Type Parameters

TJoinEntity

CrossJoin(string, Action<JoinOptions>?)

Adds a CROSS JOIN over the table named table without an explicit source.

public JoinedEntityBuilder<TEntity, TableAlias> CrossJoin(string table, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null, empty, or whitespace-only table is rejected at the call site with ArgumentNullException / ArgumentException (ParamName == "table"), matching the explicit ctx.From(table) form.

CrossJoin<TJoinEntity>(Cte<TJoinEntity>)

Adds a cross join over the typed CTE cte.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossJoin<TJoinEntity>(Cte<TJoinEntity> cte)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte is null.

CrossJoin<TJoinEntity>(Cte<TJoinEntity>, Action<JoinOptions>?)

Adds a cross join over the typed CTE cte with per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossJoin<TJoinEntity>(Cte<TJoinEntity> cte, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte is null.

CrossJoin<TJoinEntity>(EntityBuilder<TJoinEntity>, Action<JoinOptions>?)

Adds a cross join producing the Cartesian product of the two sources; there is no ON condition.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossJoin<TJoinEntity>(EntityBuilder<TJoinEntity> _, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the joined entity; only its source is used.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.WithJoinHint("loop"). A cross join rejects every modifier at render time.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

CrossJoin<TJoinEntity>(QueryCommand<TJoinEntity>, Action<JoinOptions>?)

Adds a cross join to the derived query, producing the Cartesian product of the two sources; there is no ON condition.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossJoin<TJoinEntity>(QueryCommand<TJoinEntity> query, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

The derived query to join.

options Action<JoinOptions>

Optional per-join configuration; a cross join rejects every modifier at render time.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

CrossJoin<TJoinEntity>(Action<JoinOptions>?)

Adds a CROSS JOIN over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> CrossJoin<TJoinEntity>(Action<JoinOptions>? options = null)

Parameters

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

Desc(Expression<Func<TEntity, object?>>)

Descending ORDER BY key of a named window declared with Window(string, Expression<Func<TEntity, object?>>[]?, NamedWindowOrderKey[]?, WindowFrame?).

public NamedWindowOrderKey Desc(Expression<Func<TEntity, object?>> expression)

Parameters

expression Expression<Func<TEntity, object>>

Returns

NamedWindowOrderKey

Distinct()

Adds SELECT DISTINCT, removing duplicate result rows. Cannot be combined with DistinctOn.

public EntityBuilder<TEntity> Distinct()

Returns

EntityBuilder<TEntity>

A builder with the DISTINCT modifier.

ForShare()

Locks the selected rows in shared mode until the transaction ends, blocking while a locked row is held by another transaction. Renders a trailing FOR SHARE clause on dialects that support it, or a table hint on the primary source (with (holdlock) on SQL Server). Requires a dialect that supports row locking (see Lock).

public EntityBuilder<TEntity> ForShare()

Returns

EntityBuilder<TEntity>

ForShare(LockWaitMode)

Locks the selected rows in shared mode until the transaction ends, with the requested wait behaviour for rows already locked by another transaction. Renders a trailing FOR SHARE [NOWAIT | SKIP LOCKED] clause on dialects that support it, or the matching table hint on the primary source (with (holdlock, nowait)/with (holdlock, readpast) on SQL Server). Requires a dialect that supports row locking (see Lock).

public EntityBuilder<TEntity> ForShare(LockWaitMode wait)

Parameters

wait LockWaitMode

How to react to a row already locked by another transaction.

Returns

EntityBuilder<TEntity>

ForSystemTime(TemporalClause)

Adds a FOR SYSTEM_TIME clause to the primary table, querying a system-versioned (temporal) table as of a point in time or over a range. Requires a dialect that supports it (see SupportsTemporalTable).

public EntityBuilder<TEntity> ForSystemTime(TemporalClause clause)

Parameters

clause TemporalClause

The temporal clause, built with the NextORM.Core.EntityBuilder<TEntity>.TemporalClause factory methods.

Returns

EntityBuilder<TEntity>

ForUpdate()

Locks the selected rows exclusively until the transaction ends, blocking while a locked row is held by another transaction. Renders a trailing FOR UPDATE clause on dialects that support it, or a table hint on the primary source (with (updlock) on SQL Server). Requires a dialect that supports row locking (see Lock).

public EntityBuilder<TEntity> ForUpdate()

Returns

EntityBuilder<TEntity>

ForUpdate(LockWaitMode)

Locks the selected rows exclusively until the transaction ends, with the requested wait behaviour for rows already locked by another transaction. Renders a trailing FOR UPDATE [NOWAIT | SKIP LOCKED] clause on dialects that support it, or the matching table hint on the primary source (with (updlock, nowait)/with (updlock, readpast) on SQL Server). Requires a dialect that supports row locking (see Lock).

public EntityBuilder<TEntity> ForUpdate(LockWaitMode wait)

Parameters

wait LockWaitMode

How to react to a row already locked by another transaction.

Returns

EntityBuilder<TEntity>

FullJoin(string, Expression<Func<TEntity, TableAlias, bool>>, Action<JoinOptions>?)

Adds a FULL JOIN over the table named table without an explicit source.

public JoinedEntityBuilder<TEntity, TableAlias> FullJoin(string table, Expression<Func<TEntity, TableAlias, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

joinCondition Expression<Func<TEntity, TableAlias, bool>>

A predicate relating the current entity to the joined TableAlias row.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null joinCondition is accepted and renders no ON clause, matching the explicit form over ctx.From(table).

FullJoin<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>)

Adds a full outer join over the typed CTE cte.

public JoinedEntityBuilder<TEntity, TJoinEntity> FullJoin<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

FullJoin<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a full outer join over the typed CTE cte with per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> FullJoin<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

FullJoin<TJoinEntity>(EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a full outer join: unmatched rows from both sides are kept, with the other side's columns set to NULL.

public JoinedEntityBuilder<TEntity, TJoinEntity> FullJoin<TJoinEntity>(EntityBuilder<TJoinEntity> _, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the joined entity; only its source is used.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

FullJoin<TJoinEntity>(QueryCommand<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a full outer join to the derived query: unmatched rows from both sides are kept, with the other side's columns set to NULL.

public JoinedEntityBuilder<TEntity, TJoinEntity> FullJoin<TJoinEntity>(QueryCommand<TJoinEntity> query, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

The derived query to join.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

FullJoin<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a FULL JOIN over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> FullJoin<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

Exceptions

ArgumentNullException

joinCondition is null.

GroupByCube<TResult>(Expression<Func<TEntity, TResult>>)

Groups by CUBE (columns): the grouped rows plus every combination subtotal. Requires a dialect that supports it (see SupportsCube).

public EntityBuilder<TEntity> GroupByCube<TResult>(Expression<Func<TEntity, TResult>> exp)

Parameters

exp Expression<Func<TEntity, TResult>>

Returns

EntityBuilder<TEntity>

Type Parameters

TResult

GroupByGroupingSets<TResult>(Expression<Func<TEntity, TResult>>, params int[][])

Groups by an explicit list of grouping sets, e.g. GROUP BY GROUPING SETS ((a, b), (a), ()). exp declares the full grouping list (an anonymous type / DTO) and each entry of sets is a set of 0-based indices into that list; an empty set produces the grand total. Requires a dialect that supports it (see SupportsGroupingSets).

public EntityBuilder<TEntity> GroupByGroupingSets<TResult>(Expression<Func<TEntity, TResult>> exp, params int[][] sets)

Parameters

exp Expression<Func<TEntity, TResult>>

sets int[][]

Returns

EntityBuilder<TEntity>

Type Parameters

TResult

GroupByRollup<TResult>(Expression<Func<TEntity, TResult>>)

Groups by ROLLUP (columns): the grouped rows plus every prefix subtotal and the grand total. Requires a dialect that supports it (see SupportsRollup).

public EntityBuilder<TEntity> GroupByRollup<TResult>(Expression<Func<TEntity, TResult>> exp)

Parameters

exp Expression<Func<TEntity, TResult>>

Returns

EntityBuilder<TEntity>

Type Parameters

TResult

GroupBy<TResult>(Expression<Func<TEntity, TResult>>)

Groups rows by exp, a single column or an anonymous type/DTO keying on several columns.

public EntityBuilder<TEntity> GroupBy<TResult>(Expression<Func<TEntity, TResult>> exp)

Parameters

exp Expression<Func<TEntity, TResult>>

The grouping key selector.

Returns

EntityBuilder<TEntity>

A builder with the grouping applied.

Type Parameters

TResult

The grouping key type.

GroupJoin<TInner, TKey, TResult>(EntityBuilder<TInner>, Expression<Func<TEntity, TKey>>, Expression<Func<TInner, TKey>>, Expression<Func<TEntity, IEnumerable<TInner>, TResult>>)

Correlates the rows of this query with inner by key and projects each pair with the grouped inner rows (source.GroupJoin(...)). Rows without a match receive an empty group.

Supported by the InMemoryDataContext only; SQL providers throw NotSupportedException.

public EntityBuilder<TResult> GroupJoin<TInner, TKey, TResult>(EntityBuilder<TInner> inner, Expression<Func<TEntity, TKey>> outerKeySelector, Expression<Func<TInner, TKey>> innerKeySelector, Expression<Func<TEntity, IEnumerable<TInner>, TResult>> resultSelector)

Parameters

inner EntityBuilder<TInner>

outerKeySelector Expression<Func<TEntity, TKey>>

innerKeySelector Expression<Func<TInner, TKey>>

resultSelector Expression<Func<TEntity, IEnumerable<TInner>, TResult>>

Returns

EntityBuilder<TResult>

Type Parameters

TInner

TKey

TResult

Having(Expression<Func<TEntity, bool>>)

Adds condition to the HAVING clause, which filters grouped rows. A repeated call combines the predicates with and.

public EntityBuilder<TEntity> Having(Expression<Func<TEntity, bool>> condition)

Parameters

condition Expression<Func<TEntity, bool>>

The predicate each group must satisfy.

Returns

EntityBuilder<TEntity>

A builder with the added predicate.

IgnoreFilters()

Disables all global query filters declared for the query's entity type (and for every entity joined by it), so the query reads the unfiltered rows. The current builder is unchanged; the returned builder is a copy with the all-or-nothing scope set. To disable only some filters, use one of the selective overloads.

public EntityBuilder<TEntity> IgnoreFilters()

Returns

EntityBuilder<TEntity>

A builder that ignores every global query filter.

IgnoreFilters(IEnumerable<string>)

Disables the named global query filters identified by filterKeys on every entity type in the query. A subsequent call accumulates: the returned builder carries the union of both scopes. An empty or null filterKeys disables nothing (mirroring EF Core). The current builder is unchanged.

public EntityBuilder<TEntity> IgnoreFilters(IEnumerable<string> filterKeys)

Parameters

filterKeys IEnumerable<string>

The filter keys to disable.

Returns

EntityBuilder<TEntity>

A builder that ignores the named filters.

IgnoreFilters(IEnumerable<string>, params Type[])

Disables the named global query filters identified by filterKeys only on the given entityTypes (the intersection of keys and types); an empty entityTypes means any entity type. A subsequent call accumulates with the union. The key list is the gate: an empty or null filterKeys disables nothing even when entity types are supplied. The current builder is unchanged.

public EntityBuilder<TEntity> IgnoreFilters(IEnumerable<string> filterKeys, params Type[] entityTypes)

Parameters

filterKeys IEnumerable<string>

The filter keys to disable.

entityTypes Type[]

The entity types the disable is scoped to; empty means any entity type.

Returns

EntityBuilder<TEntity>

A builder that ignores the given named filters on the given entity types.

IgnoreFilters(params Type[])

Disables every global query filter declared for the given entity types, leaving the filters of other entity types in the query active. A subsequent call accumulates: the returned builder carries the union of both scopes. An empty or null entityTypes disables nothing. The current builder is unchanged.

public EntityBuilder<TEntity> IgnoreFilters(params Type[] entityTypes)

Parameters

entityTypes Type[]

The entity types whose filters are disabled.

Returns

EntityBuilder<TEntity>

A builder that ignores the filters of the given entity types.

Join(string, Expression<Func<TEntity, TableAlias, bool>>, Action<JoinOptions>?)

Adds an INNER JOIN over the table named table without an explicit source; the right-hand source resolves to table and is read through TableAlias.

public JoinedEntityBuilder<TEntity, TableAlias> Join(string table, Expression<Func<TEntity, TableAlias, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

joinCondition Expression<Func<TEntity, TableAlias, bool>>

A predicate relating the current entity to the joined TableAlias row.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null joinCondition is accepted and renders no ON clause, matching the explicit form over ctx.From(table).

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, Cte<TJoinEntity>, JoinType, Action<JoinOptions>?)

Alias-join seam over a typed CTE for the conditionless operators; see the conditional counterpart.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, Cte<TJoinEntity> cte, JoinType joinType, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinType JoinType

The conditionless join kind to add.

options Action<JoinOptions>

Optional per-join configuration.

Returns

TNext

A new TNext carrying this builder's joins plus the new one.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

create or cte is null.

NotSupportedException

The in-memory provider cannot project named aliases.

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, JoinType, Action<JoinOptions>?)

Alias-join seam over a typed CTE for the conditional operators. The descriptor is converted with this builder's context and forwarded to JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, JoinType, Action<JoinOptions>?), so the CTE declaration set and the join source match the converted form.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, JoinType joinType = JoinType.Inner, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

joinType JoinType

The kind of join to add.

options Action<JoinOptions>

Optional per-join configuration.

Returns

TNext

A new TNext carrying this builder's joins plus the new one.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

create, cte or joinCondition is null.

NotSupportedException

The in-memory provider cannot project named aliases.

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, EntityBuilder<TJoinEntity>, JoinType, Action<JoinOptions>?)

Alias-join seam for the conditionless operators (CrossJoin/CrossApply/ OuterApply): mirrors the positional conditionless overloads, so the resulting JoinExpression carries no ON predicate and an explicit EntityType.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, EntityBuilder<TJoinEntity> _, JoinType joinType, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

_ EntityBuilder<TJoinEntity>

The builder identifying the table to join; only its table metadata is used.

joinType JoinType

The conditionless join kind to add.

options Action<JoinOptions>

Optional per-join configuration.

Returns

TNext

A new TNext carrying this builder's joins plus the new one.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The entity type being joined.

Exceptions

NotSupportedException

The in-memory provider cannot project named aliases.

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, JoinType, Action<JoinOptions>?)

Seam for generated alias-join builders (issue #113): adds _ as a join and returns the caller-created builder of a different projection shape, carrying this builder's join chain. The generated extension method supplies the target type through create so the projection can expose lexical alias properties (for example p.Buyer) whose JoinSlotAttribute maps them to the right joined table. This overload serves the conditional operators (Join/LeftJoin/RightJoin/FullJoin) and delegates to the same construction path as their positional counterparts, parameterized by joinType; the in-memory provider refuses it explicitly at construction.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, EntityBuilder<TJoinEntity> _, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, JoinType joinType = JoinType.Inner, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

_ EntityBuilder<TJoinEntity>

The builder identifying the table to join; only its table metadata is used.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

joinType JoinType

The kind of join to add.

options Action<JoinOptions>

Optional per-join configuration.

Returns

TNext

A new TNext carrying this builder's joins plus the new one.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The entity type being joined.

Exceptions

NotSupportedException

The in-memory provider cannot project named aliases.

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>, JoinType, Action<JoinOptions>?)

Correlated alias CROSS APPLY/OUTER APPLY: mirrors the positional CrossApply<TJoinEntity>(Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>, Action<JoinOptions>?) overload and carries the source through NextORM.Core.JoinExpression.ApplySource instead of a plain ON condition.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, Expression<Func<TEntity, EntityBuilder<TJoinEntity>>> source, JoinType joinType, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

source Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>

A lambda receiving the left-hand row and returning the applied builder.

joinType JoinType

The APPLY kind to add.

options Action<JoinOptions>

Optional per-join configuration.

Returns

TNext

A new TNext carrying this builder's joins plus the applied source.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The entity type yielded by the applied source.

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, Expression<Func<TEntity, QueryCommand<TJoinEntity>>>, JoinType, Action<JoinOptions>?)

Correlated alias CROSS APPLY/OUTER APPLY over a derived query; mirrors the positional CrossApply<TJoinEntity>(Expression<Func<TEntity, QueryCommand<TJoinEntity>>>, Action<JoinOptions>?) overload.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, Expression<Func<TEntity, QueryCommand<TJoinEntity>>> source, JoinType joinType, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

source Expression<Func<TEntity, QueryCommand<TJoinEntity>>>

A lambda receiving the left-hand row and returning the applied query.

joinType JoinType

The APPLY kind to add.

options Action<JoinOptions>

Optional per-join configuration.

Returns

TNext

A new TNext carrying this builder's joins plus the applied query.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The entity type yielded by the applied query.

JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext>, Expression<Func<TEntity, TJoinEntity, bool>>, JoinType, Action<JoinOptions>?)

Source-less alias-join seam for generated alias-join builders (issue #322): the implicit FROM source for TJoinEntity is created from this builder's data context (From<TJoinEntity>()) and forwarded to the same assembly path as the source-explicit conditional overload, so a generated extension method can expose the Alias.X marker without also handing the caller an EntityBuilder<TJoinEntity>.

public TNext JoinAlias<TNext, TNextEntity, TJoinEntity>(Func<IDataContext, TNext> create, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, JoinType joinType = JoinType.Inner, Action<JoinOptions>? options = null) where TNext : EntityBuilder<TNextEntity>

Parameters

create Func<IDataContext, TNext>

Creates an empty TNext bound to this builder's data context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

joinType JoinType

The kind of join to add.

options Action<JoinOptions>

Optional per-join configuration; applied exactly once by the shared assembly path.

Returns

TNext

A new TNext carrying this builder's joins plus the new one.

Type Parameters

TNext

The generated builder type that receives the join chain.

TNextEntity

The projection type TNext is built over.

TJoinEntity

The entity type being joined.

Exceptions

ArgumentNullException

create or joinCondition is null.

NotSupportedException

The in-memory provider cannot project named aliases.

JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, JoinType, Action<JoinOptions>?)

Declares a typed join to child (see JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Action<JoinOptions>?)) that fills the collection member. Only Inner and Left are accepted; any other kind throws NotSupportedException. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild>(EntityBuilder<TChild> child, Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, ICollection<TChild>>> collection, JoinType joinType, Action<JoinOptions>? options = null)

Parameters

child EntityBuilder<TChild>

The child source.

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member the joined children fill.

joinType JoinType

The join kind; Inner or Left.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Remarks

A Where declared on the child source is folded into the join's ON condition together with predicate, so a matched parent keeps only the filtered children while a LEFT join still keeps a parent whose children are all filtered out. Only the child's own Where is supported: any other child-query modifier (ordering, paging, Distinct, grouping, joins, a table modifier or a nested eager load) throws NotSupportedException at the declaration, before the query is prepared or executed. A derived (As) child source is supported when its only modifier is its own Where; any other modifier on or inside it is rejected the same way.

Exceptions

NotSupportedException

The join kind or relationship is not supported.

JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Action<JoinOptions>?)

Declares a LEFT JOIN to child that fills the collection member of every parent when the query is enumerated by a list terminal. The returned builder is a copy; the current builder is unchanged.

The join is part of the query: ToCommand() emits ... from Parent as t1 left join Child as t2 on <predicate> while still materializing TEntity rows, so a bare ToCommand() may repeat a parent once per matching child. The parent/child keys are resolved from the declared relationship metadata (or from a local JoinOptions configuration, which fully replaces the metadata for this call); a composite principal/foreign key is supported componentwise. A relationship that is not declared, a many-to-many without a junction, or a composite-junction many-to-many (carried by issue #223) is rejected with NotSupportedException — use the explicit-key overload instead. The list terminals execute one denormalized command and stitch the children onto the deduplicated parents; the non-list terminals exclude this join and evaluate the parent only.

public EntityBuilder<TEntity> JoinInto<TChild>(EntityBuilder<TChild> child, Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, ICollection<TChild>>> collection, Action<JoinOptions>? options = null)

Parameters

child EntityBuilder<TChild>

The child source.

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member the joined children fill.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Exceptions

NotSupportedException

The join kind or relationship is not supported.

JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, JoinType, Action<JoinOptions>?)

Declares a typed join to child (see JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, Action<JoinOptions>?)) that assigns the single joined child to the one-to-one navigation reference. Only Inner and Left are accepted; any other kind throws NotSupportedException. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild>(EntityBuilder<TChild> child, Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, TChild?>> navigation, JoinType joinType, Action<JoinOptions>? options = null) where TChild : class

Parameters

child EntityBuilder<TChild>

The child source.

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

navigation Expression<Func<TEntity, TChild>>

The parent-side reference navigation the joined child fills.

joinType JoinType

The join kind; Inner or Left.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Remarks

A Where declared on the child source is folded into the join's ON condition together with predicate, so a matched parent keeps only the filtered child while a LEFT join still keeps a parent whose child is filtered out (the reference stays null). Only the child's own Where is supported: any other child-query modifier throws NotSupportedException at the declaration, before the query is prepared or executed. A derived (As) child source is supported when its only modifier is its own Where; any other modifier on or inside it is rejected the same way.

Exceptions

NotSupportedException

The join kind, relationship kind or keys are not supported.

JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, Action<JoinOptions>?)

Declares a LEFT JOIN to child that assigns the single joined child to the one-to-one navigation reference of every parent when the query is enumerated by a list terminal. The returned builder is a copy; the current builder is unchanged.

The relationship must be declared as one-to-one (HasOneToOne) so the principal/foreign keys are known. The foreign-key uniqueness is a declaration-time trust: the core neither inspects the schema or the data nor imposes a uniqueness constraint. At most one child is assigned per parent; a LEFT join leaves the reference null when no child matches, while an INNER join excludes the parent. A parent that matches more than one distinct non-null child identity throws InvalidOperationException at materialization. Repeated rows of the same child identity are tolerated (the first child wins), including cartesian repeats caused by a neighbouring join and keyless/null-identity children, for which the core cannot distinguish a repeat from a genuinely different child.

public EntityBuilder<TEntity> JoinInto<TChild>(EntityBuilder<TChild> child, Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, TChild?>> navigation, Action<JoinOptions>? options = null) where TChild : class

Parameters

child EntityBuilder<TChild>

The child source.

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

navigation Expression<Func<TEntity, TChild>>

The parent-side reference navigation the joined child fills.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Exceptions

NotSupportedException

The join kind, relationship kind or keys are not supported.

JoinInto<TChild>(Expression<Func<TEntity, ICollection<TChild>>>, Expression<Func<TEntity, TChild, bool>>?, Action<JoinOptions>?)

Declares a LEFT JOIN to the mapping of TChild that fills the collection member of every parent, taking both join keys from the relationship the navigation declares. The navigation selects the relationship, so the caller does not restate its keys: the ON condition is the ordered principal/foreign component equality of the declared relationship, conjoined componentwise (a composite key contributes one equality per component, in declaration order).

filter is an additional restriction appended to that ON condition as one more conjunct; it never replaces the declared-key equality and is never moved into a parent-filtering WHERE, so a parent whose children are all filtered out is still returned with an empty collection. null means no additional restriction. For a many-to-many navigation the existing junction synthesis supplies both key edges, and the filter is appended to the link-to-child edge exactly where the explicit forms append their predicate.

The child source is the mapping of TChild resolved from the data context - the same resolution the source-less overloads use, so a configured mapping keeps precedence. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild>(Expression<Func<TEntity, ICollection<TChild>>> collection, Expression<Func<TEntity, TChild, bool>>? filter = null, Action<JoinOptions>? options = null)

Parameters

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection navigation the joined children fill.

filter Expression<Func<TEntity, TChild, bool>>

An additional predicate over the parent and child, conjoined into the join's ON; null for no additional restriction.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type, inferred from the collection navigation.

Exceptions

ArgumentNullException

collection is null.

NotSupportedException

The navigation does not resolve to a declared relationship, the cardinality or the keys are unsupported, or the key type has no value equality.

JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, JoinType, Action<JoinOptions>?)

Declares a typed join to the mapping of TChild (see JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Action<JoinOptions>?)) that fills the collection member and uses the given joinType. Only Inner and Left are accepted; any other kind throws NotSupportedException. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, ICollection<TChild>>> collection, JoinType joinType, Action<JoinOptions>? options = null)

Parameters

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member the joined children fill.

joinType JoinType

The join kind; Inner or Left.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Exceptions

NotSupportedException

The join kind or relationship is not supported.

JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Action<JoinOptions>?)

Declares a LEFT JOIN to the mapping of TChild that fills the collection member of every parent when the query is enumerated by a list terminal. The child source is the mapping of TChild, so no child builder is supplied. The returned builder is a copy; the current builder is unchanged.

Equivalent to JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Action<JoinOptions>?) with the child source resolved from the data context; the parent/child keys are resolved from the declared relationship metadata (or from a local JoinOptions configuration) and a relationship that cannot be resolved is rejected with NotSupportedException.

public EntityBuilder<TEntity> JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, ICollection<TChild>>> collection, Action<JoinOptions>? options = null)

Parameters

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member the joined children fill.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Exceptions

NotSupportedException

The join kind or relationship is not supported.

JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, JoinType, Action<JoinOptions>?)

Declares a typed join to the mapping of TChild (see JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, Action<JoinOptions>?)) that assigns the single joined child to the one-to-one navigation reference and uses the given joinType. Only Inner and Left are accepted; any other kind throws NotSupportedException. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, TChild?>> navigation, JoinType joinType, Action<JoinOptions>? options = null) where TChild : class

Parameters

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

navigation Expression<Func<TEntity, TChild>>

The parent-side reference navigation the joined child fills.

joinType JoinType

The join kind; Inner or Left.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Exceptions

NotSupportedException

The join kind, relationship kind or keys are not supported.

JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, Action<JoinOptions>?)

Declares a LEFT JOIN to the mapping of TChild that assigns the single joined child to the one-to-one navigation reference of every parent when the query is enumerated by a list terminal. The child source is the mapping of TChild, so no child builder is supplied. The returned builder is a copy; the current builder is unchanged.

Equivalent to JoinInto<TChild>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, TChild?>>, Action<JoinOptions>?) with the child source resolved from the data context. The relationship must be declared as one-to-one so the principal/foreign keys are known; an unresolvable relationship is rejected with NotSupportedException.

public EntityBuilder<TEntity> JoinInto<TChild>(Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, TChild?>> navigation, Action<JoinOptions>? options = null) where TChild : class

Parameters

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

navigation Expression<Func<TEntity, TChild>>

The parent-side reference navigation the joined child fills.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

Exceptions

NotSupportedException

The join kind, relationship kind or keys are not supported.

JoinInto<TChild>(Expression<Func<TEntity, TChild?>>, Expression<Func<TEntity, TChild, bool>>?, Action<JoinOptions>?)

Declares a LEFT JOIN to the mapping of TChild that assigns the single joined child to the one-to-one navigation reference of every parent, taking both join keys from the relationship the navigation declares. The navigation selects the relationship, so the caller does not restate its keys: the ON condition is the ordered principal/foreign component equality of the declared relationship, conjoined componentwise.

filter is an additional restriction appended to that ON condition as one more conjunct; it never replaces the declared-key equality and is never moved into a parent-filtering WHERE, so a parent whose only candidate child is filtered out keeps a null reference instead of disappearing. null means no additional restriction. At most one child is assigned per parent, as for the explicit forms.

The child source is the mapping of TChild resolved from the data context - the same resolution the source-less overloads use, so a configured mapping keeps precedence. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild>(Expression<Func<TEntity, TChild?>> navigation, Expression<Func<TEntity, TChild, bool>>? filter = null, Action<JoinOptions>? options = null) where TChild : class

Parameters

navigation Expression<Func<TEntity, TChild>>

The parent-side reference navigation the joined child fills.

filter Expression<Func<TEntity, TChild, bool>>

An additional predicate over the parent and child, conjoined into the join's ON; null for no additional restriction.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type, inferred from the reference navigation.

Exceptions

ArgumentNullException

navigation is null.

NotSupportedException

The navigation does not resolve to a declared one-to-one relationship, the navigation has no setter, or the key type has no value equality.

JoinInto<TChild, TKey>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Expression<Func<TEntity, TKey>>, Expression<Func<TChild, TKey>>, Action<JoinOptions>?)

Declares a LEFT JOIN to child that fills the collection member, using the explicit parentKey/childKey selectors instead of declared relationship metadata (symmetrical to the LoadWith fallback). The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild, TKey>(EntityBuilder<TChild> child, Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, ICollection<TChild>>> collection, Expression<Func<TEntity, TKey>> parentKey, Expression<Func<TChild, TKey>> childKey, Action<JoinOptions>? options = null) where TKey : notnull

Parameters

child EntityBuilder<TChild>

The child source.

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member the joined children fill.

parentKey Expression<Func<TEntity, TKey>>

Selects the parent key used to group the rows.

childKey Expression<Func<TChild, TKey>>

Selects the child key used to group the rows.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

TKey

The non-nullable key type shared by the two selectors.

Remarks

A Where declared on the child source is folded into the join's ON condition together with predicate, so a matched parent keeps only the filtered children while the LEFT join still keeps a parent whose children are all filtered out. Only the child's own Where is supported: any other child-query modifier throws NotSupportedException at the declaration, before the query is prepared or executed. A derived (As) child source is supported when its only modifier is its own Where; any other modifier on or inside it is rejected the same way.

Exceptions

NotSupportedException

The key selectors select different types.

JoinInto<TChild, TKey>(Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Expression<Func<TEntity, TKey>>, Expression<Func<TChild, TKey>>, Action<JoinOptions>?)

Declares a LEFT JOIN to the mapping of TChild that fills the collection member, using the explicit parentKey/childKey selectors instead of declared relationship metadata. The child source is the mapping of TChild, so no child builder is supplied; the call is equivalent to JoinInto<TChild, TKey>(EntityBuilder<TChild>, Expression<Func<TEntity, TChild, bool>>, Expression<Func<TEntity, ICollection<TChild>>>, Expression<Func<TEntity, TKey>>, Expression<Func<TChild, TKey>>, Action<JoinOptions>?) with the child source resolved from the data context. The returned builder is a copy; the current builder is unchanged.

public EntityBuilder<TEntity> JoinInto<TChild, TKey>(Expression<Func<TEntity, TChild, bool>> predicate, Expression<Func<TEntity, ICollection<TChild>>> collection, Expression<Func<TEntity, TKey>> parentKey, Expression<Func<TChild, TKey>> childKey, Action<JoinOptions>? options = null) where TKey : notnull

Parameters

predicate Expression<Func<TEntity, TChild, bool>>

The join predicate over the parent and child.

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member the joined children fill.

parentKey Expression<Func<TEntity, TKey>>

Selects the parent key used to group the rows.

childKey Expression<Func<TChild, TKey>>

Selects the child key used to group the rows.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the join declaration.

Type Parameters

TChild

The child entity type.

TKey

The non-nullable key type shared by the two selectors.

Exceptions

NotSupportedException

The key selectors select different types.

Join<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>)

Adds an inner join over the typed CTE cte; identical to Join<TJoinEntity>(EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?) with this builder's context.

public JoinedEntityBuilder<TEntity, TJoinEntity> Join<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

Join<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds an inner join over the typed CTE cte with per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> Join<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

Join<TJoinEntity>(EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds an inner join to _, using joinCondition as the ON predicate; only matching pairs survive.

public JoinedEntityBuilder<TEntity, TJoinEntity> Join<TJoinEntity>(EntityBuilder<TJoinEntity> _, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the joined entity; only its source is used.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

Join<TJoinEntity>(QueryCommand<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds an inner join to the derived query, using joinCondition as the ON predicate; only matching pairs survive.

public JoinedEntityBuilder<TEntity, TJoinEntity> Join<TJoinEntity>(QueryCommand<TJoinEntity> query, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

The derived query to join.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

Join<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds an INNER JOIN over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> Join<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

Exceptions

ArgumentNullException

joinCondition is null.

LeftJoin(string, Expression<Func<TEntity, TableAlias, bool>>, Action<JoinOptions>?)

Adds a LEFT JOIN over the table named table without an explicit source.

public JoinedEntityBuilder<TEntity, TableAlias> LeftJoin(string table, Expression<Func<TEntity, TableAlias, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

joinCondition Expression<Func<TEntity, TableAlias, bool>>

A predicate relating the current entity to the joined TableAlias row.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null joinCondition is accepted and renders no ON clause, matching the explicit form over ctx.From(table).

LeftJoin<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>)

Adds a left outer join over the typed CTE cte.

public JoinedEntityBuilder<TEntity, TJoinEntity> LeftJoin<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

LeftJoin<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a left outer join over the typed CTE cte with per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> LeftJoin<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

LeftJoin<TJoinEntity>(EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a left outer join: every left-hand row is kept, and right-hand columns are NULL when there is no match.

public JoinedEntityBuilder<TEntity, TJoinEntity> LeftJoin<TJoinEntity>(EntityBuilder<TJoinEntity> _, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the joined entity; only its source is used.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

LeftJoin<TJoinEntity>(QueryCommand<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a left outer join to the derived query: every left-hand row is kept, and right-hand columns are NULL when there is no match.

public JoinedEntityBuilder<TEntity, TJoinEntity> LeftJoin<TJoinEntity>(QueryCommand<TJoinEntity> query, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

The derived query to join.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

LeftJoin<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a LEFT JOIN over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> LeftJoin<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

Exceptions

ArgumentNullException

joinCondition is null.

Limit(int)

Sets the maximum number of rows to return; zero means no limit.

public EntityBuilder<TEntity> Limit(int limit)

Parameters

limit int

The page size; must be non-negative.

Returns

EntityBuilder<TEntity>

A builder with the new limit.

LoadWith<TChild>(Expression<Func<TEntity, ICollection<TChild>>>, EagerLoadMode)

Declares the eager loading of a declared collection navigation without explicit key selectors: the relationship is read from the mapping metadata — HasMany or HasManyThrough (fluent) or [Relationship] — and its ordered key components are paired positionally, parent component at position i with child component at position i.

The relationship is resolved and structurally validated when this method is called, so an undeclared navigation, a reference cardinality and malformed metadata are rejected before any SQL is generated and before any plan-cache entry exists. nextorm never infers a relationship from a naming convention, never matches key columns by name and never falls back to the first component of a composite key. A collection navigation can only be loaded through this collection route; the reference route rejects a collection relationship.

The child query is the context's ordinary From<TChild>() source, so the related type's mapping and global filters apply; use the childQuery overload to add the child's own filters, ordering or per-parent paging. Modes, chunking, the assignment rule, ordering and the stitching terminals are the same as for the explicit-key overload. The declared-metadata form is SQL-only: the in-memory provider rejects it while the parent command is constructed, before any SQL and before any plan-cache entry.

public EntityBuilder<TEntity> LoadWith<TChild>(Expression<Func<TEntity, ICollection<TChild>>> collection, EagerLoadMode mode = EagerLoadMode.Default)

Parameters

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection navigation to fill.

mode EagerLoadMode

The whole-builder eager-load mode; Default inherits the current choice.

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the eager-load declaration.

Type Parameters

TChild

The related entity type.

Exceptions

ArgumentOutOfRangeException

mode is not a defined value.

InvalidOperationException

The navigation already carries an eager-load declaration on this builder.

NotSupportedException

The selector is not a collection navigation, no relationship is declared for it, the declared relationship is not a collection relationship of TChild, its key lists are structurally invalid, a different explicit mode is already active, or the context is the in-memory provider.

LoadWith<TChild>(Expression<Func<TEntity, ICollection<TChild>>>, Func<IDataContext, EntityBuilder<TChild>>, EagerLoadMode)

Declares the eager loading of a declared collection navigation through a child query, without explicit key selectors: the relationship is read from the mapping metadata — HasMany or HasManyThrough (fluent) or [Relationship] — and its ordered key components are paired positionally.

The relationship is resolved and structurally validated when this method is called, so an undeclared navigation, a reference cardinality and malformed metadata are rejected before any SQL is generated and before any plan-cache entry exists. nextorm never infers a relationship from a naming convention, never matches key columns by name and never falls back to the first component of a composite key. A collection navigation can only be loaded through this collection route; the reference route rejects a collection relationship.

childQuery supplies the child source, so it can add the child's own filters, ordering or per-parent paging; split loading honors every child-query shape. Modes, chunking, the assignment rule, ordering and the stitching terminals are the same as for the explicit-key overload. The declared-metadata form is SQL-only: the in-memory provider rejects it while the parent command is constructed, before any SQL and before any plan-cache entry.

public EntityBuilder<TEntity> LoadWith<TChild>(Expression<Func<TEntity, ICollection<TChild>>> collection, Func<IDataContext, EntityBuilder<TChild>> childQuery, EagerLoadMode mode = EagerLoadMode.Default)

Parameters

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection navigation to fill.

childQuery Func<IDataContext, EntityBuilder<TChild>>

Builds the child query from the data context that owns the parent query.

mode EagerLoadMode

The whole-builder eager-load mode; Default inherits the current choice.

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the eager-load declaration.

Type Parameters

TChild

The related entity type.

Exceptions

ArgumentOutOfRangeException

mode is not a defined value.

InvalidOperationException

The navigation already carries an eager-load declaration on this builder.

NotSupportedException

The selector is not a collection navigation, no relationship is declared for it, the declared relationship is not a collection relationship of TChild, its key lists are structurally invalid, a different explicit mode is already active, or the context is the in-memory provider.

LoadWith<TChild>(Expression<Func<TEntity, TChild?>>, EagerLoadMode)

Declares the eager loading of a declared reference navigation without explicit key selectors: the relationship is read from the mapping metadata — HasOne/HasOneToOne (fluent) or [Relationship] — and its ordered key components are paired positionally, parent component at position i with child component at position i.

The relationship is resolved and structurally validated when this method is called, so an undeclared navigation, a collection cardinality and malformed metadata are rejected before any SQL is generated and before any plan-cache entry exists. nextorm never infers a relationship from a naming convention, never matches key columns by name and never falls back to the first component of a composite key. A collection navigation can only be loaded through the collection route; this reference route rejects a collection relationship, including a many-to-many one.

One related row is assigned per parent: no matching row assigns null, and more than one distinct full identity for the same parent throws InvalidOperationException before any parent is mutated. A read-only navigation can only be loaded when its current value already is the resolved row; otherwise it fails closed with NotSupportedException. The child query is the context's ordinary From<TChild>() source, so the related type's mapping and global filters apply; use the childQuery overload to add the child's own filters or ordering. Modes, chunking, ordering and the stitching terminals are the same as for the explicit-key overload, and a child page is rejected because a per-parent top-N applies to a collection. The declared-metadata form is SQL-only: the in-memory provider rejects it while the parent command is constructed, before any SQL and before any plan-cache entry.

public EntityBuilder<TEntity> LoadWith<TChild>(Expression<Func<TEntity, TChild?>> reference, EagerLoadMode mode = EagerLoadMode.Default) where TChild : class

Parameters

reference Expression<Func<TEntity, TChild>>

The parent-side reference navigation to fill.

mode EagerLoadMode

The whole-builder eager-load mode; Default inherits the current choice.

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the eager-load declaration.

Type Parameters

TChild

The related entity type.

Exceptions

ArgumentOutOfRangeException

mode is not a defined value.

InvalidOperationException

The navigation already carries an eager-load declaration on this builder, or more than one distinct related row matches a single parent.

NotSupportedException

The selector is not a reference navigation, no relationship is declared for it, the declared relationship is not a reference relationship of TChild, its key lists are structurally invalid, a different explicit mode is already active, the child query pages per parent, the navigation is read-only and would have to be written, or the context is the in-memory provider.

LoadWith<TChild>(Expression<Func<TEntity, TChild?>>, Func<IDataContext, EntityBuilder<TChild>>, EagerLoadMode)

Declares the eager loading of a declared reference navigation through a child query, without explicit key selectors: the relationship is read from the mapping metadata — HasOne/HasOneToOne (fluent) or [Relationship] — and its ordered key components are paired positionally.

The relationship is resolved and structurally validated when this method is called, so an undeclared navigation, a collection cardinality and malformed metadata are rejected before any SQL is generated and before any plan-cache entry exists. nextorm never infers a relationship from a naming convention, never matches key columns by name and never falls back to the first component of a composite key. A collection navigation can only be loaded through the collection route; this reference route rejects a collection relationship, including a many-to-many one.

One related row is assigned per parent: no matching row assigns null, and more than one distinct full identity for the same parent throws InvalidOperationException before any parent is mutated. A read-only navigation can only be loaded when its current value already is the resolved row; otherwise it fails closed with NotSupportedException. childQuery can add the child's own filters or ordering; a child page is rejected because a per-parent top-N applies to a collection. Modes, chunking, ordering and the stitching terminals are the same as for the explicit-key overload. The declared-metadata form is SQL-only: the in-memory provider rejects it while the parent command is constructed, before any SQL and before any plan-cache entry.

public EntityBuilder<TEntity> LoadWith<TChild>(Expression<Func<TEntity, TChild?>> reference, Func<IDataContext, EntityBuilder<TChild>> childQuery, EagerLoadMode mode = EagerLoadMode.Default) where TChild : class

Parameters

reference Expression<Func<TEntity, TChild>>

The parent-side reference navigation to fill.

childQuery Func<IDataContext, EntityBuilder<TChild>>

Builds the child query from the data context that owns the parent query.

mode EagerLoadMode

The whole-builder eager-load mode; Default inherits the current choice.

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the eager-load declaration.

Type Parameters

TChild

The related entity type.

Exceptions

ArgumentOutOfRangeException

mode is not a defined value.

InvalidOperationException

The navigation already carries an eager-load declaration on this builder, or more than one distinct related row matches a single parent.

NotSupportedException

The selector is not a reference navigation, no relationship is declared for it, the declared relationship is not a reference relationship of TChild, its key lists are structurally invalid, a different explicit mode is already active, the child query pages per parent, the navigation is read-only and would have to be written, or the context is the in-memory provider.

LoadWith<TChild, TKey>(Expression<Func<TEntity, ICollection<TChild>>>, Func<IDataContext, EntityBuilder<TChild>>, Expression<Func<TEntity, TKey>>, Expression<Func<TChild, TKey>>, EagerLoadMode)

Declares a split-query eager load for collection: after the parent query is materialized, one extra child query per key chunk is executed to fetch the children, and they are stitched onto the parents in memory (two round trips, never N+1). Only the stitching terminals (ToList/ToListAsync and ToArray/ToArrayAsync) honor the declaration; ToHashSet, ToDictionary, First, FirstOrDefault, Single*, ToEnumerable, ToAsyncEnumerable and ToCommand() run the parent only and do not load the collection, and Count/Any stay scalar without extra load queries.

The parent's current collection value is cleared and refilled when it is non-null; a null value is assigned a fresh list when the member is settable. A read-only member whose value is null is rejected with NotSupportedException. Every target is validated before the parents are mutated, so the rejection leaves no parent partially populated. The child order follows the child query's order.

A collection member may be declared only once: calling LoadWith twice for the same member throws InvalidOperationException. Declare distinct members on the same builder to load several collections.

mode selects the whole builder's loading strategy. Default inherits the mode already chosen by an earlier LoadWith (split when none was); an explicit SplitQuery or SingleQuery applies to every declared collection, including one declared earlier. Repeating the same explicit mode is allowed, but choosing a different explicit mode is rejected with NotSupportedException.

public EntityBuilder<TEntity> LoadWith<TChild, TKey>(Expression<Func<TEntity, ICollection<TChild>>> collection, Func<IDataContext, EntityBuilder<TChild>> childQuery, Expression<Func<TEntity, TKey>> parentKey, Expression<Func<TChild, TKey>> childKey, EagerLoadMode mode = EagerLoadMode.Default) where TKey : notnull

Parameters

collection Expression<Func<TEntity, ICollection<TChild>>>

The parent-side collection member to fill.

childQuery Func<IDataContext, EntityBuilder<TChild>>

Builds the child query from the data context that owns the parent query.

parentKey Expression<Func<TEntity, TKey>>

Selects the parent key used to match children.

childKey Expression<Func<TChild, TKey>>

Selects the child key used to match parents.

mode EagerLoadMode

The whole-builder eager-load mode; Default inherits the current choice (split when none was made).

Returns

EntityBuilder<TEntity>

A copy of this builder carrying the eager-load declaration and the resolved mode.

Type Parameters

TChild

The child entity type.

TKey

The non-nullable key type shared by the parent and child selectors. A null key value observed at runtime is skipped and never matches.

Exceptions

InvalidOperationException

The collection member already carries an eager-load declaration on this builder.

ArgumentOutOfRangeException

mode is not a defined value.

NotSupportedException

A different explicit mode is already active on this builder.

Offset(int)

Sets the number of leading rows to skip; zero starts from the first row.

public EntityBuilder<TEntity> Offset(int offset)

Parameters

offset int

The number of rows to skip; must be non-negative.

Returns

EntityBuilder<TEntity>

A builder with the new offset.

OrderBy(int)

Adds an ascending ordering key by 1-based output column index.

public EntityBuilder<TEntity> OrderBy(int columnIdx)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

OrderBy(int, NullsPosition)

Adds an ascending ordering key by 1-based output column index with the requested NULL placement.

public EntityBuilder<TEntity> OrderBy(int columnIdx, NullsPosition nullsPosition)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

OrderBy(int, OrderDirection)

Adds an ordering key by 1-based output column index.

public EntityBuilder<TEntity> OrderBy(int columnIdx, OrderDirection direction)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

direction OrderDirection

Ascending or descending.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

OrderBy(int, OrderDirection, NullsPosition)

Adds an ordering key by 1-based output column index with the given direction and NULL placement.

public EntityBuilder<TEntity> OrderBy(int columnIdx, OrderDirection direction, NullsPosition nullsPosition)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

direction OrderDirection

Ascending or descending.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

OrderBy(Expression<Func<TEntity, object?>>)

Adds an ascending ordering key by orderExp.

public EntityBuilder<TEntity> OrderBy(Expression<Func<TEntity, object?>> orderExp)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

OrderBy(Expression<Func<TEntity, object?>>, NullsPosition)

Adds an ascending ordering key by orderExp with the requested NULL placement. Repeated calls append keys, so the existing order is preserved.

public EntityBuilder<TEntity> OrderBy(Expression<Func<TEntity, object?>> orderExp, NullsPosition nullsPosition)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

OrderBy(Expression<Func<TEntity, object?>>, OrderDirection)

Adds an ordering key. Repeated calls append keys, so the existing order is preserved.

public EntityBuilder<TEntity> OrderBy(Expression<Func<TEntity, object?>> orderExp, OrderDirection direction)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

direction OrderDirection

Ascending or descending.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

OrderBy(Expression<Func<TEntity, object?>>, OrderDirection, NullsPosition)

Adds an ordering key by orderExp with the given direction and NULL placement. Repeated calls append keys, so the existing order is preserved.

public EntityBuilder<TEntity> OrderBy(Expression<Func<TEntity, object?>> orderExp, OrderDirection direction, NullsPosition nullsPosition)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

direction OrderDirection

Ascending or descending.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

OrderByDescending(int)

Adds a descending ordering key by 1-based output column index.

public EntityBuilder<TEntity> OrderByDescending(int columnIdx)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

OrderByDescending(int, NullsPosition)

Adds a descending ordering key by 1-based output column index with the requested NULL placement.

public EntityBuilder<TEntity> OrderByDescending(int columnIdx, NullsPosition nullsPosition)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

OrderByDescending(Expression<Func<TEntity, object?>>)

Adds a descending ordering key by orderExp.

public EntityBuilder<TEntity> OrderByDescending(Expression<Func<TEntity, object?>> orderExp)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

OrderByDescending(Expression<Func<TEntity, object?>>, NullsPosition)

Adds a descending ordering key by orderExp with the requested NULL placement.

public EntityBuilder<TEntity> OrderByDescending(Expression<Func<TEntity, object?>> orderExp, NullsPosition nullsPosition)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the added ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

OuterApply(string, Action<JoinOptions>?)

Adds an OUTER APPLY over the table named table without an explicit source.

public JoinedEntityBuilder<TEntity, TableAlias> OuterApply(string table, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null, empty, or whitespace-only table is rejected at the call site with ArgumentNullException / ArgumentException (ParamName == "table"), matching the explicit ctx.From(table) form.

OuterApply<TJoinEntity>(Cte<TJoinEntity>)

Applies the typed CTE cte with OUTER APPLY.

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(Cte<TJoinEntity> cte)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the applied projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte is null.

OuterApply<TJoinEntity>(Cte<TJoinEntity>, Action<JoinOptions>?)

Applies the typed CTE cte with OUTER APPLY and per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(Cte<TJoinEntity> cte, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the applied projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte is null.

OuterApply<TJoinEntity>(EntityBuilder<TJoinEntity>, Action<JoinOptions>?)

Applies _ to every left-hand row, preserving left-hand rows with an empty result (OUTER APPLY / LEFT JOIN LATERAL ... ON true). There is no ON condition.

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(EntityBuilder<TJoinEntity> _, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the applied entity; only its source is used.

options Action<JoinOptions>

Optional per-join configuration; see CrossApply<TJoinEntity>(EntityBuilder<TJoinEntity>, Action<JoinOptions>?).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the applied projection.

Type Parameters

TJoinEntity

OuterApply<TJoinEntity>(QueryCommand<TJoinEntity>, Action<JoinOptions>?)

Applies a derived query to every left-hand row, preserving left-hand rows with an empty result (OUTER APPLY).

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(QueryCommand<TJoinEntity> query, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

options Action<JoinOptions>

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

Type Parameters

TJoinEntity

OuterApply<TJoinEntity>(Action<JoinOptions>?)

Adds an OUTER APPLY over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(Action<JoinOptions>? options = null)

Parameters

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

OuterApply<TJoinEntity>(Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>, Action<JoinOptions>?)

Applies a correlated derived query to every left-hand row, preserving left-hand rows with an empty result (OUTER APPLY / LEFT JOIN LATERAL ... ON true). source receives the left-hand row, so the query it builds may reference its columns. The element type yielded by the applied query.

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(Expression<Func<TEntity, EntityBuilder<TJoinEntity>>> source, Action<JoinOptions>? options = null)

Parameters

source Expression<Func<TEntity, EntityBuilder<TJoinEntity>>>

options Action<JoinOptions>

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

Type Parameters

TJoinEntity

OuterApply<TJoinEntity>(Expression<Func<TEntity, QueryCommand<TJoinEntity>>>, Action<JoinOptions>?)

Applies a correlated derived query to every left-hand row, preserving left-hand rows with an empty result (OUTER APPLY / LEFT JOIN LATERAL ... ON true). source receives the left-hand row, so the query it builds may reference its columns. The element type yielded by the applied query.

public JoinedEntityBuilder<TEntity, TJoinEntity> OuterApply<TJoinEntity>(Expression<Func<TEntity, QueryCommand<TJoinEntity>>> source, Action<JoinOptions>? options = null)

Parameters

source Expression<Func<TEntity, QueryCommand<TJoinEntity>>>

options Action<JoinOptions>

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

Type Parameters

TJoinEntity

Page(int, int)

Sets both the page size and the start position in a single call.

public EntityBuilder<TEntity> Page(int limit, int offset)

Parameters

limit int

The page size; must be non-negative.

offset int

The number of leading rows to skip; must be non-negative.

Returns

EntityBuilder<TEntity>

A builder with the new limit and offset.

RightJoin(string, Expression<Func<TEntity, TableAlias, bool>>, Action<JoinOptions>?)

Adds a RIGHT JOIN over the table named table without an explicit source.

public JoinedEntityBuilder<TEntity, TableAlias> RightJoin(string table, Expression<Func<TEntity, TableAlias, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

table string

The physical table name of the joined source.

joinCondition Expression<Func<TEntity, TableAlias, bool>>

A predicate relating the current entity to the joined TableAlias row.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged.

Returns

JoinedEntityBuilder<TEntity, TableAlias>

A builder over the projection extended with TableAlias.

Remarks

A null joinCondition is accepted and renders no ON clause, matching the explicit form over ctx.From(table).

RightJoin<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>)

Adds a right outer join over the typed CTE cte.

public JoinedEntityBuilder<TEntity, TJoinEntity> RightJoin<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

RightJoin<TJoinEntity>(Cte<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a right outer join over the typed CTE cte with per-join options.

public JoinedEntityBuilder<TEntity, TJoinEntity> RightJoin<TJoinEntity>(Cte<TJoinEntity> cte, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options)

Parameters

cte Cte<TJoinEntity>

The CTE descriptor, converted with this builder's context.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Per-join configuration.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

The CTE's projection type.

Exceptions

ArgumentNullException

cte or joinCondition is null.

RightJoin<TJoinEntity>(EntityBuilder<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a right outer join: every right-hand row is kept, and left-hand columns are NULL when there is no match.

public JoinedEntityBuilder<TEntity, TJoinEntity> RightJoin<TJoinEntity>(EntityBuilder<TJoinEntity> _, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

_ EntityBuilder<TJoinEntity>

The builder for the joined entity; only its source is used.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

RightJoin<TJoinEntity>(QueryCommand<TJoinEntity>, Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a right outer join to the derived query: every right-hand row is kept, and left-hand columns are NULL when there is no match.

public JoinedEntityBuilder<TEntity, TJoinEntity> RightJoin<TJoinEntity>(QueryCommand<TJoinEntity> query, Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

query QueryCommand<TJoinEntity>

The derived query to join.

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

The join predicate over the two entities.

options Action<JoinOptions>

Optional per-join configuration, for example j => j.Global() or j => j.WithStrictness(JoinStrictness.Any).

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the joined projection.

Type Parameters

TJoinEntity

RightJoin<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>>, Action<JoinOptions>?)

Adds a RIGHT JOIN over TJoinEntity without an explicit source; TJoinEntity is resolved through this builder's context (From<TJoinEntity>()) and forwarded to the source-explicit overload.

public JoinedEntityBuilder<TEntity, TJoinEntity> RightJoin<TJoinEntity>(Expression<Func<TEntity, TJoinEntity, bool>> joinCondition, Action<JoinOptions>? options = null)

Parameters

joinCondition Expression<Func<TEntity, TJoinEntity, bool>>

A predicate relating the current projection to the joined entity.

options Action<JoinOptions>

Optional per-join configuration; forwarded unchanged to the source-explicit overload.

Returns

JoinedEntityBuilder<TEntity, TJoinEntity>

A builder over the projection extended with TJoinEntity.

Type Parameters

TJoinEntity

The entity type of the joined table.

Exceptions

ArgumentNullException

joinCondition is null.

SelectMany<TCollection>(Expression<Func<TEntity, IEnumerable<TCollection>>>)

Flattens the sequence produced by collectionSelector for every row of this query (source.SelectMany(...)), yielding the selected elements.

Supported by the InMemoryDataContext only; SQL providers throw NotSupportedException.

public EntityBuilder<TCollection> SelectMany<TCollection>(Expression<Func<TEntity, IEnumerable<TCollection>>> collectionSelector)

Parameters

collectionSelector Expression<Func<TEntity, IEnumerable<TCollection>>>

Returns

EntityBuilder<TCollection>

Type Parameters

TCollection

SelectMany<TCollection, TResult>(Expression<Func<TEntity, IEnumerable<TCollection>>>, Expression<Func<TEntity, TCollection, TResult>>)

Flattens the sequence produced by collectionSelector for every row of this query and projects each pair with resultSelector.

Supported by the InMemoryDataContext only; SQL providers throw NotSupportedException.

public EntityBuilder<TResult> SelectMany<TCollection, TResult>(Expression<Func<TEntity, IEnumerable<TCollection>>> collectionSelector, Expression<Func<TEntity, TCollection, TResult>> resultSelector)

Parameters

collectionSelector Expression<Func<TEntity, IEnumerable<TCollection>>>

resultSelector Expression<Func<TEntity, TCollection, TResult>>

Returns

EntityBuilder<TResult>

Type Parameters

TCollection

TResult

SelectWhereMaxOld<TValue>(Expression<Func<TEntity, TValue>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

Selects the row(s) with the maximum valueSelector value, optionally per groupBy group. Requires a dialect that supports it (see SupportsSelectWhereMinMax).

public EntityBuilder<TEntity> SelectWhereMaxOld<TValue>(Expression<Func<TEntity, TValue>> valueSelector, ExtremeRowTies ties = ExtremeRowTies.One, Expression<Func<TEntity, object?>>? groupBy = null)

Parameters

valueSelector Expression<Func<TEntity, TValue>>

The value whose maximum is compared.

ties ExtremeRowTies

Whether to keep a single row or every tied row.

groupBy Expression<Func<TEntity, object>>

Optional grouping key; null selects across the whole result.

Returns

EntityBuilder<TEntity>

Type Parameters

TValue

The value type compared for the extremum.

SelectWhereMaxOld<TValue, TResult>(Expression<Func<TEntity, TValue>>, Expression<Func<TEntity, TResult>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

Selects the row(s) with the maximum valueSelector value and projects each with projection, optionally per groupBy group. Requires a dialect that supports it (see SupportsSelectWhereMinMax).

public QueryCommand<TResult> SelectWhereMaxOld<TValue, TResult>(Expression<Func<TEntity, TValue>> valueSelector, Expression<Func<TEntity, TResult>> projection, ExtremeRowTies ties = ExtremeRowTies.One, Expression<Func<TEntity, object?>>? groupBy = null)

Parameters

valueSelector Expression<Func<TEntity, TValue>>

The value whose maximum is compared.

projection Expression<Func<TEntity, TResult>>

The projection applied to the surviving row(s).

ties ExtremeRowTies

Whether to keep a single row or every tied row.

groupBy Expression<Func<TEntity, object>>

Optional grouping key; null selects across the whole result.

Returns

QueryCommand<TResult>

Type Parameters

TValue

The value type compared for the extremum.

TResult

The projection type.

SelectWhereMinOld<TValue>(Expression<Func<TEntity, TValue>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

Selects the row(s) with the minimum valueSelector value, optionally per groupBy group. Requires a dialect that supports it (see SupportsSelectWhereMinMax).

public EntityBuilder<TEntity> SelectWhereMinOld<TValue>(Expression<Func<TEntity, TValue>> valueSelector, ExtremeRowTies ties = ExtremeRowTies.One, Expression<Func<TEntity, object?>>? groupBy = null)

Parameters

valueSelector Expression<Func<TEntity, TValue>>

The value whose minimum is compared.

ties ExtremeRowTies

Whether to keep a single row or every tied row.

groupBy Expression<Func<TEntity, object>>

Optional grouping key; null selects across the whole result.

Returns

EntityBuilder<TEntity>

Type Parameters

TValue

The value type compared for the extremum.

SelectWhereMinOld<TValue, TResult>(Expression<Func<TEntity, TValue>>, Expression<Func<TEntity, TResult>>, ExtremeRowTies, Expression<Func<TEntity, object?>>?)

Selects the row(s) with the minimum valueSelector value and projects each with projection, optionally per groupBy group. Requires a dialect that supports it (see SupportsSelectWhereMinMax).

public QueryCommand<TResult> SelectWhereMinOld<TValue, TResult>(Expression<Func<TEntity, TValue>> valueSelector, Expression<Func<TEntity, TResult>> projection, ExtremeRowTies ties = ExtremeRowTies.One, Expression<Func<TEntity, object?>>? groupBy = null)

Parameters

valueSelector Expression<Func<TEntity, TValue>>

The value whose minimum is compared.

projection Expression<Func<TEntity, TResult>>

The projection applied to the surviving row(s).

ties ExtremeRowTies

Whether to keep a single row or every tied row.

groupBy Expression<Func<TEntity, object>>

Optional grouping key; null selects across the whole result.

Returns

QueryCommand<TResult>

Type Parameters

TValue

The value type compared for the extremum.

TResult

The projection type.

Select<TResult>(Expression<Func<TEntity, TResult>>)

Projects each row with exp and creates the SELECT command for the query, carrying every modifier set on this builder.

public QueryCommand<TResult> Select<TResult>(Expression<Func<TEntity, TResult>> exp)

Parameters

exp Expression<Func<TEntity, TResult>>

The projection expression.

Returns

QueryCommand<TResult>

The command that produces TResult rows.

Type Parameters

TResult

The projection type produced by exp.

ThenBy(int)

Adds an ascending secondary ordering key by 1-based output column index. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(int columnIdx)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

ThenBy(int, NullsPosition)

Adds an ascending secondary ordering key by 1-based output column index with the requested NULL placement. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(int columnIdx, NullsPosition nullsPosition)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

ThenBy(int, OrderDirection)

Adds a secondary ordering key by 1-based output column index with the given direction. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(int columnIdx, OrderDirection direction)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

direction OrderDirection

Ascending or descending.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

ThenBy(int, OrderDirection, NullsPosition)

Adds a secondary ordering key by 1-based output column index with the given direction and NULL placement. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(int columnIdx, OrderDirection direction, NullsPosition nullsPosition)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

direction OrderDirection

Ascending or descending.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

ThenBy(Expression<Func<TEntity, object?>>)

Adds an ascending secondary ordering key by orderExp. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(Expression<Func<TEntity, object?>> orderExp)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

ThenBy(Expression<Func<TEntity, object?>>, NullsPosition)

Adds an ascending secondary ordering key by orderExp with the requested NULL placement. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(Expression<Func<TEntity, object?>> orderExp, NullsPosition nullsPosition)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

ThenBy(Expression<Func<TEntity, object?>>, OrderDirection)

Adds a secondary ordering key by orderExp with the given direction. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(Expression<Func<TEntity, object?>> orderExp, OrderDirection direction)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

direction OrderDirection

Ascending or descending.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

ThenBy(Expression<Func<TEntity, object?>>, OrderDirection, NullsPosition)

Adds a secondary ordering key by orderExp with the given direction and NULL placement. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenBy(Expression<Func<TEntity, object?>> orderExp, OrderDirection direction, NullsPosition nullsPosition)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

direction OrderDirection

Ascending or descending.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

ThenByDescending(int)

Adds a descending secondary ordering key by 1-based output column index. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenByDescending(int columnIdx)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

ThenByDescending(int, NullsPosition)

Adds a descending secondary ordering key by 1-based output column index with the requested NULL placement. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenByDescending(int columnIdx, NullsPosition nullsPosition)

Parameters

columnIdx int

The 1-based result column index; must be greater than zero.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

ThenByDescending(Expression<Func<TEntity, object?>>)

Adds a descending secondary ordering key by orderExp. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenByDescending(Expression<Func<TEntity, object?>> orderExp)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

ThenByDescending(Expression<Func<TEntity, object?>>, NullsPosition)

Adds a descending secondary ordering key by orderExp with the requested NULL placement. The key is appended after every existing key; it never replaces one.

public EntityBuilder<TEntity> ThenByDescending(Expression<Func<TEntity, object?>> orderExp, NullsPosition nullsPosition)

Parameters

orderExp Expression<Func<TEntity, object>>

The key selector.

nullsPosition NullsPosition

Where SQL NULL values are placed for this key.

Returns

EntityBuilder<TEntity>

A builder with the appended ordering key.

Exceptions

ArgumentOutOfRangeException

nullsPosition is not a defined NullsPosition member.

ToCommand()

Creates a SELECT command over the entity type without a custom projection, carrying every modifier set on this builder.

public QueryCommand<TEntity> ToCommand()

Returns

QueryCommand<TEntity>

The command that produces TEntity rows.

Where(Expression<Func<TEntity, bool>>)

Adds condition to the WHERE clause. A repeated call combines the predicates with and. Returns a new builder; the current one is unchanged.

public EntityBuilder<TEntity> Where(Expression<Func<TEntity, bool>> condition)

Parameters

condition Expression<Func<TEntity, bool>>

The predicate each row must satisfy.

Returns

EntityBuilder<TEntity>

A builder with the added predicate.

Window(string, Expression<Func<TEntity, object?>>[]?, NamedWindowOrderKey[]?, WindowFrame?)

Declares a named window w AS (PARTITION BY ... ORDER BY ... frame) on this query. Window functions reference it with Over("w"); every declared window renders in a single WINDOW clause after GROUP BY/HAVING. Requires a dialect that supports named windows (see SupportsNamedWindows). Declare windows after any join, on the final builder.

public EntityBuilder<TEntity> Window(string name, Expression<Func<TEntity, object?>>[]? partitionBy = null, NamedWindowOrderKey[]? orderBy = null, WindowFrame? frame = null)

Parameters

name string

The window name (a simple SQL identifier).

partitionBy Expression<Func<TEntity, object>>[]

Optional PARTITION BY key expressions.

orderBy NamedWindowOrderKey[]

Optional ORDER BY keys, built with Asc(Expression<Func<TEntity, object?>>) or Desc(Expression<Func<TEntity, object?>>).

frame WindowFrame

Optional frame.

Returns

EntityBuilder<TEntity>

WithCommandTimeout(int)

Overrides the command timeout in seconds for the commands this builder creates: it takes precedence over the context default set with DataContextBuilder.UseCommandTimeout. A value of zero or less means the provider default. The override is part of the plan-cache key, so two otherwise identical queries with different timeouts do not share a cached command.

public EntityBuilder<TEntity> WithCommandTimeout(int seconds)

Parameters

seconds int

The command timeout in seconds; zero or less uses the provider default.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

WithComponent(IQueryComponent)

Attaches a query component to this builder. Components with the same slot replace the previous value in place; the builder is not mutated.

public EntityBuilder<TEntity> WithComponent(IQueryComponent component)

Parameters

component IQueryComponent

The component to attach.

Returns

EntityBuilder<TEntity>

A new builder with the component attached.

Exceptions

ArgumentNullException

component is null.

WithDatabase(string)

Qualifies the primary table with database for this query only (database.schema.table on SQL Server, database.table on MySQL/MariaDB/ClickHouse, an attached database on SQLite). Requires a provider that opted into SupportsCrossDatabase.

public EntityBuilder<TEntity> WithDatabase(string database)

Parameters

database string

The database name to render before the table.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

WithKeywordCase(KeywordCase)

Overrides the letter case in which the SQL keywords of the commands this builder creates are emitted (see DataContextBuilder.UseKeywordCase for the context default). Upper renders SELECT ... FROM ...; identifiers, string literals, function names, type names and raw SQL are never affected.

public EntityBuilder<TEntity> WithKeywordCase(KeywordCase keywordCase = KeywordCase.Upper)

Parameters

keywordCase KeywordCase

The keyword case to apply.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

WithNamingConvention(INamingConvention?)

Overrides the naming convention applied to auto-derived table/column names for the commands this builder creates (see DataContextBuilder.UseNamingConvention for the context default).

public EntityBuilder<TEntity> WithNamingConvention(INamingConvention? convention)

Parameters

convention INamingConvention

Returns

EntityBuilder<TEntity>

WithQuotedIdentifiers(bool)

Overrides identifier quoting for the commands this builder creates: when value is true, physical table and column names are quoted with the provider's delimiter ("id" on PostgreSQL/SQLite, [id] on SQL Server, `id` on MySQL/MariaDB/ClickHouse); when false, names are emitted verbatim. Without a call the command inherits the context default set with DataContextBuilder.UseQuotedIdentifiers.

public EntityBuilder<TEntity> WithQuotedIdentifiers(bool value = true)

Parameters

value bool

Returns

EntityBuilder<TEntity>

WithSchema(string)

Qualifies the primary table with schema for this query only, for example From<IOrder>().WithSchema("sales") rendering sales.orders. Requires a provider that can render a schema qualifier (see MakeQualifiedTableName(string?, string?, string?, string)).

public EntityBuilder<TEntity> WithSchema(string schema)

Parameters

schema string

The schema name to render before the table.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

WithServer(string)

Qualifies the primary table with a linked server for this query only (server.database.schema.table). Only SQL Server opted into SupportsLinkedServer; every other provider rejects the override with NotSupportedException.

public EntityBuilder<TEntity> WithServer(string server)

Parameters

server string

The linked server name to render before the table.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

WithTableExpression(string)

Replaces the primary table access with the raw SQL sql rendered as a derived source ((sql) AS alias) for this query only. The mapped entity's columns are read from the expression's result set. The fragment is emitted verbatim, so pass only trusted SQL (the caller owns validity and injection safety, as with WithSql). Cannot be combined with a table-name/schema/database/server override. SQL providers only.

public EntityBuilder<TEntity> WithTableExpression(string sql)

Parameters

sql string

The raw SQL expression to use as the table source.

Returns

EntityBuilder<TEntity>

A builder with the source replaced.

WithTableName(string)

Overrides the physical table name of the primary source for this query only, for example From<IOrder>().WithTableName("orders_archive"). The mapped entity (and its columns) is unchanged, and other queries are unaffected. The name is emitted verbatim, or quoted when identifier quoting is enabled (see WithQuotedIdentifiers(bool)).

public EntityBuilder<TEntity> WithTableName(string name)

Parameters

name string

The table name to render instead of the mapped one.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

WithTablesInScopeHint(params string[])

Attaches hints to every physical table in the query's scope: on SQL Server each table (the primary source and every joined table) gets a WITH (hint, ...) suffix; on PostgreSQL/MySQL/MariaDB the hints are folded into the statement-level /*+ ... */ comment. A dialect that supports neither rejects the command with NotSupportedException. The hints are emitted verbatim, so only use trusted values.

public EntityBuilder<TEntity> WithTablesInScopeHint(params string[] hints)

Parameters

hints string[]

The hint texts; at least one non-empty.

Returns

EntityBuilder<TEntity>

A builder with the tables-in-scope hints applied.

Exceptions

ArgumentException

No non-empty hint was supplied.

WithTag(string?)

Attaches a query tag to the commands this builder creates. The tag is rendered as a block comment (/* tag */) immediately after the SELECT keyword on every SQL provider, so the statement is identifiable in logs, profilers and server-side query stores. It is not an optimizer hint (use Hint(params string[]) for that). Passing a new tag returns a new builder; null or an empty string clears it. The tag is part of the plan key.

public EntityBuilder<TEntity> WithTag(string? tag)

Parameters

tag string

The tag text to render, or null to clear the tag.

Returns

EntityBuilder<TEntity>

A builder with the tag applied.

WithTies()

Marks the page request as WITH TIES: the result keeps every row tied with the last row of the page by the ORDER BY. Requires a positive page limit and a dialect that supports it (see SupportsWithTies). Cannot be combined with Distinct() or DistinctOn: this combination is rejected during SQL generation with BuildSqlCommandException; validation is not performed by the WithTies fluent call itself.

public EntityBuilder<TEntity> WithTies()

Returns

EntityBuilder<TEntity>

WithUppercaseKeywords(bool)

Convenience form of WithKeywordCase(KeywordCase): enables (value is true) or disables upper-case SQL keywords for the commands this builder creates.

public EntityBuilder<TEntity> WithUppercaseKeywords(bool value = true)

Parameters

value bool

true to emit keywords in upper case; otherwise lower case.

Returns

EntityBuilder<TEntity>

A builder with the override applied.

Operators

implicit operator QueryCommand(EntityBuilder<TEntity>)

Implicitly converts the builder to its untyped command, so a builder can be passed where a QueryCommand is expected.

public static implicit operator QueryCommand(EntityBuilder<TEntity> builder)

Parameters

builder EntityBuilder<TEntity>

The builder to convert.

Returns

QueryCommand

The command built by ToCommand().

implicit operator QueryCommand<TEntity>(EntityBuilder<TEntity>)

Implicitly converts the builder to its command, so a builder can be passed where a QueryCommand<TResult> is expected.

public static implicit operator QueryCommand<TEntity>(EntityBuilder<TEntity> builder)

Parameters

builder EntityBuilder<TEntity>

The builder to convert.

Returns

QueryCommand<TEntity>

The command built by ToCommand().