Table of Contents

JoinOnSqlQuery<LTable, RTable> 类

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

联表俩俩关联查询

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

类型参数

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

构造函数

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

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery joinTable, IAliasTable<LTable> left, IAliasTable<RTable> right)

参数

joinTable JoinTableSqlQuery

联表

left IAliasTable<LTable>

左

right IAliasTable<RTable>

右

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

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery joinTable, IAliasTable<LTable> left, IAliasTable<RTable> right, SqlQuery onQuery)

参数

joinTable JoinTableSqlQuery

联表

left IAliasTable<LTable>

左

right IAliasTable<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>
编辑本文