MultiTableCursor 类

命名空间

ShadowSql.Cursors

程序集

ShadowSql.dll

多联表范围筛选游标

public class MultiTableCursor : CursorBase<IMultiView>, ICursor, ITableView, ISqlEntity

继承

object

GetFieldBase

ViewBase

TableViewBase

CursorBase

CursorBase<IMultiView>

MultiTableCursor

实现

ICursor

ITableView

ISqlEntity

衍生

DapperMultiTableCursor

继承成员

CursorBase<IMultiView>._source

CursorBase<IMultiView>.Source

CursorBase<IMultiView>.WriteCore(ISqlEngine, StringBuilder)

CursorBase<IMultiView>.WriteSource(ISqlEngine, StringBuilder)

CursorBase<IMultiView>.GetFields()

CursorBase<IMultiView>.GetField(string)

CursorBase<IMultiView>.GetCompareField(string)

CursorBase<IMultiView>.NewField(string)

CursorBase._limit

CursorBase._offset

CursorBase.Limit

CursorBase.Offset

CursorBase.CheckAsc(string)

CursorBase.CheckDesc(string)

CursorBase.WriteOrderBy(ISqlEngine, StringBuilder)

扩展方法

DapperShadowServices.ToDapperSelect(MultiTableCursor, IExecutor)

ShadowSqlServices.ToSelect(MultiTableCursor)

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

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)

构造函数

MultiTableCursor(IMultiView, int, int)

多联表范围筛选游标

public MultiTableCursor(IMultiView multiView, int limit = 0, int offset = 0)

参数

multiView IMultiView

多(联)表

limit int

筛选数量

offset int

跳过数量

方法

Asc<TTable>(string, Func<TTable, IColumn>)

正序

public MultiTableCursor Asc<TTable>(string tableName, Func<TTable, IColumn> select) where TTable : ITable

参数

tableName string

表名

select Func<TTable, IColumn>

筛选

返回

MultiTableCursor

类型参数

TTable

Asc<TAliasTable>(string, Func<TAliasTable, IOrderView>)

正序

public MultiTableCursor Asc<TAliasTable>(string tableName, Func<TAliasTable, IOrderView> select) where TAliasTable : IAliasTable

参数

tableName string

表名

select Func<TAliasTable, IOrderView>

筛选

返回

MultiTableCursor

类型参数

TAliasTable

Desc<TTable>(string, Func<TTable, IColumn>)

倒序

public MultiTableCursor Desc<TTable>(string tableName, Func<TTable, IColumn> select) where TTable : ITable

参数

tableName string

表名

select Func<TTable, IColumn>

筛选

返回

MultiTableCursor

类型参数

TTable

Desc<TAliasTable>(string, Func<TAliasTable, IOrderAsc>)

倒序

public MultiTableCursor Desc<TAliasTable>(string tableName, Func<TAliasTable, IOrderAsc> select) where TAliasTable : IAliasTable

参数

tableName string

表名

select Func<TAliasTable, IOrderAsc>

筛选

返回

MultiTableCursor

类型参数

TAliasTable