JoinOnQuery<LTable, RTable> 类

命名空间

ShadowSql.Join

程序集

ShadowSql.dll

联表俩俩关联查询

public class JoinOnQuery<LTable, RTable> : JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>, IJoinOn, IMultiView, IDataQuery, IDataFilter, ITableView, ISqlEntity, IWrapper<ITableView> where LTable : ITable where RTable : ITable

类型参数

LTable

RTable

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>

JoinOnQuery<LTable, RTable>

实现

IJoinOn

IMultiView

IDataQuery

IDataFilter

ITableView

ISqlEntity

IWrapper<ITableView>

继承成员

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>._root

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.Root

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>._left

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>._source

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.Left

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.Source

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.PrefixFields

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.GetLeftField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.GetRightField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.LeftField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.RightField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.GetMember(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.GetFields()

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.GetField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.NewField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.GetCompareField(string)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, Logic>.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnBase<JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, LTable, RTable, 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)

扩展方法

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)

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

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

ShadowSqlServices.Apply<LTable, RTable>(JoinOnQuery<LTable, RTable>, Func<LTable, IColumn>, Func<RTable, IColumn>, Func<Logic, IPrefixField, IPrefixField, Logic>)

ShadowSqlServices.GroupBy<LTable, RTable>(JoinOnQuery<LTable, RTable>, Func<LTable, RTable, IColumn[]>)

ShadowSqlServices.LeftTableJoin<LTable, RTable, TTable>(JoinOnQuery<LTable, RTable>, TTable)

ShadowSqlServices.RightTableJoin<LTable, RTable, TTable>(JoinOnQuery<LTable, RTable>, TTable)

构造函数

JoinOnQuery(JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>)

联表俩俩关联查询

public JoinOnQuery(JoinTableQuery joinTable, IAliasTable<LTable> left, IAliasTable<RTable> right)

参数

joinTable JoinTableQuery

联表

left IAliasTable<LTable>

左

right IAliasTable<RTable>

右

JoinOnQuery(JoinTableQuery, IAliasTable<LTable>, IAliasTable<RTable>, Logic)

联表俩俩关联查询

public JoinOnQuery(JoinTableQuery joinTable, IAliasTable<LTable> left, IAliasTable<RTable> right, Logic onQuery)

参数

joinTable JoinTableQuery

联表

left IAliasTable<LTable>

左

right IAliasTable<RTable>

右

onQuery Logic

联表逻辑

方法

Apply(Func<LTable, IColumn>, Func<RTable, IColumn>, Func<Logic, IPrefixField, IPrefixField, Logic>)

按列查询

public JoinOnQuery<LTable, RTable> Apply(Func<LTable, IColumn> left, Func<RTable, IColumn> right, Func<Logic, IPrefixField, IPrefixField, Logic> logic)

参数

left Func<LTable, IColumn>

左

right Func<RTable, IColumn>

右

logic Func<Logic, IPrefixField, IPrefixField, Logic>

查询逻辑

返回

JoinOnQuery<LTable, RTable>

ApplyLeft(Func<LTable, IColumn>, Func<Logic, IPrefixField, Logic>)

查询左表

public JoinOnQuery<LTable, RTable> ApplyLeft(Func<LTable, IColumn> left, Func<Logic, IPrefixField, Logic> query)

参数

left Func<LTable, IColumn>

左

query Func<Logic, IPrefixField, Logic>

查询

返回

JoinOnQuery<LTable, RTable>

ApplyRight(Func<RTable, IColumn>, Func<Logic, IPrefixField, Logic>)

查询右表

public JoinOnQuery<LTable, RTable> ApplyRight(Func<RTable, IColumn> right, Func<Logic, IPrefixField, Logic> query)

参数

right Func<RTable, IColumn>

右

query Func<Logic, IPrefixField, Logic>

查询

返回

JoinOnQuery<LTable, RTable>