JoinOnSqlQuery 类

命名空间

ShadowSql.Join

程序集

ShadowSql.Core.dll

联表俩俩关联查询

public class JoinOnSqlQuery : JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>, IJoinOn, IMultiView, IDataSqlQuery, IDataFilter, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>

JoinOnSqlQuery

实现

IJoinOn

IMultiView

IDataSqlQuery

IDataFilter

ITableView

ISqlEntity

继承成员

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>._root

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.Root

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>._left

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>._source

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.Left

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.Source

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.PrefixFields

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetLeftField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetRightField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.LeftField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.RightField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetMember(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetFields()

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.NewField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetCompareField(string)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.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)

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.TableFieldParameter<TQuery>(TQuery, string, string, string, string)

ShadowSqlCoreServices.Apply(JoinOnSqlQuery, Func<SqlQuery, IAliasTable, IAliasTable, SqlQuery>)

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

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

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

ShadowSqlCoreServices.AsInnerJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsLeftJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsOuterJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsRightJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.Exists<Query>(Query, ITableView)

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

ShadowSqlCoreServices.LeftTableJoin(JoinOnSqlQuery, IAliasTable)

ShadowSqlCoreServices.LeftTableJoin(JoinOnSqlQuery, ITable)

ShadowSqlCoreServices.LeftTableJoin(JoinOnSqlQuery, string)

ShadowSqlCoreServices.NotExists<Query>(Query, ITableView)

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

ShadowSqlCoreServices.OnColumn<TJoinOn>(TJoinOn, string, string)

ShadowSqlCoreServices.OnColumn<TJoinOn>(TJoinOn, string, string, string)

ShadowSqlCoreServices.On<TJoinOn>(TJoinOn, IColumn, CompareSymbol, IColumn)

ShadowSqlCoreServices.On<TJoinOn>(TJoinOn, IColumn, IColumn)

ShadowSqlCoreServices.On<TJoinOn>(TJoinOn, IPrefixField, CompareSymbol, IPrefixField)

ShadowSqlCoreServices.On<TJoinOn>(TJoinOn, IPrefixField, IPrefixField)

ShadowSqlCoreServices.On<TjoinOn>(TjoinOn, AtomicLogic)

ShadowSqlCoreServices.On<TJoinOn>(TJoinOn, params IEnumerable<string>)

ShadowSqlCoreServices.On<TjoinOn>(TjoinOn, Func<IAliasTable, IAliasTable, AtomicLogic>)

ShadowSqlCoreServices.On<TjoinOn>(TjoinOn, Func<IJoinOn, AtomicLogic>)

ShadowSqlCoreServices.RightTableJoin(JoinOnSqlQuery, IAliasTable)

ShadowSqlCoreServices.RightTableJoin(JoinOnSqlQuery, ITable)

ShadowSqlCoreServices.RightTableJoin(JoinOnSqlQuery, string)

ShadowSqlCoreServices.ToAnd<Query>(Query)

ShadowSqlCoreServices.ToOr<Query>(Query)

ShadowSqlServices.WhereLeft<TJoinOn>(TJoinOn, string, Func<ICompareView, AtomicLogic>)

ShadowSqlServices.WhereRight<TJoinOn>(TJoinOn, string, Func<ICompareView, 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.TableStrictParameter<TQuery>(TQuery, string, string, string, string)

构造函数

JoinOnSqlQuery(JoinTableSqlQuery, IAliasTable, IAliasTable)

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery joinTable, IAliasTable left, IAliasTable right)

参数

joinTable JoinTableSqlQuery

联表

left IAliasTable

左

right IAliasTable

右

JoinOnSqlQuery(JoinTableSqlQuery, IAliasTable, IAliasTable, SqlQuery)

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery joinTable, IAliasTable left, IAliasTable right, SqlQuery onQuery)

参数

joinTable JoinTableSqlQuery

联表

left IAliasTable

左

right IAliasTable

右

onQuery SqlQuery

联表查询

方法

Create(IAliasTable, IAliasTable)

联表查询

public static JoinOnSqlQuery Create(IAliasTable left, IAliasTable right)

参数

left IAliasTable

right IAliasTable

返回

JoinOnSqlQuery

Create(string, string)

联表查询

public static JoinOnSqlQuery Create(string left, string right)

参数

left string

right string

返回

JoinOnSqlQuery

Create<TTable>(TTable, TTable)

联表查询

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

参数

left TTable

right TTable

返回

JoinOnSqlQuery

类型参数

TTable