JoinOnBase 类

命名空间

ShadowSql.Join

程序集

ShadowSql.Core.dll

联表俩俩关联基类

public abstract class JoinOnBase : FilterBase, IMultiView, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

FilterBase

JoinOnBase

实现

IMultiView

ITableView

ISqlEntity

Derived

JoinOnBase<TJoinTable, TLeft, TRight, LTable, RTable, TFilter>

JoinOnCoreBase<TJoinTable, TFilter>

继承成员

FilterBase.WriteFilter(ISqlEngine, StringBuilder)

FilterBase.WriteCore(ISqlEngine, StringBuilder)

ViewBase.GetFields()

ViewBase.GetCompareField(string)

GetFieldBase.GetField(string)

GetFieldBase.NewField(string)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

扩展方法

DapperShadowServices.ToDapperDelete(IMultiView, IExecutor)

DapperShadowServices.ToDapperSelect(IMultiView, IExecutor)

DapperShadowServices.ToDapperUpdate(IMultiView, IExecutor)

ShadowSqlCoreServices.Alias<TTable>(IMultiView, string)

ShadowSqlCoreServices.From(IMultiView, string)

ShadowSqlCoreServices.From<TAliasTable>(IMultiView, string)

ShadowSqlCoreServices.TableCompare(IMultiView, string, string)

ShadowSqlCoreServices.ToDelete(IMultiView)

ShadowSqlServices.ToSelect(IMultiView)

ShadowSqlServices.ToSingle(IMultiView, Func<IMultiView, IFieldView>)

ShadowSqlServices.ToUpdate(IMultiView)

DapperShadowCoreServices.Count(ITableView, IExecutor, object?)

DapperShadowCoreServices.CountAsync(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCount(ITableView, IExecutor, object?)

DapperShadowCoreServices.LongCountAsync(ITableView, IExecutor, object?)

ShadowSqlCoreServices.AsExists(ITableView)

ShadowSqlCoreServices.AsNotExists(ITableView)

ShadowSqlCoreServices.Field(ITableView, string)

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

ShadowSqlCoreServices.Strict(ITableView, string)

ShadowSqlCoreServices.AsInnerJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsLeftJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsOuterJoin<TjoinOn>(TjoinOn)

ShadowSqlCoreServices.AsRightJoin<TjoinOn>(TjoinOn)

字段

_tables

成员表

protected readonly List<IAliasTable> _tables

字段值

List<IAliasTable>

属性

JoinType

联表类型

public string JoinType { get; }

属性值

string

Tables

成员表

public IEnumerable<IAliasTable> Tables { get; }

属性值

IEnumerable<IAliasTable>

方法

FilterPrefix(ISqlEngine, StringBuilder)

筛选前缀

protected override void FilterPrefix(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

GetLeftCompareField(string)

左边比较字段

public ICompareView GetLeftCompareField(string fieldName)

参数

fieldName string

返回

ICompareView

GetLeftField(string)

获取左边列

public abstract IPrefixField? GetLeftField(string fieldName)

参数

fieldName string

返回

IPrefixField

GetMember(string)

获取联表成员

public abstract IAliasTable? GetMember(string tableName)

参数

tableName string

返回

IAliasTable

GetPrefixField(string)

获取列

public IPrefixField? GetPrefixField(string fieldName)

参数

fieldName string

返回

IPrefixField

GetRightCompareField(string)

右边比较字段

public ICompareView GetRightCompareField(string fieldName)

参数

fieldName string

返回

ICompareView

GetRightField(string)

获取右边列

public abstract IPrefixField? GetRightField(string fieldName)

参数

fieldName string

返回

IPrefixField

LeftField(string)

获取右边字段

public abstract IField LeftField(string fieldName)

参数

fieldName string

返回

IField

RightField(string)

获取右边字段

public abstract IField RightField(string fieldName)

参数

fieldName string

返回

IField

WriteRightSource(ISqlEngine, StringBuilder)

拼写联接右表

protected abstract void WriteRightSource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

WriteSource(ISqlEngine, StringBuilder)

拼写数据源

protected override void WriteSource(ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder