Interface WindowFunctionBuilder.INullTreatmentPart<TNext>

Namespace

LinqToDB

Assembly

linq2db.dll

Provides function-level null treatment (IGNORE NULLS / RESPECT NULLS) for value/offset window functions.

public interface WindowFunctionBuilder.INullTreatmentPart<out TNext> where TNext : class

Type Parameters

TNext

Extension Methods

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Methods

IgnoreNulls()

Adds IGNORE NULLS — the function skips NULL values. Not supported by every provider.

TNext IgnoreNulls()

Returns

TNext

RespectNulls()

Adds RESPECT NULLS — the SQL default. Provided for explicitness; emits nothing on providers where it is the default.

TNext RespectNulls()

Returns

TNext