SelectComponentBase 类

命名空间

ShadowSql.Components

程序集

ShadowSql.Core.dll

数据获取组件基类

public abstract class SelectComponentBase : ISelectComponent

继承

object

SelectComponentBase

实现

ISelectComponent

衍生

MsSqlSelectComponent

MySqlSelectComponent

OracleSelectComponent

PostgresSelectComponent

SqliteSelectComponent

方法

Select(ISqlEngine, StringBuilder, ISelect)

数据获取

public virtual void Select(ISqlEngine engine, StringBuilder sql, ISelect select)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

select ISelect

筛选

SelectCursor(ISqlEngine, StringBuilder, ISelect, ICursor)

数据分页获取

public abstract void SelectCursor(ISqlEngine engine, StringBuilder sql, ISelect select, ICursor cursor)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

select ISelect

筛选

cursor ICursor

游标

WriteFields(ISqlEngine, StringBuilder, ISelectFields)

输出字段

protected virtual void WriteFields(ISqlEngine engine, StringBuilder sql, ISelectFields fields)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

fields ISelectFields

字段

WriteLimit(ISqlEngine, StringBuilder, int)

输出获取数量

public virtual void WriteLimit(ISqlEngine engine, StringBuilder sql, int limit)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

limit int

筛选数量

WriteOffset(ISqlEngine, StringBuilder, int)

输出跳过数量

public virtual void WriteOffset(ISqlEngine engine, StringBuilder sql, int offset)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

offset int

跳过数量

WriteView(ISqlEngine, StringBuilder, ITableView, ISelectFields)

Select查询主体

protected virtual void WriteView(ISqlEngine engine, StringBuilder sql, ITableView view, ISelectFields fields)

参数

engine ISqlEngine

数据库引擎

sql StringBuilder

sql

view ITableView

fields ISelectFields

字段