QueryableExtensionMethods Class

Class for the LLBLGen Pro extension methods for Queryable.

Inheritance Hierarchy

SystemObject
SD.LLBLGen.Pro.LinqSupportClassesQueryableExtensionMethods

Namespace: SD.LLBLGen.Pro.LinqSupportClasses
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.7.0.0 (5.7.0)

Syntax

Copy

public static class QueryableExtensionMethods

<ExtensionAttribute>
Public NotInheritable Class QueryableExtensionMethods

The QueryableExtensionMethods type exposes the following members.

Methods

	Name	Description
	AllAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.All
	AllAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.All
	AnyAsyncTSource(IQueryableTSource)	Async variant of Queryable.Any
	AnyAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.Any
	AnyAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.Any
	AnyAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.Any
	AverageAsync(IQueryableDecimal)	Async variant of Queryable.Average
	AverageAsync(IQueryableDouble)	Async variant of Queryable.Average
	AverageAsync(IQueryableInt32)	Async variant of Queryable.Average
	AverageAsync(IQueryableInt64)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableDecimal)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableDouble)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableInt32)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableInt64)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableSingle)	Async variant of Queryable.Average
	AverageAsync(IQueryableSingle)	Async variant of Queryable.Average
	AverageAsync(IQueryableDecimal, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableDouble, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableInt32, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableInt64, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableDecimal, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableDouble, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableInt32, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableInt64, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableNullableSingle, CancellationToken)	Async variant of Queryable.Average
	AverageAsync(IQueryableSingle, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Decimal)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Double)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int32)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int64)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDecimal)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDouble)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt32)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt64)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableSingle)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Single)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Decimal, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Double, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int32, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int64, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDecimal, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDouble, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt32, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt64, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableSingle, CancellationToken)	Async variant of Queryable.Average
	AverageAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Single, CancellationToken)	Async variant of Queryable.Average
	CacheResultsetTSource(IQueryableTSource, Int32)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, TimeSpan)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, Int32, Boolean)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, Int32, String)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, TimeSpan, Boolean)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, TimeSpan, String)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, Int32, Boolean, String)	Specifies that the query's resultset should be cached for the duration specified.
	CacheResultsetTSource(IQueryableTSource, TimeSpan, Boolean, String)	Specifies that the query's resultset should be cached for the duration specified. Only one tag is kept per complete query. Specify the tag you want to use on the outermost query expression.
	ContainsAsyncTSource(IQueryableTSource, TSource)	Async variant of Queryable.Contains
	ContainsAsyncTSource(IQueryableTSource, TSource, CancellationToken)	Async variant of Queryable.Contains
	CountAsyncTSource(IQueryableTSource)	Async variant of Queryable.Count
	CountAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.Count
	CountAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.Count
	CountAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.Count
	CountColumnTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType)	returns the number of values in the set specified by selector which is 1 column wide.
	CountColumnTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean)	returns the number of distinct values in the set specified by selector which is 1 column wide
	CountColumnAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType)	Async variant of CountColumn
	CountColumnAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean)	Async variant of CountColumn.
	CountColumnAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, CancellationToken)	Async variant of CountColumn.
	CountColumnAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean, CancellationToken)	Async variant of CountColumn.
	ElementAtAsyncTSource(IQueryableTSource, Int32)	Async variant of Queryable.ElementAt
	ElementAtAsyncTSource(IQueryableTSource, Int32, CancellationToken)	Async variant of Queryable.ElementAt
	ElementAtOrDefaultAsyncTSource(IQueryableTSource, Int32)	Async variant of Queryable.ElementAtOrDefault
	ElementAtOrDefaultAsyncTSource(IQueryableTSource, Int32, CancellationToken)	Async variant of Queryable.ElementAtOrDefault
	ExcludeFieldsTSource	Specifies a list of fields to exclude for an entity fetch.
	Execute(IQueryable)	Executes the specified IQueryable. Requires the IQueryable to implement ILLBLGenProQuery.
	ExecuteTResult(IQueryable)	Executes the specified IQueryable. Requires the IQueryable to implement ILLBLGenProQuery.
	ExecuteAsync(IQueryable)	Executes the specified IQueryable's asynchronously. Requires the IQueryable to implement ILLBLGenProQuery.
	ExecuteAsync(IQueryable, CancellationToken)	Executes the specified IQueryable's asynchronously. Requires the IQueryable to implement ILLBLGenProQuery.
	ExecuteAsyncTResult(IQueryable)	Executes the specified IQueryable's asynchronously. Requires the IQueryable to implement ILLBLGenProQuery.
	ExecuteAsyncTResult(IQueryable, CancellationToken)	Executes the specified IQueryable's asynchronously. Requires the IQueryable to implement ILLBLGenProQuery.
	FirstAsyncTSource(IQueryableTSource)	Async variant of Queryable.First
	FirstAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.First
	FirstAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.First
	FirstAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.First
	FirstOrDefaultAsyncTSource(IQueryableTSource)	Async variant of Queryable.FirstOrDefault
	FirstOrDefaultAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.FirstOrDefault
	FirstOrDefaultAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.FirstOrDefault
	FirstOrDefaultAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.FirstOrDefault
	ForBusinessTimeTSource	Specifies a temporal table predicate on source for the Business Time.
	ForSystemTimeTSource	Specifies a temporal table predicate on source for the System Time.
	IncludeFieldsTSource	Specifies a list of fields to include for an entity fetch. All fields not specified aren't fetched (fields which are required like fk fields are always fetched)
	LongCountAsyncTSource(IQueryableTSource)	Async variant of Queryable.LongCount
	LongCountAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.LongCount
	LongCountAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.LongCount
	LongCountAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.LongCount
	MarkWithTagTSource	Specifies the tag to append as comment into the SQL query / queries generated from the query specified. Use the tag to trace back the origin of a SQL query in the RDBMS.
	MaxAsyncTSource(IQueryableTSource)	Async variant of Queryable.Max
	MaxAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.Max
	MaxAsyncTSource, TResult(IQueryableTSource, ExpressionFuncTSource, TResult)	Async variant of Queryable.Max
	MaxAsyncTSource, TResult(IQueryableTSource, ExpressionFuncTSource, TResult, CancellationToken)	Async variant of Queryable.Max
	MinAsyncTSource(IQueryableTSource)	Async variant of Queryable.Min
	MinAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.Min
	MinAsyncTSource, TResult(IQueryableTSource, ExpressionFuncTSource, TResult)	Async variant of Queryable.Min
	MinAsyncTSource, TResult(IQueryableTSource, ExpressionFuncTSource, TResult, CancellationToken)	Async variant of Queryable.Min
	SingleAsyncTSource(IQueryableTSource)	Async variant of Queryable.Single
	SingleAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.Single
	SingleAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.Single
	SingleAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.Single
	SingleOrDefaultAsyncTSource(IQueryableTSource)	Async variant of Queryable.SingleOrDefault
	SingleOrDefaultAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean)	Async variant of Queryable.SingleOrDefault
	SingleOrDefaultAsyncTSource(IQueryableTSource, CancellationToken)	Async variant of Queryable.SingleOrDefault
	SingleOrDefaultAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Boolean, CancellationToken)	Async variant of Queryable.SingleOrDefault
	StandardDeviationTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType)	returns the standard deviation over the column specified by selector.
	StandardDeviationTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean)	returns the standard deviation over the column specified by selector.
	StandardDeviationAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType)	Async variant of StandardDeviation.
	StandardDeviationAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean)	Async variant of StandardDeviation.
	StandardDeviationAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, CancellationToken)	Async variant of StandardDeviation.
	StandardDeviationAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean, CancellationToken)	Async variant of StandardDeviation.
	SumAsync(IQueryableDecimal)	Async variant of Queryable.Sum
	SumAsync(IQueryableDouble)	Async variant of Queryable.Sum
	SumAsync(IQueryableInt32)	Async variant of Queryable.Sum
	SumAsync(IQueryableInt64)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableDecimal)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableDouble)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableInt32)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableInt64)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableSingle)	Async variant of Queryable.Sum
	SumAsync(IQueryableSingle)	Async variant of Queryable.Sum
	SumAsync(IQueryableDecimal, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableDouble, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableInt32, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableInt64, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableDecimal, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableDouble, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableInt32, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableInt64, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableNullableSingle, CancellationToken)	Async variant of Queryable.Sum
	SumAsync(IQueryableSingle, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Decimal)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Double)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int32)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int64)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDecimal)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDouble)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt32)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt64)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableSingle)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Single)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Decimal, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Double, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int32, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Int64, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDecimal, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableDouble, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt32, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableInt64, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, NullableSingle, CancellationToken)	Async variant of Queryable.Sum
	SumAsyncTSource(IQueryableTSource, ExpressionFuncTSource, Single, CancellationToken)	Async variant of Queryable.Sum
	TakePageTSource	Returns the pageNumber-th page of size pageSize from the sequence the method is applied on.
	ToArrayAsyncTResult(IQueryableTResult)	Executes source asynchronously and stores the results in a new TResult[]. Requires the IQueryable to implement ILLBLGenProQuery.
	ToArrayAsyncTResult(IQueryableTResult, CancellationToken)	Executes source asynchronously and stores the results in a new TResult[]. Requires the IQueryable to implement ILLBLGenProQuery.
	ToListAsyncTResult(IQueryableTResult)	Executes source asynchronously and stores the results in a new List(Of TResult). Requires the IQueryable to implement ILLBLGenProQuery.
	ToListAsyncTResult(IQueryableTResult, CancellationToken)	Executes source asynchronously and stores the results in a new List(Of TResult). Requires the IQueryable to implement ILLBLGenProQuery.
	VarianceTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType)	returns the variance over the column specified by selector.
	VarianceTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean)	returns the variance over the column specified by selector.
	VarianceAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType)	Async variant of Variance.
	VarianceAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean)	Async variant of Variance.
	VarianceAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, CancellationToken)	Async variant of Variance.
	VarianceAsyncTSource, TColumnType(IQueryableTSource, ExpressionFuncTSource, TColumnType, Boolean, CancellationToken)	Async variant of Variance.
	WithHintTSource(IQueryableTSource, String)	Specifies a table/view hint for the target TSource is mapped on.
	WithHintTSource(IQueryableTSource, String, HintType)	Specifies a hint for this query. It depends on the specified hintKind in what way the hint will be used: as a target hint or as a query hint.
	WithPathTSource(IQueryableTSource, IPathEdge)	Specifies a prefetch path with the edges specified when fetching source.
	WithPathTSource(IQueryableTSource, IPrefetchPathCore)	Specifies a prefetch path for the source. Use this overload if you have existing code which produces prefetch path objects for you
	WithPathTSource(IQueryableTSource, FuncIPathEdgeRootParserTSource, IPathEdgeRootParserTSource)	Specifies a prefetch path with the path edges specified in the form of a chain of method calls using lambda expressions.

Top

Reference

SD.LLBLGen.Pro.LinqSupportClasses Namespace