Class CompiledQuery

Provides API for compilation and caching of queries for reuse.

Inheritance

System.Object

CompiledQuery

Namespace: LinqToDB

Assembly: linq2db.dll

Syntax

public class CompiledQuery : object

Constructors

| Improve this Doc View Source

CompiledQuery(LambdaExpression)

Declaration

protected CompiledQuery(LambdaExpression query)

Parameters

Type	Name	Description
LambdaExpression	query

Methods

| Improve this Doc View Source

Compile<TDC, TResult>(Expression<Func<TDC, TResult>>)

Compiles the query.

Declaration

public static Func<TDC, TResult> Compile<TDC, TResult>(Expression<Func<TDC, TResult>> query)
    where TDC : IDataContext

Parameters

Type	Name	Description
Expression<Func<TDC, TResult>>	query	The query expression to be compiled.

Returns

Type	Description
Func<TDC, TResult>	A generic delegate that represents the compiled query.

Type Parameters

Name	Description
TDC	Type of data context parameter, passed to compiled query.
TResult	Query result type.

| Improve this Doc View Source

Compile<TDC, TArg1, TResult>(Expression<Func<TDC, TArg1, TResult>>)

Compiles the query with parameter.

Declaration

public static Func<TDC, TArg1, TResult> Compile<TDC, TArg1, TResult>(Expression<Func<TDC, TArg1, TResult>> query)
    where TDC : IDataContext

Parameters

Type	Name	Description
Expression<Func<TDC, TArg1, TResult>>	query	The query expression to be compiled.

Returns

Type	Description
Func<TDC, TArg1, TResult>	A generic delegate that represents the compiled query.

Type Parameters

Name	Description
TDC	Type of data context parameter, passed to compiled query.
TArg1	Type of parameter for compiled query.
TResult	Query result type.

| Improve this Doc View Source

Compile<TDC, TArg1, TArg2, TResult>(Expression<Func<TDC, TArg1, TArg2, TResult>>)

Compiles the query with two parameters.

Declaration

public static Func<TDC, TArg1, TArg2, TResult> Compile<TDC, TArg1, TArg2, TResult>(Expression<Func<TDC, TArg1, TArg2, TResult>> query)
    where TDC : IDataContext

Parameters

Type	Name	Description
Expression<Func<TDC, TArg1, TArg2, TResult>>	query	The query expression to be compiled.

Returns

Type	Description
Func<TDC, TArg1, TArg2, TResult>	A generic delegate that represents the compiled query.

Type Parameters

Name	Description
TDC	Type of data context parameter, passed to compiled query.
TArg1	Type of first parameter for compiled query.
TArg2	Type of second parameter for compiled query.
TResult	Query result type.

| Improve this Doc View Source

Compile<TDC, TArg1, TArg2, TArg3, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TResult>>)

Compiles the query with three parameters.

Declaration

public static Func<TDC, TArg1, TArg2, TArg3, TResult> Compile<TDC, TArg1, TArg2, TArg3, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TResult>> query)
    where TDC : IDataContext

Parameters

Type	Name	Description
Expression<Func<TDC, TArg1, TArg2, TArg3, TResult>>	query	The query expression to be compiled.

Returns

Type	Description
Func<TDC, TArg1, TArg2, TArg3, TResult>	A generic delegate that represents the compiled query.

Type Parameters

Name	Description
TDC	Type of data context parameter, passed to compiled query.
TArg1	Type of first parameter for compiled query.
TArg2	Type of second parameter for compiled query.
TArg3	Type of third parameter for compiled query.
TResult	Query result type.

| Improve this Doc View Source

Compile<TDC, TArg1, TArg2, TArg3, TArg4, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult>>)

Compiles the query with four parameters.

Declaration

public static Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult> Compile<TDC, TArg1, TArg2, TArg3, TArg4, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult>> query)
    where TDC : IDataContext

Parameters

Type	Name	Description
Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult>>	query	The query expression to be compiled.

Returns

Type	Description
Func<TDC, TArg1, TArg2, TArg3, TArg4, TResult>	A generic delegate that represents the compiled query.

Type Parameters

Name	Description
TDC	Type of data context parameter, passed to compiled query.
TArg1	Type of first parameter for compiled query.
TArg2	Type of second parameter for compiled query.
TArg3	Type of third parameter for compiled query.
TArg4	Type of forth parameter for compiled query.
TResult	Query result type.

| Improve this Doc View Source

Compile<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>>)

Compiles the query with five parameters.

Declaration

public static Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult> Compile<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>(Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>> query)
    where TDC : IDataContext

Parameters

Type	Name	Description
Expression<Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>>	query	The query expression to be compiled.

Returns

Type	Description
Func<TDC, TArg1, TArg2, TArg3, TArg4, TArg5, TResult>	A generic delegate that represents the compiled query.

Type Parameters

Name	Description
TDC	Type of data context parameter, passed to compiled query.
TArg1	Type of first parameter for compiled query.
TArg2	Type of second parameter for compiled query.
TArg3	Type of third parameter for compiled query.
TArg4	Type of forth parameter for compiled query.
TArg5	Type of fifth parameter for compiled query.
TResult	Query result type.

| Improve this Doc View Source

Invoke<TDC, TResult>(TDC)

Executes compiled query against provided database connection context.

Declaration

public TResult Invoke<TDC, TResult>(TDC dataContext)

Parameters

Type	Name	Description
TDC	dataContext	Database connection context.

Returns

Type	Description
TResult	Query execution result.

Type Parameters

Name	Description
TDC	Database connection context type.
TResult	Query result type.

| Improve this Doc View Source

Invoke<TDC, T1, TResult>(TDC, T1)

Executes compiled query with one parameter against provided database connection context.

Declaration

public TResult Invoke<TDC, T1, TResult>(TDC dataContext, T1 arg1)

Parameters

Type	Name	Description
TDC	dataContext	Database connection context.
T1	arg1	Query parameter value.

Returns

Type	Description
TResult	Query execution result.

Type Parameters

Name	Description
TDC	Database connection context type.
T1	Query parameter type.
TResult	Query result type.

| Improve this Doc View Source

Invoke<TDC, T1, T2, TResult>(TDC, T1, T2)

Executes compiled query with two parameters against provided database connection context.

Declaration

public TResult Invoke<TDC, T1, T2, TResult>(TDC dataContext, T1 arg1, T2 arg2)

Parameters

Type	Name	Description
TDC	dataContext	Database connection context.
T1	arg1	First query parameter value.
T2	arg2	Second query parameter value.

Returns

Type	Description
TResult	Query execution result.

Type Parameters

Name	Description
TDC	Database connection context type.
T1	First query parameter type.
T2	Second query parameter type.
TResult	Query result type.

| Improve this Doc View Source

Invoke<TDC, T1, T2, T3, TResult>(TDC, T1, T2, T3)

Executes compiled query with three parameters against provided database connection context.

Declaration

public TResult Invoke<TDC, T1, T2, T3, TResult>(TDC dataContext, T1 arg1, T2 arg2, T3 arg3)

Parameters

Type	Name	Description
TDC	dataContext	Database connection context.
T1	arg1	First query parameter value.
T2	arg2	Second query parameter value.
T3	arg3	Third query parameter value.

Returns

Type	Description
TResult	Query execution result.

Type Parameters

Name	Description
TDC	Database connection context type.
T1	First query parameter type.
T2	Second query parameter type.
T3	Third query parameter type.
TResult	Query result type.

| Improve this Doc View Source

Invoke<TDC, T1, T2, T3, T4, TResult>(TDC, T1, T2, T3, T4)

Executes compiled query with four parameters against provided database connection context.

Declaration

public TResult Invoke<TDC, T1, T2, T3, T4, TResult>(TDC dataContext, T1 arg1, T2 arg2, T3 arg3, T4 arg4)

Parameters

Type	Name	Description
TDC	dataContext	Database connection context.
T1	arg1	First query parameter value.
T2	arg2	Second query parameter value.
T3	arg3	Third query parameter value.
T4	arg4	Forth query parameter value.

Returns

Type	Description
TResult	Query execution result.

Type Parameters

Name	Description
TDC	Database connection context type.
T1	First query parameter type.
T2	Second query parameter type.
T3	Third query parameter type.
T4	Forth query parameter type.
TResult	Query result type.

| Improve this Doc View Source

Invoke<TDC, T1, T2, T3, T4, T5, TResult>(TDC, T1, T2, T3, T4, T5)

Executes compiled query with five parameters against provided database connection context.

Declaration

public TResult Invoke<TDC, T1, T2, T3, T4, T5, TResult>(TDC dataContext, T1 arg1, T2 arg2, T3 arg3, T4 arg4, T5 arg5)

Parameters

Type	Name	Description
TDC	dataContext	Database connection context.
T1	arg1	First query parameter value.
T2	arg2	Second query parameter value.
T3	arg3	Third query parameter value.
T4	arg4	Forth query parameter value.
T5	arg5	Fifth query parameter value.

Returns

Type	Description
TResult	Query execution result.

Type Parameters

Name	Description
TDC	Database connection context type.
T1	First query parameter type.
T2	Second query parameter type.
T3	Third query parameter type.
T4	Forth query parameter type.
T5	Fifth query parameter type.
TResult	Query result type.

Extension Methods

Map.DeepCopy<T>(T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

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

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

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

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

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

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

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

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

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

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