Class TableBase<TEntity>

A TableBase<TEntity> is used to perform query operations of all sorts.

Inheritance
Object
TableBase<TEntity>
Table<TEntity>
Namespace: Venflow
Assembly: Venflow.dll
Syntax
public class TableBase<TEntity> : object where TEntity : class, new()
Type Parameters
Name Description
TEntity

The entity which represents a table in the Database.

Methods

| Improve this Doc View Source

QueryAsync<TReturn>(IQueryCommand<TEntity, TReturn>, CancellationToken)

Asynchronously queries one or more entities with the configured joins.

Declaration
public Task<TReturn> QueryAsync<TReturn>(IQueryCommand<TEntity, TReturn> queryCommand, CancellationToken cancellationToken = null)
    where TReturn : class, new()
Parameters
Type Name Description
IQueryCommand<TEntity, TReturn> queryCommand

A IQueryCommand<TEntity, TReturn> instance representing the query which will be performed.
CancellationToken cancellationToken

The cancellation token, which is used to cancel the operation.
Returns
Type Description
Task<TReturn>

A task representing the asynchronous operation, with the result of the executed query.
Type Parameters
Name Description
TReturn
Remarks

This method could represents the following SQL statement "SELECT * FROM table".

| Improve this Doc View Source

QueryBatch(Expression<Func<TEntity, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch(Expression<Func<TEntity, FormattableString>> sql, bool disposeCommand = true)
Parameters
Type Name Description
Expression<Func<TEntity, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QueryBatch(String, IList<NpgsqlParameter>)

Creates a new query command, which expects a set of primary rows to be returned.This API does not support string interpolation! If you want to pass interpolated SQL use QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch(string sql, IList<NpgsqlParameter> parameters)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
IList<NpgsqlParameter> parameters

A set of which contain parameters for the sql command.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Remarks

The command will be automatically disposed the underlying after the command got executed once.

| Improve this Doc View Source

QueryBatch(String, NpgsqlParameter[])

Creates a new query command, which expects a set of primary rows to be returned.This API does not support string interpolation! If you want to pass interpolated SQL use QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch(string sql, params NpgsqlParameter[] parameters)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
NpgsqlParameter[] parameters

A set of which contain parameters for the sql command.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Remarks

The command will be automatically disposed the underlying after the command got executed once.

| Improve this Doc View Source

QueryBatch(String, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does not support string interpolation! If you need to pass parameters with the query, either use QuerySingle(String, NpgsqlParameter[]) or QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch(string sql, bool disposeCommand = true)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QueryBatch(String, Boolean, NpgsqlParameter[])

Creates a new query command, which expects a set of primary rows to be returned. This API does not support string interpolation! If you want to pass interpolated SQL use QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch(string sql, bool disposeCommand, params NpgsqlParameter[] parameters)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
NpgsqlParameter[] parameters

A set of which contain parameters for the sql command.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QueryBatch<TOne>(Expression<Func<TEntity, TOne, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne>(Expression<Func<TEntity, TOne, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
| Improve this Doc View Source

QueryBatch<TOne, Two>(Expression<Func<TEntity, TOne, Two, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two>(Expression<Func<TEntity, TOne, Two, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
| Improve this Doc View Source

QueryBatch<TOne, Two, TThree>(Expression<Func<TEntity, TOne, Two, TThree, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two, TThree>(Expression<Func<TEntity, TOne, Two, TThree, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
| Improve this Doc View Source

QueryBatch<TOne, Two, TThree, TFour>(Expression<Func<TEntity, TOne, Two, TThree, TFour, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two, TThree, TFour>(Expression<Func<TEntity, TOne, Two, TThree, TFour, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
| Improve this Doc View Source

QueryBatch<TOne, Two, TThree, TFour, TFive>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two, TThree, TFour, TFive>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
| Improve this Doc View Source

QueryBatch<TOne, Two, TThree, TFour, TFive, TSix>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two, TThree, TFour, TFive, TSix>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
    where TSix : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
TSix
| Improve this Doc View Source

QueryBatch<TOne, Two, TThree, TFour, TFive, TSix, TSeven>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two, TThree, TFour, TFive, TSix, TSeven>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
    where TSix : class, new()
    where TSeven : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
TSix
TSeven
| Improve this Doc View Source

QueryBatch<TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight, FormattableString>>, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryBatch<TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
    where TSix : class, new()
    where TSeven : class, new()
    where TEight : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight, FormattableString>> sql

A string containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
TSix
TSeven
TEight
| Improve this Doc View Source

QueryInterpolatedBatch(FormattableString, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryInterpolatedBatch(FormattableString sql, bool disposeCommand = true)
Parameters
Type Name Description
FormattableString sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter. You should only add parameters trough string interpolation.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QueryInterpolatedBatch(FormattableSqlStringBuilder, Boolean)

Creates a new query command, which expects a set of primary rows to be returned. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>> QueryInterpolatedBatch(FormattableSqlStringBuilder sql, bool disposeCommand = true)
Parameters
Type Name Description
FormattableSqlStringBuilder sql

A FormattableSqlStringBuilder instance containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, List<TEntity>>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QueryInterpolatedSingle(FormattableString, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QueryInterpolatedSingle(FormattableString sql, bool disposeCommand = true)
Parameters
Type Name Description
FormattableString sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter. You should only add parameters trough string interpolation.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QueryInterpolatedSingle(FormattableSqlStringBuilder, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QueryInterpolatedSingle(FormattableSqlStringBuilder sql, bool disposeCommand = true)
Parameters
Type Name Description
FormattableSqlStringBuilder sql

A FormattableSqlStringBuilder instance containing the SQL statement.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QuerySingle(Expression<Func<TEntity, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle(Expression<Func<TEntity, FormattableString>> sql, bool disposeCommand = true)
Parameters
Type Name Description
Expression<Func<TEntity, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QuerySingle(String, IList<NpgsqlParameter>)

Creates a new query command, which expects a single returned primary row. This API does not support string interpolation! If you want to pass interpolated SQL use QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle(string sql, IList<NpgsqlParameter> parameters)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
IList<NpgsqlParameter> parameters

A set of which contain parameters for the sql command.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Remarks

The command will be automatically disposed the underlying after the command got executed once.

| Improve this Doc View Source

QuerySingle(String, NpgsqlParameter[])

Creates a new query command, which expects a single returned primary row. This API does not support string interpolation! If you want to pass interpolated SQL use QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle(string sql, params NpgsqlParameter[] parameters)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
NpgsqlParameter[] parameters

A set of which contain parameters for the sql command.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Remarks

The command will be automatically disposed the underlying after the command got executed once.

| Improve this Doc View Source

QuerySingle(String, Boolean)

Creates a new query command, which expects a single returned primary row. This API does not support string interpolation! If you need to pass parameters with the query, either use QuerySingle(String, NpgsqlParameter[]) or QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle(string sql, bool disposeCommand = true)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QuerySingle(String, Boolean, NpgsqlParameter[])

Creates a new query command, which expects a single returned primary row. This API does not support string interpolation! If you want to pass interpolated SQL use QueryInterpolatedSingle(FormattableString, Boolean).

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle(string sql, bool disposeCommand, params NpgsqlParameter[] parameters)
Parameters
Type Name Description
String sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
NpgsqlParameter[] parameters

A set of which contain parameters for the sql command.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
| Improve this Doc View Source

QuerySingle<TOne>(Expression<Func<TEntity, TOne, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne>(Expression<Func<TEntity, TOne, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
| Improve this Doc View Source

QuerySingle<TOne, Two>(Expression<Func<TEntity, TOne, Two, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two>(Expression<Func<TEntity, TOne, Two, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
| Improve this Doc View Source

QuerySingle<TOne, Two, TThree>(Expression<Func<TEntity, TOne, Two, TThree, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two, TThree>(Expression<Func<TEntity, TOne, Two, TThree, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
| Improve this Doc View Source

QuerySingle<TOne, Two, TThree, TFour>(Expression<Func<TEntity, TOne, Two, TThree, TFour, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two, TThree, TFour>(Expression<Func<TEntity, TOne, Two, TThree, TFour, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
| Improve this Doc View Source

QuerySingle<TOne, Two, TThree, TFour, TFive>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two, TThree, TFour, TFive>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
| Improve this Doc View Source

QuerySingle<TOne, Two, TThree, TFour, TFive, TSix>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two, TThree, TFour, TFive, TSix>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
    where TSix : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
TSix
| Improve this Doc View Source

QuerySingle<TOne, Two, TThree, TFour, TFive, TSix, TSeven>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two, TThree, TFour, TFive, TSix, TSeven>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
    where TSix : class, new()
    where TSeven : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
TSix
TSeven
| Improve this Doc View Source

QuerySingle<TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight, FormattableString>>, Boolean)

Creates a new query command, which expects a single returned primary row. This API does support string interpolation!

Declaration
public IBaseQueryRelationBuilder<TEntity, TEntity, TEntity> QuerySingle<TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight>(Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight, FormattableString>> sql, bool disposeCommand = true)
    where TOne : class, new()
    where Two : class, new()
    where TThree : class, new()
    where TFour : class, new()
    where TFive : class, new()
    where TSix : class, new()
    where TSeven : class, new()
    where TEight : class, new()
Parameters
Type Name Description
Expression<Func<TEntity, TOne, Two, TThree, TFour, TFive, TSix, TSeven, TEight, FormattableString>> sql

A string containing the SQL statement. Ensure that you do not pass any user manipulated SQL for this parameter.
Boolean disposeCommand

Indicates whether or not to dispose the underlying after the command got executed once.
Returns
Type Description
IBaseQueryRelationBuilder<TEntity, TEntity, TEntity>

A Fluent API Builder for a query command.
Type Parameters
Name Description
TOne
Two
TThree
TFour
TFive
TSix
TSeven
TEight