MultiTableSqlQuery 类

命名空间: ShadowSql.Join

程序集: ShadowSql.Core.dll

多表查询

public class MultiTableSqlQuery : MultiTableBase<SqlQuery>, IMultiView, IDataSqlQuery, IDataFilter, ITableView, IWhere, ISqlEntity

继承: object

GetFieldBase

ViewBase

TableViewBase

FilterBase

MultiTableBase

MultiTableBase<SqlQuery>

MultiTableSqlQuery

实现: IMultiView

IDataSqlQuery

IDataFilter

ITableView

IWhere

ISqlEntity

衍生: DapperMultiTableSqlQuery

继承成员: 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)

扩展方法: ShadowSqlServices.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlCoreServices.Alias<TTable>(IMultiView, string)

ShadowSqlCoreServices.From(IMultiView, string)

ShadowSqlCoreServices.From<TAliasTable>(IMultiView, string)

ShadowSqlCoreServices.TableCompare(IMultiView, string, string)

ShadowSqlCoreServices.ToDelete(IMultiView)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlServices.ToSingle(IMultiView, Func<IMultiView, IFieldView>)

ShadowSqlServices.ToUpdate(IMultiView)

DapperShadowCoreServices.Count(ITableView, IExecutor, object?)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCount(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?)

ShadowSqlCoreServices.AsExists(ITableView)

ShadowSqlCoreServices.AsNotExists(ITableView)

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>>)

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>)

ShadowSqlCoreServices.AddMembers<MultiTable>(MultiTable, params IEnumerable<IAliasTable>)

ShadowSqlCoreServices.AddMembers<MultiTable>(MultiTable, params IEnumerable<ITable>)

ShadowSqlCoreServices.AddMembers<MultiTable>(MultiTable, params IEnumerable<string>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<SqlQuery, ITableView, SqlQuery>)

ShadowSqlCoreServices.Apply<Query>(Query, Func<SqlQuery, SqlQuery>)

ShadowSqlCoreServices.CreateMember<MultiTable, TTable>(MultiTable, TTable)

ShadowSqlCoreServices.Exists<Query>(Query, ITableView)

ShadowSqlCoreServices.In<Query>(Query, ICompareView, ISingleSelect)

ShadowSqlCoreServices.NotExists<Query>(Query, ITableView)

ShadowSqlCoreServices.NotIn<Query>(Query, ICompareView, ISingleSelect)

ShadowSqlCoreServices.ToAnd<Query>(Query)

ShadowSqlCoreServices.ToOr<Query>(Query)

ShadowSqlCoreServices.Where<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.Where<Query>(Query, params IEnumerable<string>)

ShadowSqlCoreServices.Where<Query>(Query, Func<ITableView, AtomicLogic>)

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

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

ShadowSqlServices.SqlGroupBy(MultiTableSqlQuery, params IField[])

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

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

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

ShadowSqlServices.Where<TTable>(MultiTableSqlQuery, string, Func<TTable, IColumn>, Func<IPrefixField, 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>)

构造函数

MultiTableSqlQuery()

多表查询

public MultiTableSqlQuery()

MultiTableSqlQuery(SqlQuery)

多表查询

public MultiTableSqlQuery(SqlQuery query)

参数

query SqlQuery

方法

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

指定表查询

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

参数

tableName string: 表名
query Func<SqlQuery, TAliasTable, SqlQuery>: 查询

MultiTableSqlQuery

类型参数

TAliasTable

Table of Contents

MultiTableSqlQuery 类

构造函数

MultiTableSqlQuery()

MultiTableSqlQuery(SqlQuery)

参数

方法

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

参数

返回

类型参数