Table of Contents

JoinOnQuery<LTable, RTable> 类

命名空间
ShadowSql.Join
程序集
ShadowSql.dll

联表俩俩关联查询

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

类型参数

LTable
RTable
继承
JoinOnBase<JoinTableQuery, TableAlias<LTable>, TableAlias<RTable>, LTable, RTable, Logic>
JoinOnQuery<LTable, RTable>
实现
继承成员
扩展方法

构造函数

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

联表俩俩关联查询

public JoinOnQuery(JoinTableQuery root, TableAlias<LTable> left, TableAlias<RTable> right)

参数

root JoinTableQuery
left TableAlias<LTable>
right TableAlias<RTable>

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

联表俩俩关联查询

public JoinOnQuery(JoinTableQuery root, TableAlias<LTable> left, TableAlias<RTable> right, Logic onQuery)

参数

root JoinTableQuery
left TableAlias<LTable>
right TableAlias<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>