DapperMultiTableSqlQuery 类

命名空间

Dapper.Shadow.Join

程序集

Dapper.Shadow.dll

多表查询

public class DapperMultiTableSqlQuery : MultiTableSqlQuery, IMultiView, IDataSqlQuery, IDataFilter, IWrapper<ITableView>, IWhere, IDapperSource, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

MultiTableBase

MultiTableBase<SqlQuery>

MultiTableSqlQuery

DapperMultiTableSqlQuery

实现

IMultiView

IDataSqlQuery

IDataFilter

IWrapper<ITableView>

IWhere

IDapperSource

ITableView

ISqlEntity

继承成员

MultiTableBase<SqlQuery>.WriteFilter(ISqlEngine, StringBuilder)

MultiTableBase.AliasGenerator

MultiTableBase._tables

MultiTableBase.Tables

MultiTableBase.GetMember(string)

MultiTableBase.GetPrefixField(string)

MultiTableBase.PrefixFields

MultiTableBase.GetFields()

MultiTableBase.GetField(string)

MultiTableBase.GetCompareField(string)

MultiTableBase.NewField(string)

MultiTableBase.WriteSource(ISqlEngine, StringBuilder)

FilterBase.FilterPrefix(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

扩展方法

DapperShadowCoreServices.CountAsync(IDapperSource, object?, CancellationToken)

DapperShadowCoreServices.LongCountAsync(IDapperSource, object?, CancellationToken)

DapperShadowServices.Take(DapperMultiTableSqlQuery, int, int)

DapperShadowServices.ToCursor(DapperMultiTableSqlQuery, int, int)

DapperShadowServices.ToDapperSelect(DapperMultiTableSqlQuery)

DapperShadowServices.ToDapperSingle(DapperMultiTableSqlQuery, IFieldView)

DapperShadowServices.ToDapperUpdate(DapperMultiTableSqlQuery)

FieldQueryServices.FieldBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreaterEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreater<TQuery>(TQuery, string, string)

FieldQueryServices.FieldInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldIsNull<TQuery>(TQuery, string)

FieldQueryServices.FieldLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLessEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLessValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLess<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldNotBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldNotEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldNotIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotNull<TQuery>(TQuery, string)

FieldQueryServices.FieldParameter<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldValue<TQuery, TValue>(TQuery, string, TValue, string)

FieldQueryServices.TableFieldBetweenValue<TQuery, TValue>(TQuery, string, string, TValue, TValue)

FieldQueryServices.TableFieldBetween<TQuery>(TQuery, string, string, string, string)

FieldQueryServices.TableFieldEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

FieldQueryServices.TableFieldEqual<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldGreaterEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

FieldQueryServices.TableFieldGreaterEqual<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldGreaterValue<TQuery, TValue>(TQuery, string, string, TValue)

FieldQueryServices.TableFieldGreater<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldInValue<TQuery, TValue>(TQuery, string, string, params IEnumerable<TValue>)

FieldQueryServices.TableFieldIn<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldIsNull<TQuery>(TQuery, string, string)

FieldQueryServices.TableFieldLessEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

FieldQueryServices.TableFieldLessEqual<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldLessValue<TQuery, TValue>(TQuery, string, string, TValue)

FieldQueryServices.TableFieldLess<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldLikeValue<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldLike<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldNotBetweenValue<TQuery, TValue>(TQuery, string, string, TValue, TValue)

FieldQueryServices.TableFieldNotBetween<TQuery>(TQuery, string, string, string, string)

FieldQueryServices.TableFieldNotEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

FieldQueryServices.TableFieldNotEqual<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldNotInValue<TQuery, TValue>(TQuery, string, string, params IEnumerable<TValue>)

FieldQueryServices.TableFieldNotIn<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldNotLikeValue<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldNotLike<TQuery>(TQuery, string, string, string)

FieldQueryServices.TableFieldNotNull<TQuery>(TQuery, string, string)

FieldQueryServices.TableFieldParameter<TQuery>(TQuery, string, string, string, string)

FieldQueryServices.TableFieldValue<TQuery, TValue>(TQuery, string, string, TValue, string)

FieldQueryServices.TableField<Query>(Query, string, string, Func<ICompareField, AtomicLogic>)

ShadowSqlServices.Apply<TMultiTable>(TMultiTable, string, Func<SqlQuery, IAliasTable, SqlQuery>)

ShadowSqlServices.Where<TMultiTable>(TMultiTable, Func<IMultiView, AtomicLogic>)

ShadowSqlServices.Where<TMultiTable>(TMultiTable, string, Func<IAliasTable, AtomicLogic>)

StrictQueryServices.StrictBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreaterEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreater<TQuery>(TQuery, string, string)

StrictQueryServices.StrictInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictIsNull<TQuery>(TQuery, string)

StrictQueryServices.StrictLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLessEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLessValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLess<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictNotBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictNotEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictNotIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotNull<TQuery>(TQuery, string)

StrictQueryServices.StrictParameter<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictValue<TQuery, TValue>(TQuery, string, TValue, string)

StrictQueryServices.TableStrictBetweenValue<TQuery, TValue>(TQuery, string, string, TValue, TValue)

StrictQueryServices.TableStrictBetween<TQuery>(TQuery, string, string, string, string)

StrictQueryServices.TableStrictEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

StrictQueryServices.TableStrictEqual<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictGreaterEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

StrictQueryServices.TableStrictGreaterEqual<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictGreaterValue<TQuery, TValue>(TQuery, string, string, TValue)

StrictQueryServices.TableStrictGreater<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictInValue<TQuery, TValue>(TQuery, string, string, params IEnumerable<TValue>)

StrictQueryServices.TableStrictIn<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictIsNull<TQuery>(TQuery, string, string)

StrictQueryServices.TableStrictLessEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

StrictQueryServices.TableStrictLessEqual<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictLessValue<TQuery, TValue>(TQuery, string, string, TValue)

StrictQueryServices.TableStrictLess<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictLikeValue<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictLike<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictNotBetweenValue<TQuery, TValue>(TQuery, string, string, TValue, TValue)

StrictQueryServices.TableStrictNotBetween<TQuery>(TQuery, string, string, string, string)

StrictQueryServices.TableStrictNotEqualValue<TQuery, TValue>(TQuery, string, string, TValue)

StrictQueryServices.TableStrictNotEqual<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictNotInValue<TQuery, TValue>(TQuery, string, string, params IEnumerable<TValue>)

StrictQueryServices.TableStrictNotIn<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictNotLikeValue<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictNotLike<TQuery>(TQuery, string, string, string)

StrictQueryServices.TableStrictNotNull<TQuery>(TQuery, string, string)

StrictQueryServices.TableStrictParameter<TQuery>(TQuery, string, string, string, string)

StrictQueryServices.TableStrictValue<TQuery, TValue>(TQuery, string, string, TValue, string)

StrictQueryServices.TableStrict<Query>(Query, string, string, Func<IField, AtomicLogic>)

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlServices.ToSelect(IMultiView)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?, CancellationToken)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?, CancellationToken)

ShadowSqlCoreServices.Field(ITableView, string)

ShadowSqlCoreServices.Fields(ITableView, params IEnumerable<string>)

ShadowSqlCoreServices.Strict(ITableView, string)

ShadowSqlServices.Take(MultiTableBase, int, int)

ShadowSqlServices.ToCursor(MultiTableBase, int, int)

ShadowSqlServices.Take(MultiTableBase, int, int)

ShadowSqlServices.ToCursor(MultiTableBase, int, int)

ShadowSqlServices.Where<TEntity>(MultiTableSqlQuery, Expression<Func<TEntity, bool>>)

ShadowSqlServices.Where<TEntity>(MultiTableSqlQuery, string, Expression<Func<TEntity, bool>>)

ShadowSqlServices.Where<TEntity, TParameter>(MultiTableSqlQuery, Expression<Func<TEntity, TParameter, bool>>)

ShadowSqlServices.Where<TEntity, TParameter>(MultiTableSqlQuery, string, Expression<Func<TEntity, TParameter, bool>>)

ShadowSqlServices.Apply<TAliasTable>(MultiTableSqlQuery, string, Func<SqlQuery, TAliasTable, SqlQuery>)

ShadowSqlServices.SqlGroupBy(MultiTableSqlQuery, params IField[])

ShadowSqlServices.SqlGroupBy(MultiTableSqlQuery, params IEnumerable<string>)

ShadowSqlServices.Where<TTable>(MultiTableSqlQuery, string, Func<TTable, IColumn>, Func<IPrefixField, AtomicLogic>)

构造函数

DapperMultiTableSqlQuery(IExecutor, SqlQuery)

多表查询

public DapperMultiTableSqlQuery(IExecutor executor, SqlQuery filter)

参数

executor IExecutor

执行器

filter SqlQuery

过滤条件

属性

Executor

执行器

public IExecutor Executor { get; }

属性值

IExecutor

方法

Apply<TAliasTable>(string, Func<SqlQuery, TAliasTable, SqlQuery>)

指定表查询

public DapperMultiTableSqlQuery Apply<TAliasTable>(string tableName, Func<SqlQuery, TAliasTable, SqlQuery> query) where TAliasTable : IAliasTable

参数

tableName string

表名

query Func<SqlQuery, TAliasTable, SqlQuery>

查询

返回

DapperMultiTableSqlQuery

类型参数

TAliasTable