Table of Contents

JoinOnSqlQuery<TLeft, TRight> 类

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

联表俩俩关联查询

public class JoinOnSqlQuery<TLeft, TRight> : JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>, IJoinOn, IMultiView, IDataSqlQuery, IDataFilter, ITableView, ISqlEntity, IWrapper<ITableView>

类型参数

TLeft
TRight
继承
object
JoinOnBase
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>
JoinOnSqlQuery<TLeft, TRight>
实现
IJoinOn
IMultiView
IDataSqlQuery
IWrapper<ITableView>
继承成员
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>._root
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.Root
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>._left
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>._source
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.Left
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.Source
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.PrefixFields
JoinOnCoreBase<JoinTableSqlQuery, SqlQuery>.GetFields()
JoinOnBase.JoinType
JoinOnBase._tables
JoinOnBase.Tables
扩展方法

构造函数

JoinOnSqlQuery(JoinTableSqlQuery, IAliasTable, IAliasTable)

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery joinTable, IAliasTable left, IAliasTable right)

参数

joinTable JoinTableSqlQuery

联表

left IAliasTable

左

right IAliasTable

右

JoinOnSqlQuery(JoinTableSqlQuery, IAliasTable, IAliasTable, SqlQuery)

联表俩俩关联查询

public JoinOnSqlQuery(JoinTableSqlQuery joinTable, IAliasTable left, IAliasTable right, SqlQuery onQuery)

参数

joinTable JoinTableSqlQuery

联表

left IAliasTable

左

right IAliasTable

右

onQuery SqlQuery

联表查询

方法

On(Expression<Func<TLeft, TRight, bool>>)

联表查询

public JoinOnSqlQuery<TLeft, TRight> On(Expression<Func<TLeft, TRight, bool>> query)

参数

query Expression<Func<TLeft, TRight, bool>>

查询

返回

JoinOnSqlQuery<TLeft, TRight>

OnLeft(Expression<Func<TLeft, bool>>)

按逻辑查询

public JoinOnSqlQuery<TLeft, TRight> OnLeft(Expression<Func<TLeft, bool>> query)

参数

query Expression<Func<TLeft, bool>>

查询

返回

JoinOnSqlQuery<TLeft, TRight>

OnRight(Expression<Func<TRight, bool>>)

按逻辑查询

public JoinOnSqlQuery<TLeft, TRight> OnRight(Expression<Func<TRight, bool>> query)

参数

query Expression<Func<TRight, bool>>

查询

返回

JoinOnSqlQuery<TLeft, TRight>

On<TKey>(Expression<Func<TLeft, TKey>>, Expression<Func<TRight, TKey>>)

按字段联表

public JoinOnSqlQuery<TLeft, TRight> On<TKey>(Expression<Func<TLeft, TKey>> left, Expression<Func<TRight, TKey>> right)

参数

left Expression<Func<TLeft, TKey>>

左

right Expression<Func<TRight, TKey>>

右

返回

JoinOnSqlQuery<TLeft, TRight>

类型参数

TKey

WhereLeft(Expression<Func<TLeft, bool>>)

按逻辑查询

public JoinOnSqlQuery<TLeft, TRight> WhereLeft(Expression<Func<TLeft, bool>> query)

参数

query Expression<Func<TLeft, bool>>

查询

返回

JoinOnSqlQuery<TLeft, TRight>

WhereRight(Expression<Func<TRight, bool>>)

按逻辑查询

public JoinOnSqlQuery<TLeft, TRight> WhereRight(Expression<Func<TRight, bool>> query)

参数

query Expression<Func<TRight, bool>>

查询

返回

JoinOnSqlQuery<TLeft, TRight>
编辑本文