AliasJoinOnSqlQuery<TLeft, TRight> 类

命名空间

ShadowSql.Join

程序集

ShadowSql.dll

联表俩俩关联查询

public class AliasJoinOnSqlQuery<TLeft, TRight> : JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>, IJoinOn, IMultiView, IDataSqlQuery, IDataFilter, ITableView, ISqlEntity, IWrapper<ITableView> where TLeft : IAliasTable<ITable> where TRight : IAliasTable<ITable>

类型参数

TLeft

TRight

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>

AliasJoinOnSqlQuery<TLeft, TRight>

实现

IJoinOn

IMultiView

IDataSqlQuery

IDataFilter

ITableView

ISqlEntity

IWrapper<ITableView>

继承成员

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>._root

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.Root

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>._left

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>._source

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.Left

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.Source

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.PrefixFields

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.GetLeftField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.GetRightField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.LeftField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.RightField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.GetMember(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.GetFields()

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.GetField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.NewField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.GetCompareField(string)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnBase<JoinTableSqlQuery, TLeft, TRight, ITable, ITable, SqlQuery>.WriteFilter(ISqlEngine, StringBuilder)

JoinOnBase.JoinType

JoinOnBase._tables

JoinOnBase.Tables

JoinOnBase.GetLeftField(string)

JoinOnBase.GetRightField(string)

JoinOnBase.GetPrefixField(string)

JoinOnBase.LeftField(string)

JoinOnBase.RightField(string)

JoinOnBase.GetLeftCompareField(string)

JoinOnBase.GetRightCompareField(string)

JoinOnBase.GetMember(string)

JoinOnBase.FilterPrefix(ISqlEngine, StringBuilder)

JoinOnBase.WriteRightSource(ISqlEngine, StringBuilder)

JoinOnBase.WriteSource(ISqlEngine, StringBuilder)

FilterBase.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetCompareField(string)

GetFieldBase.GetFields()

GetFieldBase.GetField(string)

GetFieldBase.NewField(string)

扩展方法

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlServices.ToSelect(IMultiView)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?, CancellationToken)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?, CancellationToken)

ShadowSqlCoreServices.Field(ITableView, string)

ShadowSqlCoreServices.Fields(ITableView, params IEnumerable<string>)

ShadowSqlCoreServices.Strict(ITableView, string)

FieldQueryServices.FieldBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreaterEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldGreaterValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldGreater<TQuery>(TQuery, string, string)

FieldQueryServices.FieldInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldIsNull<TQuery>(TQuery, string)

FieldQueryServices.FieldLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLessEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLessValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldLess<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

FieldQueryServices.FieldNotBetween<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

FieldQueryServices.FieldNotEqual<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

FieldQueryServices.FieldNotIn<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLikeValue<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotLike<TQuery>(TQuery, string, string)

FieldQueryServices.FieldNotNull<TQuery>(TQuery, string)

FieldQueryServices.FieldParameter<TQuery>(TQuery, string, string, string)

FieldQueryServices.FieldValue<TQuery, TValue>(TQuery, string, TValue, string)

FieldQueryServices.TableFieldParameter<TQuery>(TQuery, string, string, string, string)

ShadowSqlExtendServices.LeftTableJoin<TLeft, TRight, TAliasTable>(AliasJoinOnSqlQuery<TLeft, TRight>, TAliasTable)

ShadowSqlExtendServices.RightTableJoin<TLeft, TRight, TAliasTable>(AliasJoinOnSqlQuery<TLeft, TRight>, TAliasTable)

ShadowSqlServices.Apply<TLeft, TRight>(AliasJoinOnSqlQuery<TLeft, TRight>, Func<SqlQuery, TLeft, TRight, SqlQuery>)

ShadowSqlServices.On<TLeft, TRight>(AliasJoinOnSqlQuery<TLeft, TRight>, Func<TLeft, IPrefixField>, CompareSymbol, Func<TRight, IPrefixField>)

ShadowSqlServices.On<TLeft, TRight>(AliasJoinOnSqlQuery<TLeft, TRight>, Func<TLeft, IPrefixField>, Func<TRight, IPrefixField>)

ShadowSqlServices.On<TLeft, TRight>(AliasJoinOnSqlQuery<TLeft, TRight>, Func<TLeft, TRight, AtomicLogic>)

ShadowSqlServices.SqlGroupBy<TLeft, TRight>(AliasJoinOnSqlQuery<TLeft, TRight>, Func<TLeft, TRight, IPrefixField[]>)

ShadowSqlServices.WhereLeft<TJoinOn>(TJoinOn, string, Func<ICompareView, AtomicLogic>)

ShadowSqlServices.WhereRight<TJoinOn>(TJoinOn, string, Func<ICompareView, AtomicLogic>)

StrictQueryServices.StrictBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreaterEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictGreaterValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictGreater<TQuery>(TQuery, string, string)

StrictQueryServices.StrictInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictIsNull<TQuery>(TQuery, string)

StrictQueryServices.StrictLessEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLessEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLessValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictLess<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotBetweenValue<TQuery, TValue>(TQuery, string, TValue, TValue)

StrictQueryServices.StrictNotBetween<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictNotEqualValue<TQuery, TValue>(TQuery, string, TValue)

StrictQueryServices.StrictNotEqual<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotInValue<TQuery, TValue>(TQuery, string, params IEnumerable<TValue>)

StrictQueryServices.StrictNotIn<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLikeValue<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotLike<TQuery>(TQuery, string, string)

StrictQueryServices.StrictNotNull<TQuery>(TQuery, string)

StrictQueryServices.StrictParameter<TQuery>(TQuery, string, string, string)

StrictQueryServices.StrictValue<TQuery, TValue>(TQuery, string, TValue, string)

StrictQueryServices.TableStrictParameter<TQuery>(TQuery, string, string, string, string)

ShadowSqlServices.ToSelect(IJoinOn)

ShadowSqlServices.ToSelect(IJoinOn)

构造函数

AliasJoinOnSqlQuery(JoinTableSqlQuery, TLeft, TRight)

联表俩俩关联查询

public AliasJoinOnSqlQuery(JoinTableSqlQuery joinTable, TLeft left, TRight right)

参数

joinTable JoinTableSqlQuery

联表

left TLeft

左

right TRight

右

AliasJoinOnSqlQuery(JoinTableSqlQuery, TLeft, TRight, SqlQuery)

联表俩俩关联查询

public AliasJoinOnSqlQuery(JoinTableSqlQuery joinTable, TLeft left, TRight right, SqlQuery onSqlQuery)

参数

joinTable JoinTableSqlQuery

联表

left TLeft

左

right TRight

右

onSqlQuery SqlQuery

联表查询

方法

OnLeft(Func<TLeft, AtomicLogic>)

按逻辑查询

public AliasJoinOnSqlQuery<TLeft, TRight> OnLeft(Func<TLeft, AtomicLogic> query)

参数

query Func<TLeft, AtomicLogic>

查询

返回

AliasJoinOnSqlQuery<TLeft, TRight>

OnRight(Func<TRight, AtomicLogic>)

按逻辑查询

public AliasJoinOnSqlQuery<TLeft, TRight> OnRight(Func<TRight, AtomicLogic> query)

参数

query Func<TRight, AtomicLogic>

查询

返回

AliasJoinOnSqlQuery<TLeft, TRight>

WhereLeft(Func<TLeft, AtomicLogic>)

按逻辑查询

public AliasJoinOnSqlQuery<TLeft, TRight> WhereLeft(Func<TLeft, AtomicLogic> query)

参数

query Func<TLeft, AtomicLogic>

查询

返回

AliasJoinOnSqlQuery<TLeft, TRight>

WhereRight(Func<TRight, AtomicLogic>)

按逻辑查询

public AliasJoinOnSqlQuery<TLeft, TRight> WhereRight(Func<TRight, AtomicLogic> query)

参数

query Func<TRight, AtomicLogic>

查询

返回

AliasJoinOnSqlQuery<TLeft, TRight>