Table of Contents

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 where LTable : ITable where RTable : ITable

类型参数

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

构造函数

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