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>._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.GetFields()

ViewBase.GetCompareField(string)

GetFieldBase.GetField(string)

GetFieldBase.NewField(string)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

扩展方法

ShadowSqlServices.ToSingle(IDataFilter, IFieldView)

ShadowSqlServices.ToSingle(IDataFilter, string)

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

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)

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 root, IAliasTable left, IAliasTable right)

参数

root JoinTableQuery

left IAliasTable

right IAliasTable

JoinOnQuery(JoinTableQuery, IAliasTable, IAliasTable, Logic)

联表俩俩关联查询

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

参数

root JoinTableQuery

left IAliasTable

right IAliasTable

onQuery Logic

方法

Create(IAliasTable, IAliasTable)

联表查询

public static JoinOnQuery Create(IAliasTable t1, IAliasTable t2)

参数

t1 IAliasTable

t2 IAliasTable

返回

JoinOnQuery

Create(string, string)

联表查询

public static JoinOnQuery Create(string t1, string t2)

参数

t1 string

t2 string

返回

JoinOnQuery

Create<TTable>(TTable, TTable)

联表查询

public static JoinOnQuery Create<TTable>(TTable t1, TTable t2) where TTable : ITable

参数

t1 TTable

t2 TTable

返回

JoinOnQuery

类型参数

TTable