Interface WindowFunctionBuilder.IFilterPart<TFiltered>

Namespace

LinqToDB

Assembly

linq2db.dll

Provides the FILTER (WHERE ...) clause for aggregate window functions.

public interface WindowFunctionBuilder.IFilterPart<out TFiltered> where TFiltered : class

Type Parameters

TFiltered

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

Filter(bool)

Adds a FILTER (WHERE ...) clause. Natively supported by PostgreSQL and DuckDB; emulated via CASE WHEN on other providers.

TFiltered Filter(bool filter)

Parameters

filter bool

Returns

TFiltered