Class LinqExtensions

Contains extension methods for LINQ queries.

Inheritance

Object

LinqExtensions

Namespace: LinqToDB

Assembly: linq2db.dll

Syntax

public static class LinqExtensions

Properties

ExtensionsAdapter

Declaration

public static IExtensionsAdapter ExtensionsAdapter { get; set; }

Property Value

Type	Description
IExtensionsAdapter

ProcessSourceQueryable

Gets or sets callback for preprocessing query before execution. Useful for intercepting queries.

Declaration

public static Func<IQueryable, IQueryable> ProcessSourceQueryable { get; set; }

Property Value

Type	Description
Func<IQueryable, IQueryable>

Methods

AsCte<TSource>(IQueryable<TSource>)

Specifies a temporary named result set, known as a common table expression (CTE).

Declaration

public static IQueryable<TSource> AsCte<TSource>(this IQueryable<TSource> source)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.

Returns

Type	Description
IQueryable<TSource>	Common table expression.

Type Parameters

Name	Description
TSource	Source query record type.

AsCte<TSource>(IQueryable<TSource>, String)

Specifies a temporary named result set, known as a common table expression (CTE).

Declaration

public static IQueryable<TSource> AsCte<TSource>(this IQueryable<TSource> source, string name)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
String	name	Common table expression name.

Returns

Type	Description
IQueryable<TSource>	Common table expression.

Type Parameters

Name	Description
TSource	Source query record type.

AsQueryable<TElement>(IEnumerable<TElement>, IDataContext)

Converts a generic IEnumerable<T> to Linq To DB query.

Declaration

public static IQueryable<TElement> AsQueryable<TElement>(this IEnumerable<TElement> source, IDataContext dataContext)

Parameters

Type	Name	Description
IEnumerable<TElement>	source	A sequence to convert.
IDataContext	dataContext	Database connection context.

Returns

Type	Description
IQueryable<TElement>	An IQueryable<T> that represents the input sequence.

Type Parameters

Name	Description
TElement	The type of the elements of source.

Exceptions

Type	Condition
ArgumentNullException	source is null.

AsSubQuery<TSource>(IQueryable<TSource>)

Defines that sub-query is mandatory for source query.

Declaration

public static IQueryable<TSource> AsSubQuery<TSource>(this IQueryable<TSource> source)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.

Returns

Type	Description
IQueryable<TSource>	Query covered in sub-query.

Type Parameters

Name	Description
TSource	Source query record type.

AsUpdatable<T>(IQueryable<T>)

Casts IQueryable<T> query to IUpdatable<T> query.

Declaration

public static IUpdatable<T> AsUpdatable<T>(this IQueryable<T> source)

Parameters

Type	Name	Description
IQueryable<T>	source	Source IQueryable<T> query.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Query record type.

CrossJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, TResult>>)

Defines cross join between two sub-queries or tables.

Declaration

public static IQueryable<TResult> CrossJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, TResult>> resultSelector)

Parameters

Type	Name	Description
IQueryable<TOuter>	outer	Left join operand.
IQueryable<TInner>	inner	Right join operand.
Expression<Func<TOuter, TInner, TResult>>	resultSelector	A function to create a result element from two matching elements.

Returns

Type	Description
IQueryable<TResult>	Right operand.

Type Parameters

Name	Description
TOuter	Type of record for left join operand.
TInner	Type of record for right join operand.
TResult	The type of the result elements.

DatabaseName<T>(ITable<T>, String)

Overrides database name with new name for current query. This call will have effect only for databases that support database name in fully-qualified table name.

Supported by: Access, DB2, MySQL, PostgreSQL, SAP HANA, SQLite, Informix, SQL Server, Sybase ASE.

Requires schema name (see SchemaName<T>(ITable<T>, String)): DB2, SAP HANA, PostgreSQL.

PostgreSQL supports only name of current database.

Declaration

public static ITable<T> DatabaseName<T>(this ITable<T> table, string name)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
String	name	Name of database.

Returns

Type	Description
ITable<T>	Table-like query source with new database name.

Type Parameters

Name	Description
T	Table record mapping class.

Delete<T>(IQueryable<T>)

Executes delete operation, using source query as filter for records, that should be deleted.

Declaration

public static int Delete<T>(this IQueryable<T> source)

Parameters

Type	Name	Description
IQueryable<T>	source	Query that returns records to delete.

Returns

Type	Description
Int32	Number of deleted records.

Type Parameters

Name	Description
T	Mapping class for delete operation target table.

Delete<T>(IQueryable<T>, Expression<Func<T, Boolean>>)

Executes delete operation, using source query as initial filter for records, that should be deleted, and predicate expression as additional filter.

Declaration

public static int Delete<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<T>	source	Query that returns records to delete.
Expression<Func<T, Boolean>>	predicate	Filter expression, to specify what records from source should be deleted.

Returns

Type	Description
Int32	Number of deleted records.

Type Parameters

Name	Description
T	Mapping class for delete operation target table.

DeleteAsync<T>(IQueryable<T>, Expression<Func<T, Boolean>>, CancellationToken)

Executes delete operation asynchronously, using source query as initial filter for records, that should be deleted, and predicate expression as additional filter.

Declaration

public static Task<int> DeleteAsync<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<T>	source	Query that returns records to delete.
Expression<Func<T, Boolean>>	predicate	Filter expression, to specify what records from source should be deleted.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of deleted records.

Type Parameters

Name	Description
T	Mapping class for delete operation target table.

DeleteAsync<T>(IQueryable<T>, CancellationToken)

Executes delete operation asynchronously, using source query as filter for records, that should be deleted.

Declaration

public static Task<int> DeleteAsync<T>(this IQueryable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<T>	source	Query that returns records to delete.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of deleted records.

Type Parameters

Name	Description
T	Mapping class for delete operation target table.

Drop<T>(ITable<T>, Boolean)

Drops database table.

Declaration

public static int Drop<T>(this ITable<T> target, bool throwExceptionIfNotExists = true)

Parameters

Type	Name	Description
ITable<T>	target	Dropped table.
Boolean	throwExceptionIfNotExists	If false, any exception during drop operation will be silently catched and 0 returned. This behavior is not correct and will be fixed in future to mask only missing table exceptions. Tracked by issue. Default value: true.

Returns

Type	Description
Int32	Number of affected records. Usually -1 as it is not data modification operation.

Type Parameters

Name	Description
T	Table record type.

DropAsync<T>(ITable<T>, Boolean, CancellationToken)

Drops database table asynchronously.

Declaration

public static Task<int> DropAsync<T>(this ITable<T> target, bool throwExceptionIfNotExists = true, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Dropped table.
Boolean	throwExceptionIfNotExists	If false, any exception during drop operation will be silently catched and 0 returned. This behavior is not correct and will be fixed in future to mask only missing table exceptions. Tracked by issue. Default value: true.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records. Usually -1 as it is not data modification operation.

Type Parameters

Name	Description
T	Table record type.

ElementAt<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)

Selects record at specified position from source query. If query doesn't return enough records, InvalidOperationException will be thrown.

Declaration

public static TSource ElementAt<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	index	Expression that defines index of record to select.

Returns

Type	Description
TSource	Record at specified position.

Type Parameters

Name	Description
TSource	Source table record type.

Exceptions

Type	Condition
InvalidOperationException	Source query doesn't have record with specified index.

ElementAtAsync<TSource>(IQueryable<TSource>, Expression<Func<Int32>>, CancellationToken)

Selects record at specified position from source query asynchronously. If query doesn't return enough records, InvalidOperationException will be thrown.

Declaration

public static Task<TSource> ElementAtAsync<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	index	Expression that defines index of record to select.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<TSource>	Record at specified position.

Type Parameters

Name	Description
TSource	Source table record type.

Exceptions

Type	Condition
InvalidOperationException	Source query doesn't have record with specified index.

ElementAtOrDefault<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)

Selects record at specified position from source query.

Declaration

public static TSource ElementAtOrDefault<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	index	Expression that defines index of record to select.

Returns

Type	Description
TSource	Record at specified position or default value, if source query doesn't have record with such index.

Type Parameters

Name	Description
TSource	Source table record type.

ElementAtOrDefaultAsync<TSource>(IQueryable<TSource>, Expression<Func<Int32>>, CancellationToken)

Selects record at specified position from source query asynchronously.

Declaration

public static Task<TSource> ElementAtOrDefaultAsync<TSource>(this IQueryable<TSource> source, Expression<Func<int>> index, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	index	Expression that defines index of record to select.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<TSource>	Record at specified position or default value, if source query doesn't have record with such index.

Type Parameters

Name	Description
TSource	Source table record type.

ExceptAll<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

Produces the set difference of two sequences.

Declaration

public static IQueryable<TSource> ExceptAll<TSource>(this IQueryable<TSource> source1, IEnumerable<TSource> source2)

Parameters

Type	Name	Description
IQueryable<TSource>	source1	An IQueryable<T> whose elements that are not also in source2 will be returned.
IEnumerable<TSource>	source2	An IEnumerable<T> whose elements that also occur in the first sequence will not appear in the returned sequence.

Returns

Type	Description
IQueryable<TSource>	An IQueryable<T> that contains the set difference of the two sequences.

Type Parameters

Name	Description
TSource	The type of the elements of the input sequences.

Exceptions

Type	Condition
ArgumentNullException	source1 or source2 is null.

FullJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>)

Defines full outer join between two sub-queries or tables.

Declaration

public static IQueryable<TSource> FullJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Right join operand.
Expression<Func<TSource, Boolean>>	predicate	Join predicate.

Returns

Type	Description
IQueryable<TSource>	Right operand.

Type Parameters

Name	Description
TSource	Type of record for right join operand.

FullJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, Boolean>>, Expression<Func<TOuter, TInner, TResult>>)

Defines full outer join between two sub-queries or tables.

Declaration

public static IQueryable<TResult> FullJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)

Parameters

Type	Name	Description
IQueryable<TOuter>	outer	Left join operand.
IQueryable<TInner>	inner	Right join operand.
Expression<Func<TOuter, TInner, Boolean>>	predicate	Join predicate.
Expression<Func<TOuter, TInner, TResult>>	resultSelector	A function to create a result element from two matching elements.

Returns

Type	Description
IQueryable<TResult>	Right operand.

Type Parameters

Name	Description
TOuter	Type of record for left join operand.
TInner	Type of record for right join operand.
TResult	The type of the result elements.

GenerateTestString(IQueryable, Boolean)

Generates test source code for specified query. This method could be usefull to debug queries and attach test code to linq2db issue reports.

Declaration

public static string GenerateTestString(this IQueryable query, bool mangleNames = false)

Parameters

Type	Name	Description
IQueryable	query	Query to test.
Boolean	mangleNames	Should we use real names for used types, members and namespace or generate obfuscated names.

Returns

Type	Description
String	Test source code.

HasUniqueKey<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>)

Records unique key for IQueryable. It allows sub-query to be optimized out in LEFT JOIN if columns from sub-query are not used in final projection and predicate.

Declaration

public static IQueryable<TSource> HasUniqueKey<TSource, TKey>(this IQueryable<TSource> source, Expression<Func<TSource, TKey>> keySelector)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.
Expression<Func<TSource, TKey>>	keySelector	A function to specify which fields are unique.

Returns

Type	Description
IQueryable<TSource>	Query covered in sub-query.

Type Parameters

Name	Description
TSource	Source query record type.
TKey	Key type.

Having<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>)

Filters source query using HAVING SQL clause. In general you don't need to use this method as linq2db is able to propely identify current context for Where<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>) method and generate HAVING clause. More details.

Declaration

public static IQueryable<TSource> Having<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query to filter.
Expression<Func<TSource, Boolean>>	predicate	Filtering expression.

Returns

Type	Description
IQueryable<TSource>	Filtered query.

Type Parameters

Name	Description
TSource	Source query record type.

InnerJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>)

Defines inner join between two sub-queries or tables.

Declaration

public static IQueryable<TSource> InnerJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Right join operand.
Expression<Func<TSource, Boolean>>	predicate	Join predicate.

Returns

Type	Description
IQueryable<TSource>	Right operand.

Type Parameters

Name	Description
TSource	Type of record for right join operand.

InnerJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, Boolean>>, Expression<Func<TOuter, TInner, TResult>>)

Defines inner or outer join between two sub-queries or tables.

Declaration

public static IQueryable<TResult> InnerJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)

Parameters

Type	Name	Description
IQueryable<TOuter>	outer	Left join operand.
IQueryable<TInner>	inner	Right join operand.
Expression<Func<TOuter, TInner, Boolean>>	predicate	Join predicate.
Expression<Func<TOuter, TInner, TResult>>	resultSelector	A function to create a result element from two matching elements.

Returns

Type	Description
IQueryable<TResult>	Right operand.

Type Parameters

Name	Description
TOuter	Type of record for left join operand.
TInner	Type of record for right join operand.
TResult	The type of the result elements.

Insert<T>(ITable<T>, Expression<Func<T>>)

Inserts single record into target table.

Declaration

public static int Insert<T>(this ITable<T> target, Expression<Func<T>> setter)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Number of affected records.

Type Parameters

Name	Description
T	Inserted record type.

Insert<T>(IValueInsertable<T>)

Executes insert query.

Declaration

public static int Insert<T>(this IValueInsertable<T> source)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.

Returns

Type	Description
Int32	Number of affected records.

Type Parameters

Name	Description
T	Target table record type.

Insert<TSource, TTarget>(ISelectInsertable<TSource, TTarget>)

Executes configured insert query.

Declaration

public static int Insert<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.

Returns

Type	Description
Int32	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

Insert<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

Inserts records from source query into target table.

Declaration

public static int Insert<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

Inserts single record into target table asynchronously.

Declaration

public static Task<int> InsertAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records.

Type Parameters

Name	Description
T	Inserted record type.

InsertAsync<T>(IValueInsertable<T>, CancellationToken)

Executes insert query asynchronously.

Declaration

public static Task<int> InsertAsync<T>(this IValueInsertable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records.

Type Parameters

Name	Description
T	Target table record type.

InsertAsync<TSource, TTarget>(ISelectInsertable<TSource, TTarget>, CancellationToken)

Executes configured insert query asynchronously.

Declaration

public static Task<int> InsertAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

Inserts records from source query into target table asynchronously.

Declaration

public static Task<int> InsertAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertOrUpdate<T>(ITable<T>, Expression<Func<T>>, Expression<Func<T, T>>)

Inserts new record into target table or updates existing record if record with the same primary key value already exists in target table.

Declaration

public static int InsertOrUpdate<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	insertSetter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
Expression<Func<T, T>>	onDuplicateKeyUpdateSetter	Updated record constructor expression. Expression supports only target table record new expression with field initializers. Accepts updated record as parameter.

Returns

Type	Description
Int32	Number of affected records.

Type Parameters

Name	Description
T	Table record type.

InsertOrUpdate<T>(ITable<T>, Expression<Func<T>>, Expression<Func<T, T>>, Expression<Func<T>>)

Inserts new record into target table or updates existing record if record with the same key value already exists in target table.

Declaration

public static int InsertOrUpdate<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter, Expression<Func<T>> keySelector)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	insertSetter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
Expression<Func<T, T>>	onDuplicateKeyUpdateSetter	Updated record constructor expression. Expression supports only target table record new expression with field initializers. Accepts updated record as parameter.
Expression<Func<T>>	keySelector	Key fields selector to specify what fields and values must be used as key fields for selection between insert and update operations. Expression supports only target table record new expression with field initializers for each key field. Assigned key field value will be used as key value by operation type selector.

Returns

Type	Description
Int32	Number of affected records.

Type Parameters

Name	Description
T	Table record type.

InsertOrUpdateAsync<T>(ITable<T>, Expression<Func<T>>, Expression<Func<T, T>>, Expression<Func<T>>, CancellationToken)

Asynchronously inserts new record into target table or updates existing record if record with the same key value already exists in target table.

Declaration

public static Task<int> InsertOrUpdateAsync<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter, Expression<Func<T>> keySelector, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	insertSetter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
Expression<Func<T, T>>	onDuplicateKeyUpdateSetter	Updated record constructor expression. Expression supports only target table record new expression with field initializers. Accepts updated record as parameter.
Expression<Func<T>>	keySelector	Key fields selector to specify what fields and values must be used as key fields for selection between insert and update operations. Expression supports only target table record new expression with field initializers for each key field. Assigned key field value will be used as key value by operation type selector.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records.

Type Parameters

Name	Description
T	Table record type.

InsertOrUpdateAsync<T>(ITable<T>, Expression<Func<T>>, Expression<Func<T, T>>, CancellationToken)

Asynchronously inserts new record into target table or updates existing record if record with the same primary key value already exists in target table.

Declaration

public static Task<int> InsertOrUpdateAsync<T>(this ITable<T> target, Expression<Func<T>> insertSetter, Expression<Func<T, T>> onDuplicateKeyUpdateSetter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	insertSetter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
Expression<Func<T, T>>	onDuplicateKeyUpdateSetter	Updated record constructor expression. Expression supports only target table record new expression with field initializers. Accepts updated record as parameter.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records.

Type Parameters

Name	Description
T	Table record type.

InsertWithDecimalIdentity<T>(ITable<T>, Expression<Func<T>>)

Inserts single record into target table and returns identity value of inserted record as Decimal value.

Declaration

public static decimal InsertWithDecimalIdentity<T>(this ITable<T> target, Expression<Func<T>> setter)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Decimal	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithDecimalIdentity<T>(IValueInsertable<T>)

Executes insert query and returns identity value of inserted record as Decimal value.

Declaration

public static decimal? InsertWithDecimalIdentity<T>(this IValueInsertable<T> source)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.

Returns

Type	Description
Nullable<Decimal>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithDecimalIdentity<TSource, TTarget>(ISelectInsertable<TSource, TTarget>)

Executes configured insert query and returns identity value of last inserted record as Decimal value.

Declaration

public static decimal? InsertWithDecimalIdentity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.

Returns

Type	Description
Nullable<Decimal>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithDecimalIdentity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

Inserts records from source query into target table and returns identity value of last inserted record as Decimal value.

Declaration

public static decimal? InsertWithDecimalIdentity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Nullable<Decimal>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithDecimalIdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

Inserts single record into target table asynchronously and returns identity value of inserted record as Decimal value.

Declaration

public static Task<decimal> InsertWithDecimalIdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Decimal>	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithDecimalIdentityAsync<T>(IValueInsertable<T>, CancellationToken)

Executes insert query asynchronously and returns identity value of inserted record as Decimal value.

Declaration

public static Task<decimal? > InsertWithDecimalIdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Decimal>>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithDecimalIdentityAsync<TSource, TTarget>(ISelectInsertable<TSource, TTarget>, CancellationToken)

Executes configured insert query asynchronously and returns identity value of last inserted record as Decimal value.

Declaration

public static Task<decimal? > InsertWithDecimalIdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Decimal>>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithDecimalIdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

Inserts records from source query into target table asynchronously and returns identity value of last inserted record as Decimal value.

Declaration

public static Task<decimal? > InsertWithDecimalIdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Decimal>>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithIdentity<T>(ITable<T>, Expression<Func<T>>)

Inserts single record into target table and returns identity value of inserted record.

Declaration

public static object InsertWithIdentity<T>(this ITable<T> target, Expression<Func<T>> setter)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Object	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithIdentity<T>(IValueInsertable<T>)

Executes insert query and returns identity value of inserted record.

Declaration

public static object InsertWithIdentity<T>(this IValueInsertable<T> source)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.

Returns

Type	Description
Object	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithIdentity<TSource, TTarget>(ISelectInsertable<TSource, TTarget>)

Executes configured insert query and returns identity value of last inserted record.

Declaration

public static object InsertWithIdentity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.

Returns

Type	Description
Object	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithIdentity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

Inserts records from source query into target table and returns identity value of last inserted record.

Declaration

public static object InsertWithIdentity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Object	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithIdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

Inserts single record into target table asynchronously and returns identity value of inserted record.

Declaration

public static Task<object> InsertWithIdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Object>	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithIdentityAsync<T>(IValueInsertable<T>, CancellationToken)

Executes insert query asynchronously and returns identity value of inserted record.

Declaration

public static Task<object> InsertWithIdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Object>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithIdentityAsync<TSource, TTarget>(ISelectInsertable<TSource, TTarget>, CancellationToken)

Executes configured insert query asynchronously and returns identity value of last inserted record.

Declaration

public static Task<object> InsertWithIdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Object>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithIdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

Inserts records from source query into target table asynchronously and returns identity value of last inserted record.

Declaration

public static Task<object> InsertWithIdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Object>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithInt32Identity<T>(ITable<T>, Expression<Func<T>>)

Inserts single record into target table and returns identity value of inserted record as Int32 value.

Declaration

public static int InsertWithInt32Identity<T>(this ITable<T> target, Expression<Func<T>> setter)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithInt32Identity<T>(IValueInsertable<T>)

Executes insert query and returns identity value of inserted record as Int32 value.

Declaration

public static int? InsertWithInt32Identity<T>(this IValueInsertable<T> source)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.

Returns

Type	Description
Nullable<Int32>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithInt32Identity<TSource, TTarget>(ISelectInsertable<TSource, TTarget>)

Executes configured insert query and returns identity value of last inserted record as Int32 value.

Declaration

public static int? InsertWithInt32Identity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.

Returns

Type	Description
Nullable<Int32>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithInt32Identity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

Inserts records from source query into target table and returns identity value of last inserted record as Int32 value.

Declaration

public static int? InsertWithInt32Identity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Nullable<Int32>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithInt32IdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

Inserts single record into target table asynchronously and returns identity value of inserted record as Int32 value.

Declaration

public static Task<int> InsertWithInt32IdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithInt32IdentityAsync<T>(IValueInsertable<T>, CancellationToken)

Executes insert query asynchronously and returns identity value of inserted record as Int32 value.

Declaration

public static Task<int? > InsertWithInt32IdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Int32>>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithInt32IdentityAsync<TSource, TTarget>(ISelectInsertable<TSource, TTarget>, CancellationToken)

Executes configured insert query asynchronously and returns identity value of last inserted record as Int32 value.

Declaration

public static Task<int? > InsertWithInt32IdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Int32>>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithInt32IdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

Inserts records from source query into target table asynchronously and returns identity value of last inserted record as Int32 value.

Declaration

public static Task<int? > InsertWithInt32IdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Int32>>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithInt64Identity<T>(ITable<T>, Expression<Func<T>>)

Inserts single record into target table and returns identity value of inserted record as Int64 value.

Declaration

public static long InsertWithInt64Identity<T>(this ITable<T> target, Expression<Func<T>> setter)

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int64	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithInt64Identity<T>(IValueInsertable<T>)

Executes insert query and returns identity value of inserted record as Int64 value.

Declaration

public static long? InsertWithInt64Identity<T>(this IValueInsertable<T> source)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.

Returns

Type	Description
Nullable<Int64>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithInt64Identity<TSource, TTarget>(ISelectInsertable<TSource, TTarget>)

Executes configured insert query and returns identity value of last inserted record as Int64 value.

Declaration

public static long? InsertWithInt64Identity<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.

Returns

Type	Description
Nullable<Int64>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithInt64Identity<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

Inserts records from source query into target table and returns identity value of last inserted record as Int64 value.

Declaration

public static long? InsertWithInt64Identity<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Nullable<Int64>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

InsertWithInt64IdentityAsync<T>(ITable<T>, Expression<Func<T>>, CancellationToken)

Inserts single record into target table asynchronously and returns identity value of inserted record as Int64 value.

Declaration

public static Task<long> InsertWithInt64IdentityAsync<T>(this ITable<T> target, Expression<Func<T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Target table.
Expression<Func<T>>	setter	Insert expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int64>	Inserted record's identity value.

Type Parameters

Name	Description
T	Inserted record type.

InsertWithInt64IdentityAsync<T>(IValueInsertable<T>, CancellationToken)

Executes insert query asynchronously and returns identity value of inserted record as Int64 value.

Declaration

public static Task<long? > InsertWithInt64IdentityAsync<T>(this IValueInsertable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Int64>>	Inserted record's identity value.

Type Parameters

Name	Description
T	Target table record type.

InsertWithInt64IdentityAsync<TSource, TTarget>(ISelectInsertable<TSource, TTarget>, CancellationToken)

Executes configured insert query asynchronously and returns identity value of last inserted record as Int64 value.

Declaration

public static Task<long? > InsertWithInt64IdentityAsync<TSource, TTarget>(this ISelectInsertable<TSource, TTarget> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Int64>>	Number of affected records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type.

InsertWithInt64IdentityAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

Inserts records from source query into target table asynchronously and returns identity value of last inserted record as Int64 value.

Declaration

public static Task<long? > InsertWithInt64IdentityAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query, that returns data for insert operation.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Inserted record constructor expression. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Nullable<Int64>>	Last inserted record's identity value.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table record type

IntersectAll<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

Produces the set intersection of two sequences.

Declaration

public static IQueryable<TSource> IntersectAll<TSource>(this IQueryable<TSource> source1, IEnumerable<TSource> source2)

Parameters

Type	Name	Description
IQueryable<TSource>	source1	A sequence whose elements that also appear in source2 are returned.
IEnumerable<TSource>	source2	A sequence whose elements that also appear in the first sequence are returned.

Returns

Type	Description
IQueryable<TSource>	A sequence that contains the set intersection of the two sequences.

Type Parameters

Name	Description
TSource	The type of the elements of the input sequences.

Exceptions

Type	Condition
ArgumentNullException	source1 or source2 is null.

Into<T>(IDataContext, ITable<T>)

Starts insert operation LINQ query definition.

Declaration

public static IValueInsertable<T> Into<T>(this IDataContext dataContext, ITable<T> target)

Parameters

Type	Name	Description
IDataContext	dataContext	Database connection context.
ITable<T>	target	Target table.

Returns

Type	Description
IValueInsertable<T>	Insertable source query.

Type Parameters

Name	Description
T	Target table mapping class.

Into<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>)

Converts LINQ query into insert query with source query data as data to insert.

Declaration

public static ISelectInsertable<TSource, TTarget> Into<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.
ITable<TTarget>	target	Target table.

Returns

Type	Description
ISelectInsertable<TSource, TTarget>	Insertable source query.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table mapping class.

Join<TSource>(IQueryable<TSource>, SqlJoinType, Expression<Func<TSource, Boolean>>)

Defines inner or outer join between two sub-queries or tables.

Declaration

public static IQueryable<TSource> Join<TSource>(this IQueryable<TSource> source, SqlJoinType joinType, Expression<Func<TSource, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Right join operand.
SqlJoinType	joinType	Type of join.
Expression<Func<TSource, Boolean>>	predicate	Join predicate.

Returns

Type	Description
IQueryable<TSource>	Right operand.

Type Parameters

Name	Description
TSource	Type of record for right join operand.

Join<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, SqlJoinType, Expression<Func<TOuter, TInner, Boolean>>, Expression<Func<TOuter, TInner, TResult>>)

Defines inner or outer join between two sub-queries or tables.

Declaration

public static IQueryable<TResult> Join<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, SqlJoinType joinType, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)

Parameters

Type	Name	Description
IQueryable<TOuter>	outer	Left join operand.
IQueryable<TInner>	inner	Right join operand.
SqlJoinType	joinType	Type of join.
Expression<Func<TOuter, TInner, Boolean>>	predicate	Join predicate.
Expression<Func<TOuter, TInner, TResult>>	resultSelector	A function to create a result element from two matching elements.

Returns

Type	Description
IQueryable<TResult>	Right operand.

Type Parameters

Name	Description
TOuter	Type of record for left join operand.
TInner	Type of record for right join operand.
TResult	The type of the result elements.

LeftJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>)

Defines left outer join between two sub-queries or tables.

Declaration

public static IQueryable<TSource> LeftJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Right join operand.
Expression<Func<TSource, Boolean>>	predicate	Join predicate.

Returns

Type	Description
IQueryable<TSource>	Right operand.

Type Parameters

Name	Description
TSource	Type of record for right join operand.

LeftJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, Boolean>>, Expression<Func<TOuter, TInner, TResult>>)

Defines left outer join between two sub-queries or tables.

Declaration

public static IQueryable<TResult> LeftJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)

Parameters

Type	Name	Description
IQueryable<TOuter>	outer	Left join operand.
IQueryable<TInner>	inner	Right join operand.
Expression<Func<TOuter, TInner, Boolean>>	predicate	Join predicate.
Expression<Func<TOuter, TInner, TResult>>	resultSelector	A function to create a result element from two matching elements.

Returns

Type	Description
IQueryable<TResult>	Right operand.

Type Parameters

Name	Description
TOuter	Type of record for left join operand.
TInner	Type of record for right join operand.
TResult	The type of the result elements.

LoadWith<T>(ITable<T>, Expression<Func<T, Object>>)

Specifies associations, that should be loaded for each loaded record from current table. All associations, specified in selector expression, will be loaded. Take into account that use of this method could require multiple queries to load all requested associations. Some usage examples:

// loads records from Table1 with Reference association loaded for each Table1 record
db.Table1.LoadWith(r => r.Reference);

// loads records from Table1 with Reference1 association loaded for each Table1 record
// loads records from Reference2 association for each loaded Reference1 record
db.Table1.LoadWith(r => r.Reference1.Reference2);

// loads records from Table1 with References collection association loaded for each Table1 record
db.Table1.LoadWith(r => r.References);

// loads records from Table1 with Reference1 collection association loaded for each Table1 record
// loads records from Reference2 collection association for each loaded Reference1 record
// loads records from Reference3 association for each loaded Reference2 record
// note that a way you access collection association record (by index, using First() method) doesn't affect
// query results and allways select all records
db.Table1.LoadWith(r => r.References1[0].References2.First().Reference3);

Declaration

public static ITable<T> LoadWith<T>(this ITable<T> table, Expression<Func<T, object>> selector)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
Expression<Func<T, Object>>	selector	Association selection expression.

Returns

Type	Description
ITable<T>	Table-like query source.

Type Parameters

Name	Description
T	Table record mapping class.

OwnerName<T>(ITable<T>, String)

Overrides owner/schema name with new name for current query. This call will have effect only for databases that support owner/schema name in fully-qualified table name. SchemaName<T>(ITable<T>, String) method is a synonym of this method.

Supported by: DB2, Oracle, PostgreSQL, SAP HANA, Informix, SQL Server, Sybase ASE.

Declaration

[Obsolete("Use SchemaName instead.")]
public static ITable<T> OwnerName<T>(this ITable<T> table, string name)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
String	name	Name of owner/schema.

Returns

Type	Description
ITable<T>	Table-like query source with new owner/schema name.

Type Parameters

Name	Description
T	Table record mapping class.

RightJoin<TSource>(IQueryable<TSource>, Expression<Func<TSource, Boolean>>)

Defines right outer join between two sub-queries or tables.

Declaration

public static IQueryable<TSource> RightJoin<TSource>(this IQueryable<TSource> source, Expression<Func<TSource, bool>> predicate)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Right join operand.
Expression<Func<TSource, Boolean>>	predicate	Join predicate.

Returns

Type	Description
IQueryable<TSource>	Right operand.

Type Parameters

Name	Description
TSource	Type of record for right join operand.

RightJoin<TOuter, TInner, TResult>(IQueryable<TOuter>, IQueryable<TInner>, Expression<Func<TOuter, TInner, Boolean>>, Expression<Func<TOuter, TInner, TResult>>)

Defines right outer join between two sub-queries or tables.

Declaration

public static IQueryable<TResult> RightJoin<TOuter, TInner, TResult>(this IQueryable<TOuter> outer, IQueryable<TInner> inner, Expression<Func<TOuter, TInner, bool>> predicate, Expression<Func<TOuter, TInner, TResult>> resultSelector)

Parameters

Type	Name	Description
IQueryable<TOuter>	outer	Left join operand.
IQueryable<TInner>	inner	Right join operand.
Expression<Func<TOuter, TInner, Boolean>>	predicate	Join predicate.
Expression<Func<TOuter, TInner, TResult>>	resultSelector	A function to create a result element from two matching elements.

Returns

Type	Description
IQueryable<TResult>	Right operand.

Type Parameters

Name	Description
TOuter	Type of record for left join operand.
TInner	Type of record for right join operand.
TResult	The type of the result elements.

SchemaName<T>(ITable<T>, String)

Overrides owner/schema name with new name for current query. This call will have effect only for databases that support owner/schema name in fully-qualified table name.

Supported by: DB2, Oracle, PostgreSQL, SAP HANA, Informix, SQL Server, Sybase ASE.

Declaration

public static ITable<T> SchemaName<T>(this ITable<T> table, string name)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
String	name	Name of owner/schema.

Returns

Type	Description
ITable<T>	Table-like query source with new owner/schema name.

Type Parameters

Name	Description
T	Table record mapping class.

Select<T>(IDataContext, Expression<Func<T>>)

Loads scalar value or record from database without explicit table source. Could be usefull for function calls, querying of database variables or properties, subqueries, execution of code on server side.

Declaration

public static T Select<T>(this IDataContext dataContext, Expression<Func<T>> selector)

Parameters

Type	Name	Description
IDataContext	dataContext	Database connection context.
Expression<Func<T>>	selector	Value selection expression.

Returns

Type	Description
T	Requested value.

Type Parameters

Name	Description
T	Type of result.

SelectAsync<T>(IDataContext, Expression<Func<T>>)

Loads scalar value or record from database without explicit table source asynchronously. Could be usefull for function calls, querying of database variables or properties, subqueries, execution of code on server side.

Declaration

public static Task<T> SelectAsync<T>(this IDataContext dataContext, Expression<Func<T>> selector)

Parameters

Type	Name	Description
IDataContext	dataContext	Database connection context.
Expression<Func<T>>	selector	Value selection expression.

Returns

Type	Description
Task<T>	Requested value.

Type Parameters

Name	Description
T	Type of result.

Set<T, TV>(IUpdatable<T>, Expression<Func<T, TV>>, TV)

Adds update field expression to query.

Declaration

public static IUpdatable<T> Set<T, TV>(this IUpdatable<T> source, Expression<Func<T, TV>> extract, TV value)

Parameters

Type	Name	Description
IUpdatable<T>	source	Source query with records to update.
Expression<Func<T, TV>>	extract	Updated field selector expression.
TV	value	Value, assigned to updated field.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Updated record type.
TV	Updated field type.

Set<T, TV>(IUpdatable<T>, Expression<Func<T, TV>>, Expression<Func<T, TV>>)

Adds update field expression to query.

Declaration

public static IUpdatable<T> Set<T, TV>(this IUpdatable<T> source, Expression<Func<T, TV>> extract, Expression<Func<T, TV>> update)

Parameters

Type	Name	Description
IUpdatable<T>	source	Source query with records to update.
Expression<Func<T, TV>>	extract	Updated field selector expression.
Expression<Func<T, TV>>	update	Updated field setter expression. Uses updated record as parameter.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Updated record type.
TV	Updated field type.

Set<T, TV>(IUpdatable<T>, Expression<Func<T, TV>>, Expression<Func<TV>>)

Adds update field expression to query.

Declaration

public static IUpdatable<T> Set<T, TV>(this IUpdatable<T> source, Expression<Func<T, TV>> extract, Expression<Func<TV>> update)

Parameters

Type	Name	Description
IUpdatable<T>	source	Source query with records to update.
Expression<Func<T, TV>>	extract	Updated field selector expression.
Expression<Func<TV>>	update	Updated field setter expression.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Updated record type.
TV	Updated field type.

Set<T, TV>(IQueryable<T>, Expression<Func<T, TV>>, TV)

Adds update field expression to query.

Declaration

public static IUpdatable<T> Set<T, TV>(this IQueryable<T> source, Expression<Func<T, TV>> extract, TV value)

Parameters

Type	Name	Description
IQueryable<T>	source	Source query with records to update.
Expression<Func<T, TV>>	extract	Updated field selector expression.
TV	value	Value, assigned to updated field.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Updated record type.
TV	Updated field type.

Set<T, TV>(IQueryable<T>, Expression<Func<T, TV>>, Expression<Func<T, TV>>)

Adds update field expression to query.

Declaration

public static IUpdatable<T> Set<T, TV>(this IQueryable<T> source, Expression<Func<T, TV>> extract, Expression<Func<T, TV>> update)

Parameters

Type	Name	Description
IQueryable<T>	source	Source query with records to update.
Expression<Func<T, TV>>	extract	Updated field selector expression.
Expression<Func<T, TV>>	update	Updated field setter expression. Uses updated record as parameter.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Updated record type.
TV	Updated field type.

Set<T, TV>(IQueryable<T>, Expression<Func<T, TV>>, Expression<Func<TV>>)

Adds update field expression to query.

Declaration

public static IUpdatable<T> Set<T, TV>(this IQueryable<T> source, Expression<Func<T, TV>> extract, Expression<Func<TV>> update)

Parameters

Type	Name	Description
IQueryable<T>	source	Source query with records to update.
Expression<Func<T, TV>>	extract	Updated field selector expression.
Expression<Func<TV>>	update	Updated field setter expression.

Returns

Type	Description
IUpdatable<T>	IUpdatable<T> query.

Type Parameters

Name	Description
T	Updated record type.
TV	Updated field type.

Skip<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)

Ignores first N records from source query.

Declaration

public static IQueryable<TSource> Skip<TSource>(this IQueryable<TSource> source, Expression<Func<int>> count)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	count	Expression that defines number of records to skip.

Returns

Type	Description
IQueryable<TSource>	Query without skipped records.

Type Parameters

Name	Description
TSource	Source table record type.

TableName<T>(ITable<T>, String)

Overrides table or view name with new name for current query.

Declaration

public static ITable<T> TableName<T>(this ITable<T> table, string name)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
String	name	Name of table.

Returns

Type	Description
ITable<T>	Table-like query source with new name.

Type Parameters

Name	Description
T	Table record mapping class.

Take<TSource>(IQueryable<TSource>, Int32, TakeHints)

Limits number of records, returned from query. Allows to specify TAKE clause hints. Using this method may cause runtime LinqException if take hints are not supported by database.

Declaration

public static IQueryable<TSource> Take<TSource>(this IQueryable<TSource> source, int count, TakeHints hints)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Int32	count	SQL TAKE parameter value.
TakeHints	hints	TakeHints hints for SQL TAKE clause.

Returns

Type	Description
IQueryable<TSource>	Query with limit applied.

Type Parameters

Name	Description
TSource	Source table record type.

Take<TSource>(IQueryable<TSource>, Expression<Func<Int32>>)

Limits number of records, returned from query.

Declaration

public static IQueryable<TSource> Take<TSource>(this IQueryable<TSource> source, Expression<Func<int>> count)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	count	Expression that defines number of records to select.

Returns

Type	Description
IQueryable<TSource>	Query with limit applied.

Type Parameters

Name	Description
TSource	Source table record type.

Take<TSource>(IQueryable<TSource>, Expression<Func<Int32>>, TakeHints)

Limits number of records, returned from query. Allows to specify TAKE clause hints. Using this method may cause runtime LinqException if take hints are not supported by database.

Declaration

public static IQueryable<TSource> Take<TSource>(this IQueryable<TSource> source, Expression<Func<int>> count, TakeHints hints)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<Int32>>	count	Expression that defines SQL TAKE parameter value.
TakeHints	hints	TakeHints hints for SQL TAKE clause.

Returns

Type	Description
IQueryable<TSource>	Query with limit applied.

Type Parameters

Name	Description
TSource	Source table record type.

ThenOrBy<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>)

Adds ascending sort expression to a query. If query already sorted, existing sorting will be preserved and updated with new sort.

Declaration

public static IOrderedQueryable<TSource> ThenOrBy<TSource, TKey>(this IQueryable<TSource> source, Expression<Func<TSource, TKey>> keySelector)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<TSource, TKey>>	keySelector	Sort expression selector.

Returns

Type	Description
IOrderedQueryable<TSource>	Sorted query.

Type Parameters

Name	Description
TSource	Source query record type.
TKey	Sort expression type.

ThenOrByDescending<TSource, TKey>(IQueryable<TSource>, Expression<Func<TSource, TKey>>)

Adds descending sort expression to a query. If query already sorted, existing sorting will be preserved and updated with new sort.

Declaration

public static IOrderedQueryable<TSource> ThenOrByDescending<TSource, TKey>(this IQueryable<TSource> source, Expression<Func<TSource, TKey>> keySelector)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source query.
Expression<Func<TSource, TKey>>	keySelector	Sort expression selector.

Returns

Type	Description
IOrderedQueryable<TSource>	Sorted query.

Type Parameters

Name	Description
TSource	Source query record type.
TKey	Sort expression type.

Truncate<T>(ITable<T>, Boolean)

Truncates database table.

Declaration

public static int Truncate<T>(this ITable<T> target, bool resetIdentity = true)

Parameters

Type	Name	Description
ITable<T>	target	Truncated table.
Boolean	resetIdentity	Performs reset identity column.

Returns

Type	Description
Int32	Number of affected records. Usually -1 as it is not data modification operation.

Type Parameters

Name	Description
T	Table record type.

TruncateAsync<T>(ITable<T>, Boolean, CancellationToken)

Truncates database table asynchronously.

Declaration

public static Task<int> TruncateAsync<T>(this ITable<T> target, bool resetIdentity = true, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
ITable<T>	target	Truncated table.
Boolean	resetIdentity	Performs reset identity column.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of affected records. Usually -1 as it is not data modification operation.

Type Parameters

Name	Description
T	Table record type.

UnionAll<TSource>(IQueryable<TSource>, IEnumerable<TSource>)

Concatenates two sequences, similar to Concat<TSource>(IQueryable<TSource>, IEnumerable<TSource>).

Declaration

public static IQueryable<TSource> UnionAll<TSource>(this IQueryable<TSource> source1, IEnumerable<TSource> source2)

Parameters

Type	Name	Description
IQueryable<TSource>	source1	The first sequence to concatenate.
IEnumerable<TSource>	source2	The sequence to concatenate to the first sequence.

Returns

Type	Description
IQueryable<TSource>	An IQueryable<T> that contains the concatenated elements of the two input sequences.

Type Parameters

Name	Description
TSource	The type of the elements of the input sequences.

Exceptions

Type	Condition
ArgumentNullException	source1 or source2 is null.

Update<T>(IUpdatable<T>)

Executes update operation for already configured update query.

Declaration

public static int Update<T>(this IUpdatable<T> source)

Parameters

Type	Name	Description
IUpdatable<T>	source	Update query.

Returns

Type	Description
Int32	Number of updated records.

Type Parameters

Name	Description
T	Updated table record type.

Update<T>(IQueryable<T>, Expression<Func<T, T>>)

Executes update operation using source query as record filter.

Declaration

public static int Update<T>(this IQueryable<T> source, Expression<Func<T, T>> setter)

Parameters

Type	Name	Description
IQueryable<T>	source	Source data query.
Expression<Func<T, T>>	setter	Update expression. Uses updated record as parameter. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Number of updated records.

Type Parameters

Name	Description
T	Updated table record type.

Update<T>(IQueryable<T>, Expression<Func<T, Boolean>>, Expression<Func<T, T>>)

Executes update operation using source query as record filter with additional filter expression.

Declaration

public static int Update<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate, Expression<Func<T, T>> setter)

Parameters

Type	Name	Description
IQueryable<T>	source	Source data query.
Expression<Func<T, Boolean>>	predicate	Filter expression, to specify what records from source query should be updated.
Expression<Func<T, T>>	setter	Update expression. Uses updated record as parameter. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Number of updated records.

Type Parameters

Name	Description
T	Updated table record type.

Update<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>)

Executes update-from-source operation against target table.

Declaration

public static int Update<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Update expression. Uses record from source query as parameter. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Number of updated records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table mapping class.

Update<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>)

Executes update-from-source operation against target table. Also see Update<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>) method.

Declaration

public static int Update<TSource, TTarget>(this IQueryable<TSource> source, Expression<Func<TSource, TTarget>> target, Expression<Func<TSource, TTarget>> setter)

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.
Expression<Func<TSource, TTarget>>	target	Target table selection expression.
Expression<Func<TSource, TTarget>>	setter	Update expression. Uses record from source query as parameter. Expression supports only target table record new expression with field initializers.

Returns

Type	Description
Int32	Number of updated records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table mapping class.

UpdateAsync<T>(IUpdatable<T>, CancellationToken)

Executes update operation asynchronously for already configured update query.

Declaration

public static Task<int> UpdateAsync<T>(this IUpdatable<T> source, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IUpdatable<T>	source	Update query.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of updated records.

Type Parameters

Name	Description
T	Updated table record type.

UpdateAsync<T>(IQueryable<T>, Expression<Func<T, T>>, CancellationToken)

Executes update operation asynchronously using source query as record filter.

Declaration

public static Task<int> UpdateAsync<T>(this IQueryable<T> source, Expression<Func<T, T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<T>	source	Source data query.
Expression<Func<T, T>>	setter	Update expression. Uses updated record as parameter. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of updated records.

Type Parameters

Name	Description
T	Updated table record type.

UpdateAsync<T>(IQueryable<T>, Expression<Func<T, Boolean>>, Expression<Func<T, T>>, CancellationToken)

Executes update operation asynchronously using source query as record filter with additional filter expression.

Declaration

public static Task<int> UpdateAsync<T>(this IQueryable<T> source, Expression<Func<T, bool>> predicate, Expression<Func<T, T>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<T>	source	Source data query.
Expression<Func<T, Boolean>>	predicate	Filter expression, to specify what records from source query should be updated.
Expression<Func<T, T>>	setter	Update expression. Uses updated record as parameter. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of updated records.

Type Parameters

Name	Description
T	Updated table record type.

UpdateAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken)

Executes update-from-source operation asynchronously against target table.

Declaration

public static Task<int> UpdateAsync<TSource, TTarget>(this IQueryable<TSource> source, ITable<TTarget> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.
ITable<TTarget>	target	Target table.
Expression<Func<TSource, TTarget>>	setter	Update expression. Uses record from source query as parameter. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of updated records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table mapping class.

UpdateAsync<TSource, TTarget>(IQueryable<TSource>, Expression<Func<TSource, TTarget>>, Expression<Func<TSource, TTarget>>, CancellationToken)

Executes update-from-source operation asynchronously against target table. Also see UpdateAsync<TSource, TTarget>(IQueryable<TSource>, ITable<TTarget>, Expression<Func<TSource, TTarget>>, CancellationToken) method.

Declaration

public static Task<int> UpdateAsync<TSource, TTarget>(this IQueryable<TSource> source, Expression<Func<TSource, TTarget>> target, Expression<Func<TSource, TTarget>> setter, CancellationToken token = default(CancellationToken))

Parameters

Type	Name	Description
IQueryable<TSource>	source	Source data query.
Expression<Func<TSource, TTarget>>	target	Target table selection expression.
Expression<Func<TSource, TTarget>>	setter	Update expression. Uses record from source query as parameter. Expression supports only target table record new expression with field initializers.
CancellationToken	token	Optional asynchronous operation cancellation token.

Returns

Type	Description
Task<Int32>	Number of updated records.

Type Parameters

Name	Description
TSource	Source query record type.
TTarget	Target table mapping class.

Value<T, TV>(ITable<T>, Expression<Func<T, TV>>, TV)

Starts insert operation LINQ query definition from field setter expression.

Declaration

public static IValueInsertable<T> Value<T, TV>(this ITable<T> source, Expression<Func<T, TV>> field, TV value)

Parameters

Type	Name	Description
ITable<T>	source	Source table to insert to.
Expression<Func<T, TV>>	field	Setter field selector expression.
TV	value	Setter field value.

Returns

Type	Description
IValueInsertable<T>	Insert query.

Type Parameters

Name	Description
T	Target table record type.
TV	Setter field type.

Value<T, TV>(ITable<T>, Expression<Func<T, TV>>, Expression<Func<TV>>)

Starts insert operation LINQ query definition from field setter expression.

Declaration

public static IValueInsertable<T> Value<T, TV>(this ITable<T> source, Expression<Func<T, TV>> field, Expression<Func<TV>> value)

Parameters

Type	Name	Description
ITable<T>	source	Source table to insert to.
Expression<Func<T, TV>>	field	Setter field selector expression.
Expression<Func<TV>>	value	Setter field value expression.

Returns

Type	Description
IValueInsertable<T>	Insert query.

Type Parameters

Name	Description
T	Target table record type.
TV	Setter field type.

Value<T, TV>(IValueInsertable<T>, Expression<Func<T, TV>>, TV)

Add field setter to insert operation LINQ query.

Declaration

public static IValueInsertable<T> Value<T, TV>(this IValueInsertable<T> source, Expression<Func<T, TV>> field, TV value)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
Expression<Func<T, TV>>	field	Setter field selector expression.
TV	value	Setter field value.

Returns

Type	Description
IValueInsertable<T>	Insert query.

Type Parameters

Name	Description
T	Target table record type.
TV	Setter field type.

Value<T, TV>(IValueInsertable<T>, Expression<Func<T, TV>>, Expression<Func<TV>>)

Add field setter to insert operation LINQ query.

Declaration

public static IValueInsertable<T> Value<T, TV>(this IValueInsertable<T> source, Expression<Func<T, TV>> field, Expression<Func<TV>> value)

Parameters

Type	Name	Description
IValueInsertable<T>	source	Insert query.
Expression<Func<T, TV>>	field	Setter field selector expression.
Expression<Func<TV>>	value	Setter field value expression.

Returns

Type	Description
IValueInsertable<T>	Insert query.

Type Parameters

Name	Description
T	Target table record type.
TV	Setter field type.

Value<TSource, TTarget, TValue>(ISelectInsertable<TSource, TTarget>, Expression<Func<TTarget, TValue>>, TValue)

Add field setter to insert operation LINQ query.

Declaration

public static ISelectInsertable<TSource, TTarget> Value<TSource, TTarget, TValue>(this ISelectInsertable<TSource, TTarget> source, Expression<Func<TTarget, TValue>> field, TValue value)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
Expression<Func<TTarget, TValue>>	field	Setter field selector expression.
TValue	value	Setter field value.

Returns

Type	Description
ISelectInsertable<TSource, TTarget>	Insert query.

Type Parameters

Name	Description
TSource	Source record type.
TTarget	Target record type
TValue	Field type.

Value<TSource, TTarget, TValue>(ISelectInsertable<TSource, TTarget>, Expression<Func<TTarget, TValue>>, Expression<Func<TSource, TValue>>)

Add field setter to insert operation LINQ query.

Declaration

public static ISelectInsertable<TSource, TTarget> Value<TSource, TTarget, TValue>(this ISelectInsertable<TSource, TTarget> source, Expression<Func<TTarget, TValue>> field, Expression<Func<TSource, TValue>> value)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
Expression<Func<TTarget, TValue>>	field	Setter field selector expression.
Expression<Func<TSource, TValue>>	value	Setter field value expression. Accepts source record as parameter.

Returns

Type	Description
ISelectInsertable<TSource, TTarget>	Insert query.

Type Parameters

Name	Description
TSource	Source record type.
TTarget	Target record type
TValue	Field type.

Value<TSource, TTarget, TValue>(ISelectInsertable<TSource, TTarget>, Expression<Func<TTarget, TValue>>, Expression<Func<TValue>>)

Add field setter to insert operation LINQ query.

Declaration

public static ISelectInsertable<TSource, TTarget> Value<TSource, TTarget, TValue>(this ISelectInsertable<TSource, TTarget> source, Expression<Func<TTarget, TValue>> field, Expression<Func<TValue>> value)

Parameters

Type	Name	Description
ISelectInsertable<TSource, TTarget>	source	Insert query.
Expression<Func<TTarget, TValue>>	field	Setter field selector expression.
Expression<Func<TValue>>	value	Setter field value expression.

Returns

Type	Description
ISelectInsertable<TSource, TTarget>	Insert query.

Type Parameters

Name	Description
TSource	Source record type.
TTarget	Target record type
TValue	Field type.

With<T>(ITable<T>, String)

Adds table hints to a table in generated query. Also see WithTableExpression<T>(ITable<T>, String) method.

// will produce following SQL code in generated query: table tablealias with(UpdLock)
var tableWithHint = db.Table.With("UpdLock");

Declaration

public static ITable<T> With<T>(this ITable<T> table, string args)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
String	args	SQL text, added to WITH({0}) after table name in generated query.

Returns

Type	Description
ITable<T>	Table-like query source with table hints.

Type Parameters

Name	Description
T	Table record mapping class.

WithTableExpression<T>(ITable<T>, String)

Replaces access to a table in generated query with SQL expression. Example below adds hint to a table. Also see With<T>(ITable<T>, String) method.

var tableWithHint = db.Table.WithTableExpression("{0} {1} with (UpdLock)");

Declaration

public static ITable<T> WithTableExpression<T>(this ITable<T> table, string expression)

Parameters

Type	Name	Description
ITable<T>	table	Table-like query source.
String	expression	SQL template to use instead of table name. Template supports two parameters: - {0} original table name; - {1} table alias.

Returns

Type	Description
ITable<T>	Table-like query source with new table source expression.

Type Parameters

Name	Description
T	Table record mapping class.