Table of Contents

JoinOnSqlQuery<LTable, RTable> 类

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

联表俩俩关联查询

public class JoinOnSqlQuery<LTable, RTable> : JoinOnBase<JoinTableSqlQuery, TableAlias<LTable>, TableAlias<RTable>, LTable, RTable, SqlQuery>, IJoinOn, IMultiView, IDataSqlQuery, IDataFilter, ITableView, ISqlEntity where LTable : ITable where RTable : ITable

类型参数

LTable
RTable
继承
JoinOnBase<JoinTableSqlQuery, TableAlias<LTable>, TableAlias<RTable>, LTable, RTable, SqlQuery>
JoinOnSqlQuery<LTable, RTable>
实现
继承成员
扩展方法

构造函数

JoinOnSqlQuery(JoinTableSqlQuery, TableAlias<LTable>, TableAlias<RTable>)

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery root, TableAlias<LTable> left, TableAlias<RTable> right)

参数

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

JoinOnSqlQuery(JoinTableSqlQuery, TableAlias<LTable>, TableAlias<RTable>, SqlQuery)

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery root, TableAlias<LTable> left, TableAlias<RTable> right, SqlQuery onQuery)

参数

root JoinTableSqlQuery
left TableAlias<LTable>
right TableAlias<RTable>
onQuery SqlQuery

方法

OnLeft(Func<LTable, IColumn>, Func<IPrefixField, AtomicLogic>)

按逻辑查询

public JoinOnSqlQuery<LTable, RTable> OnLeft(Func<LTable, IColumn> select, Func<IPrefixField, AtomicLogic> query)

参数

select Func<LTable, IColumn>
query Func<IPrefixField, AtomicLogic>

返回

JoinOnSqlQuery<LTable, RTable>

OnRight(Func<RTable, IColumn>, Func<IPrefixField, AtomicLogic>)

按逻辑查询

public JoinOnSqlQuery<LTable, RTable> OnRight(Func<RTable, IColumn> select, Func<IPrefixField, AtomicLogic> query)

参数

select Func<RTable, IColumn>
query Func<IPrefixField, AtomicLogic>

返回

JoinOnSqlQuery<LTable, RTable>

WhereLeft(Func<LTable, IColumn>, Func<IPrefixField, AtomicLogic>)

按逻辑查询

public JoinOnSqlQuery<LTable, RTable> WhereLeft(Func<LTable, IColumn> select, Func<IPrefixField, AtomicLogic> query)

参数

select Func<LTable, IColumn>
query Func<IPrefixField, AtomicLogic>

返回

JoinOnSqlQuery<LTable, RTable>

WhereRight(Func<RTable, IColumn>, Func<IPrefixField, AtomicLogic>)

按逻辑查询

public JoinOnSqlQuery<LTable, RTable> WhereRight(Func<RTable, IColumn> select, Func<IPrefixField, AtomicLogic> query)

参数

select Func<RTable, IColumn>
query Func<IPrefixField, AtomicLogic>

返回

JoinOnSqlQuery<LTable, RTable>
编辑本文