JoinOnQuery 类

命名空间

ShadowSql.Join

程序集

ShadowSql.Core.dll

联表俩俩关联查询

public class JoinOnQuery : JoinOnCoreBase<JoinTableQuery, Logic>, IJoinOn, IMultiView, IDataQuery, IDataFilter, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnCoreBase<JoinTableQuery, Logic>

JoinOnQuery

实现

IJoinOn

IMultiView

IDataQuery

IDataFilter

ITableView

ISqlEntity

继承成员

JoinOnCoreBase<JoinTableQuery, Logic>._root

JoinOnCoreBase<JoinTableQuery, Logic>.Root

JoinOnCoreBase<JoinTableQuery, Logic>._left

JoinOnCoreBase<JoinTableQuery, Logic>._source

JoinOnCoreBase<JoinTableQuery, Logic>.Left

JoinOnCoreBase<JoinTableQuery, Logic>.Source

JoinOnCoreBase<JoinTableQuery, Logic>.PrefixFields

JoinOnCoreBase<JoinTableQuery, Logic>.GetLeftField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.GetRightField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.LeftField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.RightField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.GetMember(string)

JoinOnCoreBase<JoinTableQuery, Logic>.GetFields()

JoinOnCoreBase<JoinTableQuery, Logic>.GetField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.NewField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.GetCompareField(string)

JoinOnCoreBase<JoinTableQuery, Logic>.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnCoreBase<JoinTableQuery, Logic>.WriteFilter(ISqlEngine, StringBuilder)

JoinOnBase.JoinType

JoinOnBase._tables

JoinOnBase.Tables

JoinOnBase.GetLeftField(string)

JoinOnBase.GetRightField(string)

JoinOnBase.GetPrefixField(string)

JoinOnBase.LeftField(string)

JoinOnBase.RightField(string)

JoinOnBase.GetLeftCompareField(string)

JoinOnBase.GetRightCompareField(string)

JoinOnBase.GetMember(string)

JoinOnBase.FilterPrefix(ISqlEngine, StringBuilder)

JoinOnBase.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnBase.WriteSource(ISqlEngine, StringBuilder)

FilterBase.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetCompareField(string)

GetFieldBase.GetFields()

GetFieldBase.GetField(string)

GetFieldBase.NewField(string)

扩展方法

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.ToSelect(IJoinOn)

ShadowSqlCoreServices.Prefix(IJoinOn, IColumn)

ShadowSqlCoreServices.Prefix(IJoinOn, string)

ShadowSqlServices.ToSelect(IJoinOn)

ShadowSqlCoreServices.And<Query>(Query, AndLogic)

ShadowSqlCoreServices.And<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.And<Query>(Query, ComplexAndLogic)

ShadowSqlCoreServices.And<Query>(Query, ComplexOrLogic)

ShadowSqlCoreServices.And<Query>(Query, Logic)

ShadowSqlCoreServices.And<Query>(Query, OrLogic)

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

ShadowSqlCoreServices.And<Query>(Query, Func<ITableView, OrLogic>)

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

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

ShadowSqlCoreServices.Apply<TJoinOn>(TJoinOn, string, string, Func<Logic, ICompareView, ICompareView, Logic>)

ShadowSqlCoreServices.AsInnerJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsLeftJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsOuterJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsRightJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.LeftTableJoin(JoinOnQuery, IAliasTable)

ShadowSqlCoreServices.LeftTableJoin(JoinOnQuery, ITable)

ShadowSqlCoreServices.LeftTableJoin(JoinOnQuery, string)

ShadowSqlCoreServices.Or<Query>(Query, AndLogic)

ShadowSqlCoreServices.Or<Query>(Query, AtomicLogic)

ShadowSqlCoreServices.Or<Query>(Query, ComplexAndLogic)

ShadowSqlCoreServices.Or<Query>(Query, ComplexOrLogic)

ShadowSqlCoreServices.Or<Query>(Query, Logic)

ShadowSqlCoreServices.Or<Query>(Query, OrLogic)

ShadowSqlCoreServices.Or<Query>(Query, Func<ITableView, AndLogic>)

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

ShadowSqlCoreServices.RightTableJoin(JoinOnQuery, IAliasTable)

ShadowSqlCoreServices.RightTableJoin(JoinOnQuery, ITable)

ShadowSqlCoreServices.RightTableJoin(JoinOnQuery, string)

ShadowSqlServices.ApplyLeft<TJoinOn>(TJoinOn, string, Func<Logic, ICompareView, Logic>)

ShadowSqlServices.ApplyRight<TJoinOn>(TJoinOn, string, Func<Logic, ICompareView, Logic>)

构造函数

JoinOnQuery(JoinTableQuery, IAliasTable, IAliasTable)

联表俩俩关联查询

public JoinOnQuery(JoinTableQuery joinTable, IAliasTable left, IAliasTable right)

参数

joinTable JoinTableQuery

联表

left IAliasTable

左

right IAliasTable

右

JoinOnQuery(JoinTableQuery, IAliasTable, IAliasTable, Logic)

联表俩俩关联查询

public JoinOnQuery(JoinTableQuery joinTable, IAliasTable left, IAliasTable right, Logic onQuery)

参数

joinTable JoinTableQuery

联表

left IAliasTable

左

right IAliasTable

右

onQuery Logic

联表逻辑

方法

Create(IAliasTable, IAliasTable)

联表查询

public static JoinOnQuery Create(IAliasTable left, IAliasTable right)

参数

left IAliasTable

right IAliasTable

返回

JoinOnQuery

Create(string, string)

联表查询

public static JoinOnQuery Create(string left, string right)

参数

left string

right string

返回

JoinOnQuery

Create<TTable>(TTable, TTable)

联表查询

public static JoinOnQuery Create<TTable>(TTable left, TTable right) where TTable : ITable

参数

left TTable

right TTable

返回

JoinOnQuery

类型参数

TTable