ShadowSqlServices 类

命名空间

ShadowSql.Expressions

程序集

ShadowSql.Expressions.dll

范围筛选游标扩展方法

public static class ShadowSqlServices

继承

object

ShadowSqlServices

继承成员

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

方法

And<TEntity>(JoinTableQuery, Expression<Func<TEntity, bool>>)

直接查询(不建议对重名列查询)

public static JoinTableQuery And<TEntity>(this JoinTableQuery multiTable, Expression<Func<TEntity, bool>> query)

参数

multiTable JoinTableQuery

query Expression<Func<TEntity, bool>>

返回

JoinTableQuery

类型参数

TEntity

And<TEntity>(JoinTableQuery, string, Expression<Func<TEntity, bool>>)

指定表查询

public static JoinTableQuery And<TEntity>(this JoinTableQuery multiTable, string table, Expression<Func<TEntity, bool>> query)

参数

multiTable JoinTableQuery

table string

query Expression<Func<TEntity, bool>>

返回

JoinTableQuery

类型参数

TEntity

And<TEntity>(MultiTableQuery, Expression<Func<TEntity, bool>>)

直接查询(不建议对重名列查询)

public static MultiTableQuery And<TEntity>(this MultiTableQuery multiTable, Expression<Func<TEntity, bool>> query)

参数

multiTable MultiTableQuery

query Expression<Func<TEntity, bool>>

返回

MultiTableQuery

类型参数

TEntity

And<TEntity>(MultiTableQuery, string, Expression<Func<TEntity, bool>>)

指定表查询

public static MultiTableQuery And<TEntity>(this MultiTableQuery multiTable, string table, Expression<Func<TEntity, bool>> query)

参数

multiTable MultiTableQuery

table string

query Expression<Func<TEntity, bool>>

返回

MultiTableQuery

类型参数

TEntity

And<TMultiTable, TEntity>(TMultiTable, Expression<Func<TEntity, bool>>)

直接查询(不建议对重名列查询)

public static TMultiTable And<TMultiTable, TEntity>(this TMultiTable multiTable, Expression<Func<TEntity, bool>> query) where TMultiTable : MultiTableBase, IDataQuery

参数

multiTable TMultiTable

query Expression<Func<TEntity, bool>>

返回

TMultiTable

类型参数

TMultiTable

TEntity

And<TMultiTable, TEntity>(TMultiTable, string, Expression<Func<TEntity, bool>>)

指定表查询

public static TMultiTable And<TMultiTable, TEntity>(this TMultiTable multiTable, string table, Expression<Func<TEntity, bool>> query) where TMultiTable : MultiTableBase, IDataQuery

参数

multiTable TMultiTable

table string

query Expression<Func<TEntity, bool>>

返回

TMultiTable

类型参数

TMultiTable

TEntity

CountAsc<TGroupByCursor>(TGroupByCursor)

计数正序

public static TGroupByCursor CountAsc<TGroupByCursor>(this TGroupByCursor cursor) where TGroupByCursor : GroupByCursorBase

参数

cursor TGroupByCursor

返回

TGroupByCursor

类型参数

TGroupByCursor

CountDesc<TGroupByCursor>(TGroupByCursor)

计数倒序

public static TGroupByCursor CountDesc<TGroupByCursor>(this TGroupByCursor cursor) where TGroupByCursor : GroupByCursorBase

参数

cursor TGroupByCursor

返回

TGroupByCursor

类型参数

TGroupByCursor

GetAssignFields<TTable>(IAliasTable<TTable>)

获取被修改字段

public static IEnumerable<IPrefixField> GetAssignFields<TTable>(this IAliasTable<TTable> aliasTable) where TTable : ITable

参数

aliasTable IAliasTable<TTable>

返回

IEnumerable<IPrefixField>

类型参数

TTable

异常

ArgumentException

GroupBy<TKey, TEntity>(AliasTableQuery<TEntity>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this AliasTableQuery<TEntity> query, Expression<Func<TEntity, TKey>> select)

参数

query AliasTableQuery<TEntity>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TKey, TEntity>(TableQuery<TEntity>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this TableQuery<TEntity> query, Expression<Func<TEntity, TKey>> select)

参数

query TableQuery<TEntity>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TKey, TEntity>(IAliasTable, Expression<Func<TEntity, bool>>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this IAliasTable table, Expression<Func<TEntity, bool>> where, Expression<Func<TEntity, TKey>> select)

参数

table IAliasTable

where Expression<Func<TEntity, bool>>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TKey, TEntity>(IAliasTable, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this IAliasTable table, Expression<Func<TEntity, TKey>> select)

参数

table IAliasTable

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, bool>>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this ITable table, Expression<Func<TEntity, bool>> where, Expression<Func<TEntity, TKey>> select)

参数

table ITable

where Expression<Func<TEntity, bool>>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this ITable table, Expression<Func<TEntity, TKey>> select)

参数

table ITable

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TKey, TEntity>(TableQuery, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> GroupBy<TKey, TEntity>(this TableQuery query, Expression<Func<TEntity, TKey>> select)

参数

query TableQuery

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

GroupBy<TLeft, TRight, TKey>(JoinOnQuery<TLeft, TRight>, Expression<Func<TLeft, TRight, TKey>>)

分组查询

public static GroupByMultiQuery<TKey> GroupBy<TLeft, TRight, TKey>(this JoinOnQuery<TLeft, TRight> joinOn, Expression<Func<TLeft, TRight, TKey>> select)

参数

joinOn JoinOnQuery<TLeft, TRight>

select Expression<Func<TLeft, TRight, TKey>>

返回

GroupByMultiQuery<TKey>

类型参数

TLeft

TRight

TKey

Join<TLeft, TRight>(ITable, ITable)

联表(创建新联表)

public static JoinOnQuery<TLeft, TRight> Join<TLeft, TRight>(this ITable main, ITable table)

参数

main ITable

table ITable

返回

JoinOnQuery<TLeft, TRight>

类型参数

TLeft

TRight

LeftTableJoin<TLeft, TRight, TOther>(JoinOnQuery<TLeft, TRight>, ITable)

用左表联新表

public static JoinOnQuery<TLeft, TOther> LeftTableJoin<TLeft, TRight, TOther>(this JoinOnQuery<TLeft, TRight> joinOn, ITable table)

参数

joinOn JoinOnQuery<TLeft, TRight>

table ITable

返回

JoinOnQuery<TLeft, TOther>

类型参数

TLeft

TRight

TOther

LeftTableJoin<TLeft, TRight, TOther>(JoinOnSqlQuery<TLeft, TRight>, ITable)

用左表联新表

public static JoinOnSqlQuery<TLeft, TOther> LeftTableJoin<TLeft, TRight, TOther>(this JoinOnSqlQuery<TLeft, TRight> joinOn, ITable table)

参数

joinOn JoinOnSqlQuery<TLeft, TRight>

table ITable

返回

JoinOnSqlQuery<TLeft, TOther>

类型参数

TLeft

TRight

TOther

Or<TEntity>(JoinTableQuery, string, Expression<Func<TEntity, bool>>)

指定表查询

public static JoinTableQuery Or<TEntity>(this JoinTableQuery multiTable, string table, Expression<Func<TEntity, bool>> query)

参数

multiTable JoinTableQuery

table string

query Expression<Func<TEntity, bool>>

返回

JoinTableQuery

类型参数

TEntity

Or<TEntity>(MultiTableQuery, Expression<Func<TEntity, bool>>)

直接查询(不建议对重名列查询)

public static MultiTableQuery Or<TEntity>(this MultiTableQuery multiTable, Expression<Func<TEntity, bool>> query)

参数

multiTable MultiTableQuery

query Expression<Func<TEntity, bool>>

返回

MultiTableQuery

类型参数

TEntity

Or<TEntity>(MultiTableQuery, string, Expression<Func<TEntity, bool>>)

指定表查询

public static MultiTableQuery Or<TEntity>(this MultiTableQuery multiTable, string table, Expression<Func<TEntity, bool>> query)

参数

multiTable MultiTableQuery

table string

query Expression<Func<TEntity, bool>>

返回

MultiTableQuery

类型参数

TEntity

Or<TMultiTable, TEntity>(TMultiTable, Expression<Func<TEntity, bool>>)

直接查询(不建议对重名列查询)

public static TMultiTable Or<TMultiTable, TEntity>(this TMultiTable multiTable, Expression<Func<TEntity, bool>> query) where TMultiTable : MultiTableBase, IDataQuery

参数

multiTable TMultiTable

query Expression<Func<TEntity, bool>>

返回

TMultiTable

类型参数

TMultiTable

TEntity

Or<TMultiTable, TEntity>(TMultiTable, string, Expression<Func<TEntity, bool>>)

指定表查询

public static TMultiTable Or<TMultiTable, TEntity>(this TMultiTable multiTable, string table, Expression<Func<TEntity, bool>> query) where TMultiTable : MultiTableBase, IDataQuery

参数

multiTable TMultiTable

table string

query Expression<Func<TEntity, bool>>

返回

TMultiTable

类型参数

TMultiTable

TEntity

RightTableJoin<TLeft, TRight, TOther>(JoinOnQuery<TLeft, TRight>, ITable)

用右表联新表

public static JoinOnQuery<TRight, TOther> RightTableJoin<TLeft, TRight, TOther>(this JoinOnQuery<TLeft, TRight> joinOn, ITable table)

参数

joinOn JoinOnQuery<TLeft, TRight>

table ITable

返回

JoinOnQuery<TRight, TOther>

类型参数

TLeft

TRight

TOther

RightTableJoin<TLeft, TRight, TOther>(JoinOnSqlQuery<TLeft, TRight>, ITable)

用右表联新表

public static JoinOnSqlQuery<TRight, TOther> RightTableJoin<TLeft, TRight, TOther>(this JoinOnSqlQuery<TLeft, TRight> joinOn, ITable table)

参数

joinOn JoinOnSqlQuery<TLeft, TRight>

table ITable

返回

JoinOnSqlQuery<TRight, TOther>

类型参数

TLeft

TRight

TOther

SelectTable<TMultiTableSelect>(TMultiTableSelect, IAliasTable)

添加表

public static TMultiTableSelect SelectTable<TMultiTableSelect>(this TMultiTableSelect multiSelect, IAliasTable aliasTable) where TMultiTableSelect : SelectFieldsBase, IMultiSelect

参数

multiSelect TMultiTableSelect

aliasTable IAliasTable

返回

TMultiTableSelect

类型参数

TMultiTableSelect

SelectTable<TMultiTableSelect>(TMultiTableSelect, string)

添加表

public static TMultiTableSelect SelectTable<TMultiTableSelect>(this TMultiTableSelect multiSelect, string tableName) where TMultiTableSelect : SelectFieldsBase, IMultiSelect

参数

multiSelect TMultiTableSelect

tableName string

返回

TMultiTableSelect

类型参数

TMultiTableSelect

Set<TEntity>(MultiTableUpdate, Expression<Func<TEntity, TEntity>>)

赋值操作

public static MultiTableUpdate Set<TEntity>(this MultiTableUpdate update, Expression<Func<TEntity, TEntity>> operation)

参数

update MultiTableUpdate

operation Expression<Func<TEntity, TEntity>>

返回

MultiTableUpdate

类型参数

TEntity

SqlGroupBy<TKey, TEntity>(AliasTableSqlQuery<TEntity>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this AliasTableSqlQuery<TEntity> query, Expression<Func<TEntity, TKey>> select)

参数

query AliasTableSqlQuery<TEntity>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TKey, TEntity>(TableSqlQuery<TEntity>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableSqlQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this TableSqlQuery<TEntity> SqlQuery, Expression<Func<TEntity, TKey>> select)

参数

SqlQuery TableSqlQuery<TEntity>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableSqlQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TKey, TEntity>(IAliasTable, Expression<Func<TEntity, bool>>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this IAliasTable table, Expression<Func<TEntity, bool>> where, Expression<Func<TEntity, TKey>> select)

参数

table IAliasTable

where Expression<Func<TEntity, bool>>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TKey, TEntity>(IAliasTable, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this IAliasTable table, Expression<Func<TEntity, TKey>> select)

参数

table IAliasTable

select Expression<Func<TEntity, TKey>>

返回

GroupByTableQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, bool>>, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableSqlQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this ITable table, Expression<Func<TEntity, bool>> where, Expression<Func<TEntity, TKey>> select)

参数

table ITable

where Expression<Func<TEntity, bool>>

select Expression<Func<TEntity, TKey>>

返回

GroupByTableSqlQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TKey, TEntity>(ITable, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableSqlQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this ITable table, Expression<Func<TEntity, TKey>> select)

参数

table ITable

select Expression<Func<TEntity, TKey>>

返回

GroupByTableSqlQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TKey, TEntity>(TableSqlQuery, Expression<Func<TEntity, TKey>>)

分组查询

public static GroupByTableSqlQuery<TKey, TEntity> SqlGroupBy<TKey, TEntity>(this TableSqlQuery SqlQuery, Expression<Func<TEntity, TKey>> select)

参数

SqlQuery TableSqlQuery

select Expression<Func<TEntity, TKey>>

返回

GroupByTableSqlQuery<TKey, TEntity>

类型参数

TKey

TEntity

SqlGroupBy<TLeft, TRight, TKey>(JoinOnSqlQuery<TLeft, TRight>, Expression<Func<TLeft, TRight, TKey>>)

分组查询

public static GroupByMultiQuery<TKey> SqlGroupBy<TLeft, TRight, TKey>(this JoinOnSqlQuery<TLeft, TRight> joinOn, Expression<Func<TLeft, TRight, TKey>> select)

参数

joinOn JoinOnSqlQuery<TLeft, TRight>

select Expression<Func<TLeft, TRight, TKey>>

返回

GroupByMultiQuery<TKey>

类型参数

TLeft

TRight

TKey

SqlJoin<TLeft, TRight>(ITable, ITable)

联表(创建新联表)

public static JoinOnSqlQuery<TLeft, TRight> SqlJoin<TLeft, TRight>(this ITable main, ITable table)

参数

main ITable

table ITable

返回

JoinOnSqlQuery<TLeft, TRight>

类型参数

TLeft

TRight

Take(MultiTableBase, int, int)

多联表范围筛选

public static MultiTableCursor Take(this MultiTableBase query, int limit, int offset = 0)

参数

query MultiTableBase

limit int

offset int

返回

MultiTableCursor

Take(TableQuery, int, int)

表查询范围筛选

public static TableCursor<ITable> Take(this TableQuery query, int limit, int offset = 0)

参数

query TableQuery

limit int

offset int

返回

TableCursor<ITable>

Take(TableSqlQuery, int, int)

表查询范围筛选

public static TableCursor<ITable> Take(this TableSqlQuery query, int limit, int offset = 0)

参数

query TableSqlQuery

limit int

offset int

返回

TableCursor<ITable>

Take<TEntity>(AliasTableQuery<TEntity>, int, int)

别名表查询范围筛选

public static TableCursor<TEntity> Take<TEntity>(this AliasTableQuery<TEntity> query, int limit, int offset = 0)

参数

query AliasTableQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TEntity>(AliasTableSqlQuery<TEntity>, int, int)

别名表查询范围筛选

public static TableCursor<TEntity> Take<TEntity>(this AliasTableSqlQuery<TEntity> query, int limit, int offset = 0)

参数

query AliasTableSqlQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<Key>(GroupByMultiQuery<Key>, int, int)

多(联)表分组后范围筛选

public static GroupByMultiCursor<Key> Take<Key>(this GroupByMultiQuery<Key> groupBy, int limit, int offset = 0)

参数

groupBy GroupByMultiQuery<Key>

limit int

offset int

返回

GroupByMultiCursor<Key>

类型参数

Key

Take<Key>(GroupByMultiSqlQuery<Key>, int, int)

多(联)表分组后范围筛选

public static GroupByMultiCursor<Key> Take<Key>(this GroupByMultiSqlQuery<Key> groupBy, int limit, int offset = 0)

参数

groupBy GroupByMultiSqlQuery<Key>

limit int

offset int

返回

GroupByMultiCursor<Key>

类型参数

Key

Take<TEntity>(TableQuery<TEntity>, int, int)

表查询范围筛选

public static TableCursor<TEntity> Take<TEntity>(this TableQuery<TEntity> query, int limit, int offset = 0)

参数

query TableQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TEntity>(TableSqlQuery<TEntity>, int, int)

表查询范围筛选

public static TableCursor<TEntity> Take<TEntity>(this TableSqlQuery<TEntity> query, int limit, int offset = 0)

参数

query TableSqlQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TEntity>(IAliasTable, ISqlLogic, int, int)

别名表范围筛选

public static TableCursor<TEntity> Take<TEntity>(this IAliasTable source, ISqlLogic where, int limit, int offset = 0)

参数

source IAliasTable

where ISqlLogic

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TEntity>(IAliasTable, int, int)

别名表范围筛选

public static TableCursor<TEntity> Take<TEntity>(this IAliasTable source, int limit, int offset = 0)

参数

source IAliasTable

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TEntity>(ITable, ISqlLogic, int, int)

表范围筛选

public static TableCursor<TEntity> Take<TEntity>(this ITable source, ISqlLogic where, int limit, int offset = 0)

参数

source ITable

where ISqlLogic

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TEntity>(ITable, int, int)

表范围筛选

public static TableCursor<TEntity> Take<TEntity>(this ITable source, int limit, int offset = 0)

参数

source ITable

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

Take<TKey, TEntity>(GroupByTableQuery<TKey, TEntity>, int, int)

表分组后范围筛选

public static GroupByTableCursor<TKey, TEntity> Take<TKey, TEntity>(this GroupByTableQuery<TKey, TEntity> groupBy, int limit, int offset = 0)

参数

groupBy GroupByTableQuery<TKey, TEntity>

limit int

offset int

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TKey

TEntity

Take<TKey, TEntity>(GroupByTableSqlQuery<TKey, TEntity>, int, int)

表分组后范围筛选

public static GroupByTableCursor<TKey, TEntity> Take<TKey, TEntity>(this GroupByTableSqlQuery<TKey, TEntity> groupBy, int limit, int offset = 0)

参数

groupBy GroupByTableSqlQuery<TKey, TEntity>

limit int

offset int

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TKey

TEntity

ToCursor(MultiTableBase, int, int)

多联表范围筛选

public static MultiTableCursor ToCursor(this MultiTableBase query, int limit = 0, int offset = 0)

参数

query MultiTableBase

limit int

offset int

返回

MultiTableCursor

ToCursor(TableQuery, int, int)

表查询范围筛选

public static TableCursor<ITable> ToCursor(this TableQuery query, int limit = 0, int offset = 0)

参数

query TableQuery

limit int

offset int

返回

TableCursor<ITable>

ToCursor(TableSqlQuery, int, int)

表查询范围筛选

public static TableCursor<ITable> ToCursor(this TableSqlQuery query, int limit = 0, int offset = 0)

参数

query TableSqlQuery

limit int

offset int

返回

TableCursor<ITable>

ToCursor<TEntity>(AliasTableQuery<TEntity>, int, int)

别名表查询范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this AliasTableQuery<TEntity> query, int limit = 0, int offset = 0)

参数

query AliasTableQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TEntity>(AliasTableSqlQuery<TEntity>, int, int)

别名表查询范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this AliasTableSqlQuery<TEntity> query, int limit = 0, int offset = 0)

参数

query AliasTableSqlQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<Key>(GroupByMultiQuery<Key>, int, int)

多(联)表分组后范围筛选

public static GroupByMultiCursor<Key> ToCursor<Key>(this GroupByMultiQuery<Key> groupBy, int limit = 0, int offset = 0)

参数

groupBy GroupByMultiQuery<Key>

limit int

offset int

返回

GroupByMultiCursor<Key>

类型参数

Key

ToCursor<Key>(GroupByMultiSqlQuery<Key>, int, int)

多(联)表分组后范围筛选

public static GroupByMultiCursor<Key> ToCursor<Key>(this GroupByMultiSqlQuery<Key> groupBy, int limit = 0, int offset = 0)

参数

groupBy GroupByMultiSqlQuery<Key>

limit int

offset int

返回

GroupByMultiCursor<Key>

类型参数

Key

ToCursor<TEntity>(TableQuery<TEntity>, int, int)

表查询范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this TableQuery<TEntity> query, int limit = 0, int offset = 0)

参数

query TableQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TEntity>(TableSqlQuery<TEntity>, int, int)

表查询范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this TableSqlQuery<TEntity> query, int limit = 0, int offset = 0)

参数

query TableSqlQuery<TEntity>

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TEntity>(IAliasTable, ISqlLogic, int, int)

别名表范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this IAliasTable source, ISqlLogic where, int limit = 0, int offset = 0)

参数

source IAliasTable

where ISqlLogic

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TEntity>(IAliasTable, int, int)

别名表范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this IAliasTable source, int limit = 0, int offset = 0)

参数

source IAliasTable

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TEntity>(ITable, ISqlLogic, int, int)

表范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this ITable source, ISqlLogic where, int limit = 0, int offset = 0)

参数

source ITable

where ISqlLogic

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TEntity>(ITable, int, int)

表范围筛选

public static TableCursor<TEntity> ToCursor<TEntity>(this ITable source, int limit = 0, int offset = 0)

参数

source ITable

limit int

offset int

返回

TableCursor<TEntity>

类型参数

TEntity

ToCursor<TKey, TEntity>(GroupByTableQuery<TKey, TEntity>, int, int)

表分组后范围筛选

public static GroupByTableCursor<TKey, TEntity> ToCursor<TKey, TEntity>(this GroupByTableQuery<TKey, TEntity> groupBy, int limit = 0, int offset = 0)

参数

groupBy GroupByTableQuery<TKey, TEntity>

limit int

offset int

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TKey

TEntity

ToCursor<TKey, TEntity>(GroupByTableSqlQuery<TKey, TEntity>, int, int)

表分组后范围筛选

public static GroupByTableCursor<TKey, TEntity> ToCursor<TKey, TEntity>(this GroupByTableSqlQuery<TKey, TEntity> groupBy, int limit = 0, int offset = 0)

参数

groupBy GroupByTableSqlQuery<TKey, TEntity>

limit int

offset int

返回

GroupByTableCursor<TKey, TEntity>

类型参数

TKey

TEntity

ToDelete<TEntity>(AliasTableQuery<TEntity>)

删除

public static AliasTableDelete ToDelete<TEntity>(this AliasTableQuery<TEntity> query)

参数

query AliasTableQuery<TEntity>

返回

AliasTableDelete

类型参数

TEntity

ToDelete<TEntity>(AliasTableSqlQuery<TEntity>)

删除

public static AliasTableDelete ToDelete<TEntity>(this AliasTableSqlQuery<TEntity> query)

参数

query AliasTableSqlQuery<TEntity>

返回

AliasTableDelete

类型参数

TEntity

ToDelete<TEntity>(TableQuery<TEntity>)

删除

public static TableDelete ToDelete<TEntity>(this TableQuery<TEntity> query)

参数

query TableQuery<TEntity>

返回

TableDelete

类型参数

TEntity

ToDelete<TEntity>(TableSqlQuery<TEntity>)

删除

public static TableDelete ToDelete<TEntity>(this TableSqlQuery<TEntity> query)

参数

query TableSqlQuery<TEntity>

返回

TableDelete

类型参数

TEntity

ToInsert<TEntity>(ITable)

插入

public static SingleInsert<TEntity> ToInsert<TEntity>(this ITable table)

参数

table ITable

返回

SingleInsert<TEntity>

类型参数

TEntity

ToInsert<TEntity>(ITable, Expression<Func<TEntity>>)

插入

public static SingleInsert<TEntity> ToInsert<TEntity>(this ITable table, Expression<Func<TEntity>> select)

参数

table ITable

select Expression<Func<TEntity>>

返回

SingleInsert<TEntity>

类型参数

TEntity

ToInsert<TParameter, TEntity>(ITable, Expression<Func<TParameter, TEntity>>)

插入

public static SingleInsert<TEntity> ToInsert<TParameter, TEntity>(this ITable table, Expression<Func<TParameter, TEntity>> select)

参数

table ITable

select Expression<Func<TParameter, TEntity>>

返回

SingleInsert<TEntity>

类型参数

TParameter

TEntity

ToOrQuery<TEntity>(IAliasTable)

Or查询

public static AliasTableQuery<TEntity> ToOrQuery<TEntity>(this IAliasTable table)

参数

table IAliasTable

返回

AliasTableQuery<TEntity>

类型参数

TEntity

ToOrQuery<TEntity>(ITable)

Or查询

public static TableQuery<TEntity> ToOrQuery<TEntity>(this ITable table)

参数

table ITable

表对象

返回

TableQuery<TEntity>

类型参数

TEntity

ToQuery<TEntity>(IAliasTable)

And查询

public static AliasTableQuery<TEntity> ToQuery<TEntity>(this IAliasTable table)

参数

table IAliasTable

返回

AliasTableQuery<TEntity>

类型参数

TEntity

ToQuery<TEntity>(ITable)

And查询

public static TableQuery<TEntity> ToQuery<TEntity>(this ITable table)

参数

table ITable

表对象

返回

TableQuery<TEntity>

类型参数

TEntity

ToSelect(MultiTableCursor)

多(联)表筛选列

public static MultiTableCursorSelect ToSelect(this MultiTableCursor cursor)

参数

cursor MultiTableCursor

返回

MultiTableCursorSelect

ToSelect(IMultiView)

多(联)表筛选列

public static MultiTableSelect ToSelect(this IMultiView table)

参数

table IMultiView

返回

MultiTableSelect

ToSelect(IJoinOn)

多(联)表筛选列

public static MultiTableSelect ToSelect(this IJoinOn table)

参数

table IJoinOn

返回

MultiTableSelect

ToSelect<TEntity>(AliasTableSqlQuery<TEntity>)

别名表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this AliasTableSqlQuery<TEntity> query)

参数

query AliasTableSqlQuery<TEntity>

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TKey>(GroupByMultiCursor<TKey>)

GroupBy后再范围(分页)及列筛选

public static GroupByMultiCursorSelect<TKey> ToSelect<TKey>(this GroupByMultiCursor<TKey> cursor)

参数

cursor GroupByMultiCursor<TKey>

返回

GroupByMultiCursorSelect<TKey>

类型参数

TKey

ToSelect<TEntity>(TableCursor<TEntity>)

表范围筛选列

public static TableCursorSelect<TEntity> ToSelect<TEntity>(this TableCursor<TEntity> cursor)

参数

cursor TableCursor<TEntity>

返回

TableCursorSelect<TEntity>

类型参数

TEntity

ToSelect<TKey>(GroupByMultiQuery<TKey>)

GroupBy后再筛选列

public static GroupByMultiSelect<TKey> ToSelect<TKey>(this GroupByMultiQuery<TKey> groupBy)

参数

groupBy GroupByMultiQuery<TKey>

返回

GroupByMultiSelect<TKey>

类型参数

TKey

ToSelect<TKey>(GroupByMultiSqlQuery<TKey>)

GroupBy后再筛选列

public static GroupByMultiSelect<TKey> ToSelect<TKey>(this GroupByMultiSqlQuery<TKey> groupBy)

参数

groupBy GroupByMultiSqlQuery<TKey>

返回

GroupByMultiSelect<TKey>

类型参数

TKey

ToSelect<TEntity>(TableQuery<TEntity>)

表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this TableQuery<TEntity> query)

参数

query TableQuery<TEntity>

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(TableSqlQuery<TEntity>)

表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this TableSqlQuery<TEntity> query)

参数

query TableSqlQuery<TEntity>

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(IAliasTable)

别名表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this IAliasTable table)

参数

table IAliasTable

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(IAliasTable, ISqlLogic)

别名表过滤筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this IAliasTable table, ISqlLogic filter)

参数

table IAliasTable

filter ISqlLogic

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(ITable)

表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this ITable table)

参数

table ITable

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(ITable, ISqlLogic)

表过滤筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this ITable table, ISqlLogic filter)

参数

table ITable

filter ISqlLogic

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(ITable, Expression<Func<TEntity, bool>>)

表过滤筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this ITable table, Expression<Func<TEntity, bool>> query)

参数

table ITable

query Expression<Func<TEntity, bool>>

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(TableQuery)

表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this TableQuery query)

参数

query TableQuery

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TEntity>(TableSqlQuery)

表筛选列

public static TableSelect<TEntity> ToSelect<TEntity>(this TableSqlQuery query)

参数

query TableSqlQuery

返回

TableSelect<TEntity>

类型参数

TEntity

ToSelect<TKey, TEntity>(GroupByTableCursor<TKey, TEntity>)

GroupBy后再范围(分页)及列筛选

public static GroupByTableCursorSelect<TKey, TEntity> ToSelect<TKey, TEntity>(this GroupByTableCursor<TKey, TEntity> cursor)

参数

cursor GroupByTableCursor<TKey, TEntity>

返回

GroupByTableCursorSelect<TKey, TEntity>

类型参数

TKey

TEntity

ToSelect<TKey, TEntity>(GroupByTableQuery<TKey, TEntity>)

GroupBy后再筛选列

public static GroupByTableSelect<TKey, TEntity> ToSelect<TKey, TEntity>(this GroupByTableQuery<TKey, TEntity> source)

参数

source GroupByTableQuery<TKey, TEntity>

返回

GroupByTableSelect<TKey, TEntity>

类型参数

TKey

TEntity

ToSelect<TKey, TEntity>(GroupByTableSqlQuery<TKey, TEntity>)

GroupBy后再筛选列

public static GroupByTableSelect<TKey, TEntity> ToSelect<TKey, TEntity>(this GroupByTableSqlQuery<TKey, TEntity> source)

参数

source GroupByTableSqlQuery<TKey, TEntity>

返回

GroupByTableSelect<TKey, TEntity>

类型参数

TKey

TEntity

ToSqlOrQuery<TEntity>(IAliasTable)

Or查询

public static AliasTableSqlQuery<TEntity> ToSqlOrQuery<TEntity>(this IAliasTable table)

参数

table IAliasTable

返回

AliasTableSqlQuery<TEntity>

类型参数

TEntity

ToSqlOrQuery<TEntity>(ITable)

Or查询

public static TableSqlQuery<TEntity> ToSqlOrQuery<TEntity>(this ITable table)

参数

table ITable

表对象

返回

TableSqlQuery<TEntity>

类型参数

TEntity

ToSqlQuery<TEntity>(IAliasTable)

And查询

public static AliasTableSqlQuery<TEntity> ToSqlQuery<TEntity>(this IAliasTable table)

参数

table IAliasTable

返回

AliasTableSqlQuery<TEntity>

类型参数

TEntity

ToSqlQuery<TEntity>(ITable)

And查询

public static TableSqlQuery<TEntity> ToSqlQuery<TEntity>(this ITable table)

参数

table ITable

表对象

返回

TableSqlQuery<TEntity>

类型参数

TEntity

ToUpdate<TEntity>(TableQuery<TEntity>)

修改

public static TableUpdate<TEntity> ToUpdate<TEntity>(this TableQuery<TEntity> tableQuery)

参数

tableQuery TableQuery<TEntity>

返回

TableUpdate<TEntity>

类型参数

TEntity

ToUpdate<TEntity>(TableSqlQuery<TEntity>)

修改

public static TableUpdate<TEntity> ToUpdate<TEntity>(this TableSqlQuery<TEntity> tableQuery)

参数

tableQuery TableSqlQuery<TEntity>

返回

TableUpdate<TEntity>

类型参数

TEntity

ToUpdate<TEntity>(ITable, ISqlLogic)

修改

public static TableUpdate<TEntity> ToUpdate<TEntity>(this ITable table, ISqlLogic where)

参数

table ITable

where ISqlLogic

返回

TableUpdate<TEntity>

类型参数

TEntity

ToUpdate<TEntity>(ITable, Expression<Func<TEntity, bool>>)

修改

public static TableUpdate<TEntity> ToUpdate<TEntity>(this ITable table, Expression<Func<TEntity, bool>> query)

参数

table ITable

query Expression<Func<TEntity, bool>>

返回

TableUpdate<TEntity>

类型参数

TEntity

ToUpdate<TEntity>(TableQuery)

修改

public static TableUpdate<TEntity> ToUpdate<TEntity>(this TableQuery tableQuery)

参数

tableQuery TableQuery

返回

TableUpdate<TEntity>

类型参数

TEntity

ToUpdate<TEntity>(TableSqlQuery)

修改

public static TableUpdate<TEntity> ToUpdate<TEntity>(this TableSqlQuery tableQuery)

参数

tableQuery TableSqlQuery

返回

TableUpdate<TEntity>

类型参数

TEntity

Where<TEntity>(IAliasTable)

And查询

public static AliasTableSqlQuery<TEntity> Where<TEntity>(this IAliasTable table)

参数

table IAliasTable

返回

AliasTableSqlQuery<TEntity>

类型参数

TEntity

Where<TEntity>(ITable)

查询(And查询)

public static TableSqlQuery<TEntity> Where<TEntity>(this ITable table)

参数

table ITable

返回

TableSqlQuery<TEntity>

类型参数

TEntity

Where<TEntity>(MultiTableSqlQuery, Expression<Func<TEntity, bool>>)

直接查询(不建议对重名列查询)

public static MultiTableSqlQuery Where<TEntity>(this MultiTableSqlQuery multiTable, Expression<Func<TEntity, bool>> query)

参数

multiTable MultiTableSqlQuery

query Expression<Func<TEntity, bool>>

返回

MultiTableSqlQuery

类型参数

TEntity

Where<TEntity>(MultiTableSqlQuery, string, Expression<Func<TEntity, bool>>)

指定表查询

public static MultiTableSqlQuery Where<TEntity>(this MultiTableSqlQuery multiTable, string table, Expression<Func<TEntity, bool>> query)

参数

multiTable MultiTableSqlQuery

table string

query Expression<Func<TEntity, bool>>

返回

MultiTableSqlQuery

类型参数

TEntity