JoinOnQuery<TLeft, TRight> 类

命名空间

ShadowSql.Expressions.Join

程序集

ShadowSql.Expressions.dll

联表俩俩关联查询

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

类型参数

TLeft

TRight

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnCoreBase<JoinTableQuery, Logic>

JoinOnQuery<TLeft, TRight>

实现

IJoinOn

IMultiView

IDataQuery

IDataFilter

ITableView

ISqlEntity

IWrapper<ITableView>

继承成员

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)

扩展方法

ShadowSqlExtendServices.LeftTableJoin<TLeft, TRight, TOther>(JoinOnQuery<TLeft, TRight>, IAliasTable)

ShadowSqlExtendServices.RightTableJoin<TLeft, TRight, TOther>(JoinOnQuery<TLeft, TRight>, IAliasTable)

ShadowSqlServices.GroupBy<TLeft, TRight, TKey>(JoinOnQuery<TLeft, TRight>, Expression<Func<TLeft, TRight, TKey>>)

ShadowSqlServices.LeftTableJoin<TLeft, TRight, TOther>(JoinOnQuery<TLeft, TRight>, ITable)

ShadowSqlServices.RightTableJoin<TLeft, TRight, TOther>(JoinOnQuery<TLeft, TRight>, ITable)

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

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

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

ShadowSqlServices.ToSelect(IJoinOn)

构造函数

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

联表逻辑

方法

And(Expression<Func<TLeft, TRight, bool>>)

联表查询

public JoinOnQuery<TLeft, TRight> And(Expression<Func<TLeft, TRight, bool>> query)

参数

query Expression<Func<TLeft, TRight, bool>>

查询

返回

JoinOnQuery<TLeft, TRight>

Or(Expression<Func<TLeft, TRight, bool>>)

联表查询

public JoinOnQuery<TLeft, TRight> Or(Expression<Func<TLeft, TRight, bool>> query)

参数

query Expression<Func<TLeft, TRight, bool>>

查询

返回

JoinOnQuery<TLeft, TRight>