ShadowSqlCoreServices 类

命名空间

ShadowSql

程序集

ShadowSql.Core.dll

聚合扩展方法

public static class ShadowSqlCoreServices

继承

object

ShadowSqlCoreServices

继承成员

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

方法

Add(IAssignView, ISqlValue)

加上

public static AssignOperation Add(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Add(IAssignView, string)

加上

public static AssignOperation Add(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

AddColums<TTable>(TTable, params IEnumerable<IColumn>)

添加列

public static TTable AddColums<TTable>(this TTable table, params IEnumerable<IColumn> columns) where TTable : Table

参数

table TTable

columns IEnumerable<IColumn>

返回

TTable

类型参数

TTable

AddMembers<MultiTable>(MultiTable, params IEnumerable<IAliasTable>)

添加表成员

public static MultiTable AddMembers<MultiTable>(this MultiTable multiTable, params IEnumerable<IAliasTable> aliasTables) where MultiTable : MultiTableBase

参数

multiTable MultiTable

aliasTables IEnumerable<IAliasTable>

返回

MultiTable

类型参数

MultiTable

AddMembers<MultiTable>(MultiTable, params IEnumerable<ITable>)

添加表成员

public static MultiTable AddMembers<MultiTable>(this MultiTable multiTable, params IEnumerable<ITable> tables) where MultiTable : MultiTableBase, IMultiView

参数

multiTable MultiTable

tables IEnumerable<ITable>

返回

MultiTable

类型参数

MultiTable

AddMembers<MultiTable>(MultiTable, params IEnumerable<string>)

添加表成员

public static MultiTable AddMembers<MultiTable>(this MultiTable multiTable, params IEnumerable<string> tableNames) where MultiTable : MultiTableBase, IMultiView

参数

multiTable MultiTable

tableNames IEnumerable<string>

返回

MultiTable

类型参数

MultiTable

AddValue<TValue>(IAssignView, TValue)

加上

public static AssignOperation AddValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

Aggregate(ICompareField, string)

聚合

public static IAggregateField Aggregate(this ICompareField field, string aggregate)

参数

field ICompareField

aggregate string

返回

IAggregateField

Aggregate(IGroupByView, string, string)

聚合

public static IAggregateField Aggregate(this IGroupByView view, string aggregate, string field)

参数

view IGroupByView

aggregate string

field string

返回

IAggregateField

Alias<TTable>(IMultiView, string)

定位到别名表

public static IAliasTable<TTable> Alias<TTable>(this IMultiView multiTable, string tableName) where TTable : ITable

参数

multiTable IMultiView

tableName string

返回

IAliasTable<TTable>

类型参数

TTable

异常

ArgumentNullException

Alias<TSelectFields>(TSelectFields, ISingleSelect, string)

子查询作为字段别名

public static TSelectFields Alias<TSelectFields>(this TSelectFields fields, ISingleSelect select, string alias) where TSelectFields : SelectFieldsBase

参数

fields TSelectFields

select ISingleSelect

alias string

返回

TSelectFields

类型参数

TSelectFields

Alias<TSelectFields>(TSelectFields, string, string)

筛选别名

public static TSelectFields Alias<TSelectFields>(this TSelectFields fields, string statement, string alias) where TSelectFields : SelectFieldsBase

参数

fields TSelectFields

statement string

alias string

返回

TSelectFields

类型参数

TSelectFields

And(IAssignView, ISqlValue)

位与

public static AssignOperation And(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

And(IAssignView, string)

位与

public static AssignOperation And(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

And(AndLogic, EmptyLogic)

与逻辑

public static AndLogic And(this AndLogic other, EmptyLogic logic)

参数

other AndLogic

logic EmptyLogic

返回

AndLogic

And(AndLogic, Logic)

与逻辑

public static Logic And(this AndLogic logic, Logic other)

参数

logic AndLogic

other Logic

返回

Logic

And(AtomicLogic, AndLogic)

与逻辑

public static AndLogic And(this AtomicLogic logic, AndLogic other)

参数

logic AtomicLogic

other AndLogic

返回

AndLogic

And(AtomicLogic, AtomicLogic)

与逻辑

public static AndLogic And(this AtomicLogic logic, AtomicLogic other)

参数

logic AtomicLogic

other AtomicLogic

返回

AndLogic

And(AtomicLogic, ComplexAndLogic)

与逻辑

public static ComplexAndLogic And(this AtomicLogic logic, ComplexAndLogic other)

参数

logic AtomicLogic

other ComplexAndLogic

返回

ComplexAndLogic

And(AtomicLogic, ComplexOrLogic)

与逻辑

public static Logic And(this AtomicLogic logic, ComplexOrLogic other)

参数

logic AtomicLogic

other ComplexOrLogic

返回

Logic

And(AtomicLogic, EmptyLogic)

与逻辑

public static AtomicLogic And(this AtomicLogic other, EmptyLogic logic)

参数

other AtomicLogic

logic EmptyLogic

返回

AtomicLogic

And(AtomicLogic, Logic)

与逻辑

public static Logic And(this AtomicLogic logic, Logic other)

参数

logic AtomicLogic

other Logic

返回

Logic

And(AtomicLogic, OrLogic)

与逻辑

public static Logic And(this AtomicLogic logic, OrLogic other)

参数

logic AtomicLogic

other OrLogic

返回

Logic

And(ComplexAndLogic, EmptyLogic)

与逻辑

public static ComplexAndLogic And(this ComplexAndLogic other, EmptyLogic logic)

参数

other ComplexAndLogic

logic EmptyLogic

返回

ComplexAndLogic

And(ComplexAndLogic, Logic)

与逻辑

public static Logic And(this ComplexAndLogic logic, Logic other)

参数

logic ComplexAndLogic

other Logic

返回

Logic

And(ComplexOrLogic, EmptyLogic)

与逻辑

public static Logic And(this ComplexOrLogic other, EmptyLogic logic)

参数

other ComplexOrLogic

logic EmptyLogic

返回

Logic

And(ComplexOrLogic, Logic)

与逻辑

public static Logic And(this ComplexOrLogic logic, Logic other)

参数

logic ComplexOrLogic

other Logic

返回

Logic

And(EmptyLogic, AndLogic)

与逻辑

public static AndLogic And(this EmptyLogic logic, AndLogic other)

参数

logic EmptyLogic

other AndLogic

返回

AndLogic

And(EmptyLogic, AtomicLogic)

与逻辑

public static AtomicLogic And(this EmptyLogic logic, AtomicLogic other)

参数

logic EmptyLogic

other AtomicLogic

返回

AtomicLogic

And(EmptyLogic, ComplexAndLogic)

与逻辑

public static ComplexAndLogic And(this EmptyLogic logic, ComplexAndLogic other)

参数

logic EmptyLogic

other ComplexAndLogic

返回

ComplexAndLogic

And(EmptyLogic, ComplexOrLogic)

与逻辑

public static Logic And(this EmptyLogic logic, ComplexOrLogic other)

参数

logic EmptyLogic

other ComplexOrLogic

返回

Logic

And(EmptyLogic, EmptyLogic)

与逻辑

public static EmptyLogic And(this EmptyLogic logic, EmptyLogic other)

参数

logic EmptyLogic

other EmptyLogic

返回

EmptyLogic

And(EmptyLogic, OrLogic)

与逻辑

public static Logic And(this EmptyLogic logic, OrLogic other)

参数

logic EmptyLogic

other OrLogic

返回

Logic

And(EmptyLogic, SqlAndQuery)

与逻辑

public static SqlAndQuery And(this EmptyLogic logic, SqlAndQuery other)

参数

logic EmptyLogic

other SqlAndQuery

返回

SqlAndQuery

And(Logic, Logic)

与逻辑

public static Logic And(this Logic logic, Logic other)

参数

logic Logic

other Logic

返回

Logic

And(OrLogic, EmptyLogic)

与逻辑

public static Logic And(this OrLogic other, EmptyLogic logic)

参数

other OrLogic

logic EmptyLogic

返回

Logic

And(OrLogic, Logic)

与逻辑

public static Logic And(this OrLogic logic, Logic other)

参数

logic OrLogic

other Logic

返回

Logic

And(SqlAndQuery, ComplexOrLogic)

与运算嵌套或逻辑

public static SqlAndQuery And(this SqlAndQuery query, ComplexOrLogic logic)

参数

query SqlAndQuery

logic ComplexOrLogic

返回

SqlAndQuery

And(SqlAndQuery, EmptyLogic)

与逻辑

public static SqlAndQuery And(this SqlAndQuery other, EmptyLogic logic)

参数

other SqlAndQuery

logic EmptyLogic

返回

SqlAndQuery

And(SqlAndQuery, OrLogic)

与运算嵌套或逻辑

public static SqlAndQuery And(this SqlAndQuery query, OrLogic logic)

参数

query SqlAndQuery

logic OrLogic

返回

SqlAndQuery

AndValue<TValue>(IAssignView, TValue)

位与

public static AssignOperation AndValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

And<Query>(Query, AndLogic)

与运算

public static Query And<Query>(this Query query, AndLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic AndLogic

返回

Query

类型参数

Query

And<Query>(Query, AtomicLogic)

与运算

public static Query And<Query>(this Query query, AtomicLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic AtomicLogic

返回

Query

类型参数

Query

And<Query>(Query, ComplexAndLogic)

与运算

public static Query And<Query>(this Query query, ComplexAndLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic ComplexAndLogic

返回

Query

类型参数

Query

And<Query>(Query, ComplexOrLogic)

与运算

public static Query And<Query>(this Query query, ComplexOrLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic ComplexOrLogic

返回

Query

类型参数

Query

And<Query>(Query, Logic)

与运算

public static Query And<Query>(this Query query, Logic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Logic

返回

Query

类型参数

Query

And<Query>(Query, OrLogic)

与运算

public static Query And<Query>(this Query query, OrLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic OrLogic

返回

Query

类型参数

Query

And<Query>(Query, Func<IGroupByView, AtomicLogic>)

与运算

public static Query And<Query>(this Query query, Func<IGroupByView, AtomicLogic> logic) where Query : GroupByBase, IDataQuery

参数

query Query

logic Func<IGroupByView, AtomicLogic>

返回

Query

类型参数

Query

And<Query>(Query, Func<IGroupByView, OrLogic>)

与运算嵌套或逻辑

public static Query And<Query>(this Query query, Func<IGroupByView, OrLogic> logic) where Query : GroupByBase, IDataQuery

参数

query Query

logic Func<IGroupByView, OrLogic>

返回

Query

类型参数

Query

And<Query>(Query, Func<ITableView, AtomicLogic>)

与运算

public static Query And<Query>(this Query query, Func<ITableView, AtomicLogic> logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Func<ITableView, AtomicLogic>

返回

Query

类型参数

Query

And<Query>(Query, Func<ITableView, OrLogic>)

与运算嵌套或逻辑

public static Query And<Query>(this Query query, Func<ITableView, OrLogic> logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Func<ITableView, OrLogic>

返回

Query

类型参数

Query

Apply(JoinOnSqlQuery, Func<SqlQuery, IAliasTable, IAliasTable, SqlQuery>)

应用sql查询

public static JoinOnSqlQuery Apply(this JoinOnSqlQuery query, Func<SqlQuery, IAliasTable, IAliasTable, SqlQuery> on)

参数

query JoinOnSqlQuery

on Func<SqlQuery, IAliasTable, IAliasTable, SqlQuery>

返回

JoinOnSqlQuery

Apply<Query>(Query, Func<Logic, IGroupByView, Logic>)

应用逻辑

public static Query Apply<Query>(this Query groupBy, Func<Logic, IGroupByView, Logic> logic) where Query : GroupByBase, IDataQuery

参数

groupBy Query

logic Func<Logic, IGroupByView, Logic>

返回

Query

类型参数

Query

Apply<Query>(Query, Func<Logic, ITableView, Logic>)

应用逻辑

public static Query Apply<Query>(this Query query, Func<Logic, ITableView, Logic> logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Func<Logic, ITableView, Logic>

返回

Query

类型参数

Query

Apply<Query>(Query, Func<Logic, Logic>)

应用逻辑

public static Query Apply<Query>(this Query query, Func<Logic, Logic> logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Func<Logic, Logic>

返回

Query

类型参数

Query

Apply<TGroupBy>(TGroupBy, Func<SqlQuery, IGroupByView, SqlQuery>)

按SqlQuery查询

public static TGroupBy Apply<TGroupBy>(this TGroupBy groupBy, Func<SqlQuery, IGroupByView, SqlQuery> query) where TGroupBy : GroupByBase, IDataSqlQuery

参数

groupBy TGroupBy

query Func<SqlQuery, IGroupByView, SqlQuery>

返回

TGroupBy

类型参数

TGroupBy

Apply<Query>(Query, Func<SqlQuery, ITableView, SqlQuery>)

应用sql查询

public static Query Apply<Query>(this Query query, Func<SqlQuery, ITableView, SqlQuery> where) where Query : IDataSqlQuery

参数

query Query

where Func<SqlQuery, ITableView, SqlQuery>

返回

Query

类型参数

Query

Apply<Query>(Query, Func<SqlQuery, SqlQuery>)

应用sql查询

public static Query Apply<Query>(this Query query, Func<SqlQuery, SqlQuery> where) where Query : IDataSqlQuery

参数

query Query

where Func<SqlQuery, SqlQuery>

返回

Query

类型参数

Query

Apply<TJoinOn>(TJoinOn, Func<SqlQuery, TJoinOn, SqlQuery>)

按SqlQuery查询

public static TJoinOn Apply<TJoinOn>(this TJoinOn joinOn, Func<SqlQuery, TJoinOn, SqlQuery> query) where TJoinOn : JoinOnBase, IDataSqlQuery, IJoinOn

参数

joinOn TJoinOn

query Func<SqlQuery, TJoinOn, SqlQuery>

返回

TJoinOn

类型参数

TJoinOn

Apply<TJoinOn>(TJoinOn, string, string, Func<Logic, ICompareView, ICompareView, Logic>)

按列查询

public static TJoinOn Apply<TJoinOn>(this TJoinOn joinOn, string left, string right, Func<Logic, ICompareView, ICompareView, Logic> logic) where TJoinOn : JoinOnBase, IDataQuery

参数

joinOn TJoinOn

left string

right string

logic Func<Logic, ICompareView, ICompareView, Logic>

返回

TJoinOn

类型参数

TJoinOn

AsExists(ITableView)

EXISTS子查询逻辑

public static ExistsLogic AsExists(this ITableView source)

参数

source ITableView

返回

ExistsLogic

AsInnerJoin<TjoinOn>(TjoinOn)

内联

public static TjoinOn AsInnerJoin<TjoinOn>(this TjoinOn joinOn) where TjoinOn : JoinOnBase

参数

joinOn TjoinOn

返回

TjoinOn

类型参数

TjoinOn

AsLeftJoin<TjoinOn>(TjoinOn)

左联

public static TjoinOn AsLeftJoin<TjoinOn>(this TjoinOn joinOn) where TjoinOn : JoinOnBase

参数

joinOn TjoinOn

返回

TjoinOn

类型参数

TjoinOn

AsNotExists(ITableView)

NOT EXISTS子查询逻辑

public static NotExistsLogic AsNotExists(this ITableView source)

参数

source ITableView

返回

NotExistsLogic

AsOuterJoin<TjoinOn>(TjoinOn)

外联

public static TjoinOn AsOuterJoin<TjoinOn>(this TjoinOn joinOn) where TjoinOn : JoinOnBase

参数

joinOn TjoinOn

返回

TjoinOn

类型参数

TjoinOn

AsRightJoin<TjoinOn>(TjoinOn)

右联

public static TjoinOn AsRightJoin<TjoinOn>(this TjoinOn joinOn) where TjoinOn : JoinOnBase

参数

joinOn TjoinOn

返回

TjoinOn

类型参数

TjoinOn

As<TTable>(TTable, string)

别名表

public static TableAlias<TTable> As<TTable>(this TTable table, string alias) where TTable : ITable

参数

table TTable

alias string

返回

TableAlias<TTable>

类型参数

TTable

Asc<TCursor>(TCursor, IOrderView)

正序

public static TCursor Asc<TCursor>(this TCursor cursor, IOrderView field) where TCursor : CursorBase

参数

cursor TCursor

field IOrderView

返回

TCursor

类型参数

TCursor

Asc<TCursor>(TCursor, params IEnumerable<string>)

正序

public static TCursor Asc<TCursor>(this TCursor cursor, params IEnumerable<string> fieldNames) where TCursor : CursorBase

参数

cursor TCursor

fieldNames IEnumerable<string>

返回

TCursor

类型参数

TCursor

Asc<TCursor>(TCursor, Func<ITableView, IOrderView>)

正序

public static TCursor Asc<TCursor>(this TCursor cursor, Func<ITableView, IOrderView> select) where TCursor : CursorBase, ICursor

参数

cursor TCursor

select Func<ITableView, IOrderView>

返回

TCursor

类型参数

TCursor

Avg(ICompareField)

均值聚合

public static IAggregateField Avg(this ICompareField field)

参数

field ICompareField

返回

IAggregateField

Avg(IGroupByView, string)

均值聚合

public static IAggregateField Avg(this IGroupByView view, string field)

参数

view IGroupByView

field string

返回

IAggregateField

Between(IAggregateField, string, string)

在...之间逻辑

public static AtomicLogic Between(this IAggregateField field, string begin = "", string end = "")

参数

field IAggregateField

begin string

end string

返回

AtomicLogic

Between(ICompareField, string, string)

在...之间逻辑

public static AtomicLogic Between(this ICompareField field, string begin = "", string end = "")

参数

field ICompareField

begin string

end string

返回

AtomicLogic

BetweenValue(ICompareView, ISqlValue, ISqlValue)

在...之间逻辑

public static AtomicLogic BetweenValue(this ICompareView field, ISqlValue begin, ISqlValue end)

参数

field ICompareView

begin ISqlValue

end ISqlValue

返回

AtomicLogic

BetweenValue<TValue>(ICompareView, TValue, TValue)

在...之间逻辑

public static AtomicLogic BetweenValue<TValue>(this ICompareView field, TValue begin, TValue end)

参数

field ICompareView

begin TValue

end TValue

返回

AtomicLogic

类型参数

TValue

Column(ITable, string)

定位到列

public static IColumn Column(this ITable table, string columnName)

参数

table ITable

columnName string

返回

IColumn

异常

ArgumentException

Compare(IAggregateField, CompareSymbol, string)

比较逻辑

public static AtomicLogic Compare(this IAggregateField field, CompareSymbol compare, string parameter = "")

参数

field IAggregateField

compare CompareSymbol

parameter string

返回

AtomicLogic

Compare(IAggregateField, string, string)

比较逻辑

public static AtomicLogic Compare(this IAggregateField field, string op, string parameter = "")

参数

field IAggregateField

op string

parameter string

返回

AtomicLogic

Compare(ICompareField, string, string)

比较逻辑

public static AtomicLogic Compare(this ICompareField field, string op, string parameter = "")

参数

field ICompareField

op string

parameter string

返回

AtomicLogic

Compare(ICompareView, CompareSymbol, ISqlValue)

比较逻辑

public static AtomicLogic Compare(this ICompareView field, CompareSymbol compare, ISqlValue right)

参数

field ICompareView

compare CompareSymbol

right ISqlValue

返回

AtomicLogic

Compare(ICompareView, string, ISqlValue)

比较逻辑

public static AtomicLogic Compare(this ICompareView field, string op, ISqlValue right)

参数

field ICompareView

op string

right ISqlValue

返回

AtomicLogic

CompareValue<TValue>(ICompareView, CompareSymbol, TValue)

比较逻辑

public static AtomicLogic CompareValue<TValue>(this ICompareView field, CompareSymbol compare, TValue value)

参数

field ICompareView

compare CompareSymbol

value TValue

返回

AtomicLogic

类型参数

TValue

CompareValue<TValue>(ICompareView, string, TValue)

比较逻辑

public static AtomicLogic CompareValue<TValue>(this ICompareView field, string op, TValue value)

参数

field ICompareView

op string

value TValue

返回

AtomicLogic

类型参数

TValue

ConcatPrefix(ISqlEngine, ISqlEntity, StringBuilder, params IEnumerable<string>)

前缀拼接

public static void ConcatPrefix(this ISqlEngine engine, ISqlEntity entity, StringBuilder builder, params IEnumerable<string> suffix)

参数

engine ISqlEngine

entity ISqlEntity

builder StringBuilder

suffix IEnumerable<string>

Copy(JoinFragment)

复制sql片段组合

public static JoinFragment Copy(this JoinFragment source)

参数

source JoinFragment

返回

JoinFragment

Copy(Table, string)

复制表

public static Table Copy(this Table source, string newName = "")

参数

source Table

newName string

返回

Table

Copy(AndLogic)

复制与逻辑

public static AndLogic Copy(this AndLogic source)

参数

source AndLogic

返回

AndLogic

Copy(ComplexAndLogic)

复制复合与逻辑

public static ComplexAndLogic Copy(this ComplexAndLogic source)

参数

source ComplexAndLogic

返回

ComplexAndLogic

Copy(ComplexOrLogic)

复制复合或逻辑

public static ComplexOrLogic Copy(this ComplexOrLogic source)

参数

source ComplexOrLogic

返回

ComplexOrLogic

Copy(OrLogic)

复制或逻辑

public static OrLogic Copy(this OrLogic source)

参数

source OrLogic

返回

OrLogic

Copy(SqlAndQuery)

复制And查询

public static SqlAndQuery Copy(this SqlAndQuery source)

参数

source SqlAndQuery

返回

SqlAndQuery

Copy(SqlOrQuery)

复制Or查询

public static SqlOrQuery Copy(this SqlOrQuery source)

参数

source SqlOrQuery

返回

SqlOrQuery

Count(IGroupByView)

计数

public static CountFieldInfo Count(this IGroupByView view)

参数

view IGroupByView

返回

CountFieldInfo

CountSql(ISqlEngine, ITableView, int)

拼写计数sql

public static string CountSql(this ISqlEngine engine, ITableView view, int capacity = 128)

参数

engine ISqlEngine

view ITableView

capacity int

返回

string

CreateMember<MultiTable, TTable>(MultiTable, TTable)

构造表成员

public static TableAlias<TTable> CreateMember<MultiTable, TTable>(this MultiTable multiTable, TTable table) where MultiTable : MultiTableBase, IMultiView where TTable : ITable

参数

multiTable MultiTable

table TTable

返回

TableAlias<TTable>

类型参数

MultiTable

TTable

DefineColums<TTable>(TTable, params IEnumerable<string>)

定义列

public static TTable DefineColums<TTable>(this TTable table, params IEnumerable<string> columns) where TTable : Table

参数

table TTable

columns IEnumerable<string>

返回

TTable

类型参数

TTable

Delete<TDelete>(TDelete, IAliasTable)

指定被删除的表

public static TDelete Delete<TDelete>(this TDelete delete, IAliasTable table) where TDelete : MultiTableDelete

参数

delete TDelete

table IAliasTable

返回

TDelete

类型参数

TDelete

Delete<TDelete>(TDelete, string)

指定被删除的表

public static TDelete Delete<TDelete>(this TDelete delete, string tableName) where TDelete : MultiTableDelete

参数

delete TDelete

tableName string

返回

TDelete

类型参数

TDelete

Desc(IOrderAsc)

倒序

public static IOrderDesc Desc(this IOrderAsc field)

参数

field IOrderAsc

返回

IOrderDesc

Desc<TCursor>(TCursor, IOrderAsc)

倒序

public static TCursor Desc<TCursor>(this TCursor cursor, IOrderAsc field) where TCursor : CursorBase

参数

cursor TCursor

field IOrderAsc

返回

TCursor

类型参数

TCursor

Desc<TCursor>(TCursor, params IEnumerable<string>)

倒序

public static TCursor Desc<TCursor>(this TCursor cursor, params IEnumerable<string> fieldNames) where TCursor : CursorBase

参数

cursor TCursor

fieldNames IEnumerable<string>

返回

TCursor

类型参数

TCursor

Desc<TCursor>(TCursor, Func<ITableView, IOrderAsc>)

倒序

public static TCursor Desc<TCursor>(this TCursor cursor, Func<ITableView, IOrderAsc> select) where TCursor : CursorBase, ICursor

参数

cursor TCursor

select Func<ITableView, IOrderAsc>

返回

TCursor

类型参数

TCursor

DistinctCount(ICompareField)

字段去重统计

public static DistinctCountFieldInfo DistinctCount(this ICompareField field)

参数

field ICompareField

返回

DistinctCountFieldInfo

DistinctCount(IGroupByView, string)

计数聚合

public static DistinctCountFieldInfo DistinctCount(this IGroupByView view, string field)

参数

view IGroupByView

field string

返回

DistinctCountFieldInfo

Div(IAssignView, ISqlValue)

除去

public static AssignOperation Div(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Div(IAssignView, string)

除去

public static AssignOperation Div(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

DivValue<TValue>(IAssignView, TValue)

除去

public static AssignOperation DivValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

Equal(IAggregateField, string)

相等逻辑

public static AtomicLogic Equal(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

Equal(ICompareField, string)

相等逻辑

public static AtomicLogic Equal(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

Equal(ICompareView, ISqlValue)

相等逻辑

public static AtomicLogic Equal(this ICompareView field, ISqlValue right)

参数

field ICompareView

right ISqlValue

返回

AtomicLogic

EqualTo(IAssignView, ISqlValue)

等于

public static AssignOperation EqualTo(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

EqualTo(IAssignView, string)

等于

public static AssignOperation EqualTo(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

EqualToValue<TValue>(IAssignView, TValue)

等于

public static AssignOperation EqualToValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

EqualValue<TValue>(ICompareView, TValue)

相等逻辑

public static AtomicLogic EqualValue<TValue>(this ICompareView field, TValue value)

参数

field ICompareView

value TValue

返回

AtomicLogic

类型参数

TValue

Exists<Query>(Query, ITableView)

EXISTS子查询逻辑

public static Query Exists<Query>(this Query query, ITableView source) where Query : IDataSqlQuery

参数

query Query

source ITableView

返回

Query

类型参数

Query

Field(ITableView, string)

定位到字段(宽松不校验)

public static IField Field(this ITableView view, string fieldName)

参数

view ITableView

fieldName string

返回

IField

异常

ArgumentException

Fields(ITableView, params IEnumerable<string>)

选择列

public static IEnumerable<IField> Fields(this ITableView table, params IEnumerable<string> columnNames)

参数

table ITableView

columnNames IEnumerable<string>

返回

IEnumerable<IField>

From(IMultiView, string)

定位到表

public static IAliasTable From(this IMultiView multiTable, string tableName)

参数

multiTable IMultiView

tableName string

返回

IAliasTable

异常

ArgumentNullException

From<TAliasTable>(IMultiView, string)

定位到成员别名表

public static TAliasTable From<TAliasTable>(this IMultiView multiTable, string tableName) where TAliasTable : IAliasTable

参数

multiTable IMultiView

tableName string

返回

TAliasTable

类型参数

TAliasTable

异常

ArgumentNullException

GetAssignField<TTable>(IAliasTable<TTable>, string)

获取被修改字段

public static IAssignView? GetAssignField<TTable>(this IAliasTable<TTable> aliasTable, string fieldName) where TTable : IUpdateTable

参数

aliasTable IAliasTable<TTable>

fieldName string

返回

IAssignView

类型参数

TTable

异常

ArgumentException

Greater(IAggregateField, string)

大于逻辑

public static AtomicLogic Greater(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

Greater(ICompareField, string)

大于逻辑

public static AtomicLogic Greater(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

Greater(ICompareView, ISqlValue)

大于逻辑

public static AtomicLogic Greater(this ICompareView field, ISqlValue right)

参数

field ICompareView

right ISqlValue

返回

AtomicLogic

GreaterEqual(IAggregateField, string)

大于等于逻辑

public static AtomicLogic GreaterEqual(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

GreaterEqual(ICompareField, string)

大于等于逻辑

public static AtomicLogic GreaterEqual(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

GreaterEqual(ICompareView, ISqlValue)

大于等于逻辑

public static AtomicLogic GreaterEqual(this ICompareView field, ISqlValue right)

参数

field ICompareView

right ISqlValue

返回

AtomicLogic

GreaterEqualValue<TValue>(ICompareView, TValue)

大于等于逻辑

public static AtomicLogic GreaterEqualValue<TValue>(this ICompareView field, TValue value)

参数

field ICompareView

value TValue

返回

AtomicLogic

类型参数

TValue

GreaterValue<TValue>(ICompareView, TValue)

大于逻辑

public static AtomicLogic GreaterValue<TValue>(this ICompareView field, TValue value)

参数

field ICompareView

value TValue

返回

AtomicLogic

类型参数

TValue

GroupByPrefix(ISqlEngine, StringBuilder)

GROUP BY前缀

public static void GroupByPrefix(this ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

HavingAggregate<TGroupBy>(TGroupBy, string, string, Func<IAggregateField, AtomicLogic>)

按列名聚合

public static TGroupBy HavingAggregate<TGroupBy>(this TGroupBy groupBy, string aggregate, string columnName, Func<IAggregateField, AtomicLogic> query) where TGroupBy : GroupByBase, IDataSqlQuery

参数

groupBy TGroupBy

aggregate string

columnName string

query Func<IAggregateField, AtomicLogic>

返回

TGroupBy

类型参数

TGroupBy

HavingPrefix(ISqlEngine, StringBuilder)

HAVING前缀

public static void HavingPrefix(this ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

Having<TGroupBy>(TGroupBy, AtomicLogic)

按逻辑查询

public static TGroupBy Having<TGroupBy>(this TGroupBy groupBy, AtomicLogic logic) where TGroupBy : GroupByBase, IDataSqlQuery

参数

groupBy TGroupBy

logic AtomicLogic

返回

TGroupBy

类型参数

TGroupBy

Having<TGroupBy>(TGroupBy, params IEnumerable<string>)

按原始sql查询

public static TGroupBy Having<TGroupBy>(this TGroupBy groupBy, params IEnumerable<string> conditions) where TGroupBy : GroupByBase, IDataSqlQuery

参数

groupBy TGroupBy

conditions IEnumerable<string>

返回

TGroupBy

类型参数

TGroupBy

Having<TGroupBy>(TGroupBy, Func<IGroupByView, AtomicLogic>)

Where

public static TGroupBy Having<TGroupBy>(this TGroupBy groupBy, Func<IGroupByView, AtomicLogic> query) where TGroupBy : GroupByBase, IDataSqlQuery

参数

groupBy TGroupBy

query Func<IGroupByView, AtomicLogic>

返回

TGroupBy

类型参数

TGroupBy

IgnoreInsert<TTable>(TTable, params IEnumerable<IColumn>)

忽略插入的列

public static TTable IgnoreInsert<TTable>(this TTable table, params IEnumerable<IColumn> columns) where TTable : Table

参数

table TTable

columns IEnumerable<IColumn>

返回

TTable

类型参数

TTable

IgnoreInsert<TTable>(TTable, params IEnumerable<string>)

忽略插入的列

public static TTable IgnoreInsert<TTable>(this TTable table, params IEnumerable<string> columns) where TTable : Table

参数

table TTable

columns IEnumerable<string>

返回

TTable

类型参数

TTable

IgnoreUpdate<TTable>(TTable, params IEnumerable<IColumn>)

忽略修改的列

public static TTable IgnoreUpdate<TTable>(this TTable table, params IEnumerable<IColumn> columns) where TTable : Table

参数

table TTable

columns IEnumerable<IColumn>

返回

TTable

类型参数

TTable

IgnoreUpdate<TTable>(TTable, params IEnumerable<string>)

忽略修改的列

public static TTable IgnoreUpdate<TTable>(this TTable table, params IEnumerable<string> columns) where TTable : Table

参数

table TTable

columns IEnumerable<string>

返回

TTable

类型参数

TTable

In(IAggregateField, string)

包含逻辑

public static AtomicLogic In(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

In(ICompareField, string)

包含逻辑

public static AtomicLogic In(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

In(ICompareView, ISingleSelect)

IN子查询逻辑

public static SubInLogic In(this ICompareView field, ISingleSelect select)

参数

field ICompareView

select ISingleSelect

返回

SubInLogic

InValue<TValue>(ICompareView, params IEnumerable<TValue>)

包含逻辑

public static AtomicLogic InValue<TValue>(this ICompareView field, params IEnumerable<TValue> values)

参数

field ICompareView

values IEnumerable<TValue>

返回

AtomicLogic

类型参数

TValue

In<Query>(Query, ICompareView, ISingleSelect)

IN子查询逻辑

public static Query In<Query>(this Query query, ICompareView field, ISingleSelect select) where Query : IDataSqlQuery

参数

query Query

field ICompareView

select ISingleSelect

返回

Query

类型参数

Query

Insert(IColumn, string)

插入参数

public static InsertValue Insert(this IColumn column, string parameterName = "")

参数

column IColumn

parameterName string

返回

InsertValue

InsertColumn<TInsert>(TInsert, IColumn)

按指定列插入

public static TInsert InsertColumn<TInsert>(this TInsert insert, IColumn column) where TInsert : SingleInsertBase, ISingleInsert

参数

insert TInsert

column IColumn

返回

TInsert

类型参数

TInsert

InsertColumns<TInsert>(TInsert, params IEnumerable<IColumn>)

按指定列插入

public static TInsert InsertColumns<TInsert>(this TInsert insert, params IEnumerable<IColumn> columns) where TInsert : SingleInsertBase, ISingleInsert

参数

insert TInsert

columns IEnumerable<IColumn>

返回

TInsert

类型参数

TInsert

InsertSelfColumns<TInsert>(TInsert)

按自己的列插入

public static TInsert InsertSelfColumns<TInsert>(this TInsert insert) where TInsert : SingleInsertBase, ISingleInsert

参数

insert TInsert

返回

TInsert

类型参数

TInsert

InsertValue<TValue>(IColumn, TValue)

插入单值

public static InsertValue InsertValue<TValue>(this IColumn column, TValue value)

参数

column IColumn

value TValue

返回

InsertValue

类型参数

TValue

InsertValues<TValue>(IColumn, params IEnumerable<TValue>)

插入多值

public static InsertValues InsertValues<TValue>(this IColumn column, params IEnumerable<TValue> values)

参数

column IColumn

values IEnumerable<TValue>

返回

InsertValues

类型参数

TValue

Insert<TInsert>(TInsert, IInsertValue)

设置插入值

public static TInsert Insert<TInsert>(this TInsert insert, IInsertValue value) where TInsert : SingleInsertBase, ISingleInsert

参数

insert TInsert

value IInsertValue

返回

TInsert

类型参数

TInsert

Insert<TInsert>(TInsert, IInsertValues)

设置插入值

public static TInsert Insert<TInsert>(this TInsert insert, IInsertValues value) where TInsert : MultiInsertBase, IMultiInsert

参数

insert TInsert

value IInsertValues

返回

TInsert

类型参数

TInsert

Insert<TInsert>(TInsert, params IEnumerable<IColumn>)

设置列

public static TInsert Insert<TInsert>(this TInsert insert, params IEnumerable<IColumn> columns) where TInsert : SelectInsertBase, ISelectInsert

参数

insert TInsert

columns IEnumerable<IColumn>

返回

TInsert

类型参数

TInsert

Insert<TInsert>(TInsert, params IEnumerable<string>)

设置列

public static TInsert Insert<TInsert>(this TInsert insert, params IEnumerable<string> columnNames) where TInsert : SelectInsertBase, ISelectInsert

参数

insert TInsert

columnNames IEnumerable<string>

返回

TInsert

类型参数

TInsert

IsNull(ICompareView)

是否为空逻辑

public static AtomicLogic IsNull(this ICompareView field)

参数

field ICompareView

返回

AtomicLogic

JoinOnPrefix(ISqlEngine, StringBuilder)

联表ON前缀

public static void JoinOnPrefix(this ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

LeftTableJoin(JoinOnQuery, IAliasTable)

用左表联新表

public static JoinOnQuery LeftTableJoin(this JoinOnQuery joinOn, IAliasTable table)

参数

joinOn JoinOnQuery

table IAliasTable

返回

JoinOnQuery

LeftTableJoin(JoinOnQuery, ITable)

用左表联新表

public static JoinOnQuery LeftTableJoin(this JoinOnQuery joinOn, ITable table)

参数

joinOn JoinOnQuery

table ITable

返回

JoinOnQuery

LeftTableJoin(JoinOnQuery, string)

用左表联新表

public static JoinOnQuery LeftTableJoin(this JoinOnQuery joinOn, string tableName)

参数

joinOn JoinOnQuery

tableName string

返回

JoinOnQuery

LeftTableJoin(JoinOnSqlQuery, IAliasTable)

用左表联新表

public static JoinOnSqlQuery LeftTableJoin(this JoinOnSqlQuery joinOn, IAliasTable table)

参数

joinOn JoinOnSqlQuery

table IAliasTable

返回

JoinOnSqlQuery

LeftTableJoin(JoinOnSqlQuery, ITable)

用左表联新表

public static JoinOnSqlQuery LeftTableJoin(this JoinOnSqlQuery joinOn, ITable table)

参数

joinOn JoinOnSqlQuery

table ITable

返回

JoinOnSqlQuery

LeftTableJoin(JoinOnSqlQuery, string)

用左表联新表

public static JoinOnSqlQuery LeftTableJoin(this JoinOnSqlQuery joinOn, string tableName)

参数

joinOn JoinOnSqlQuery

tableName string

返回

JoinOnSqlQuery

Less(IAggregateField, string)

小于逻辑

public static AtomicLogic Less(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

Less(ICompareField, string)

小于逻辑

public static AtomicLogic Less(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

Less(ICompareView, ISqlValue)

小于逻辑

public static AtomicLogic Less(this ICompareView field, ISqlValue right)

参数

field ICompareView

right ISqlValue

返回

AtomicLogic

LessEqual(IAggregateField, string)

小于等于逻辑

public static AtomicLogic LessEqual(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

LessEqual(ICompareField, string)

小于等于逻辑

public static AtomicLogic LessEqual(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

LessEqual(ICompareView, ISqlValue)

小于等于逻辑

public static AtomicLogic LessEqual(this ICompareView field, ISqlValue right)

参数

field ICompareView

right ISqlValue

返回

AtomicLogic

LessEqualValue<TValue>(ICompareView, TValue)

小于等于逻辑

public static AtomicLogic LessEqualValue<TValue>(this ICompareView field, TValue value)

参数

field ICompareView

value TValue

返回

AtomicLogic

类型参数

TValue

LessValue<TValue>(ICompareView, TValue)

小于逻辑

public static AtomicLogic LessValue<TValue>(this ICompareView field, TValue value)

参数

field ICompareView

value TValue

返回

AtomicLogic

类型参数

TValue

Like(IAggregateField, string)

Like匹配逻辑

public static AtomicLogic Like(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

Like(ICompareField, string)

Like匹配逻辑

public static AtomicLogic Like(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

LikeValue(ICompareView, string)

Like匹配逻辑

public static AtomicLogic LikeValue(this ICompareView field, string value)

参数

field ICompareView

value string

返回

AtomicLogic

Max(ICompareField)

最大值聚合

public static IAggregateField Max(this ICompareField field)

参数

field ICompareField

返回

IAggregateField

Max(IGroupByView, string)

最大值聚合

public static IAggregateField Max(this IGroupByView view, string field)

参数

view IGroupByView

field string

返回

IAggregateField

Min(ICompareField)

最小值聚合

public static IAggregateField Min(this ICompareField field)

参数

field ICompareField

返回

IAggregateField

Min(IGroupByView, string)

最小值聚合

public static IAggregateField Min(this IGroupByView view, string field)

参数

view IGroupByView

field string

返回

IAggregateField

Mod(IAssignView, ISqlValue)

取模

public static AssignOperation Mod(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Mod(IAssignView, string)

取模

public static AssignOperation Mod(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

ModValue<TValue>(IAssignView, TValue)

取模

public static AssignOperation ModValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

Mul(IAssignView, ISqlValue)

乘上

public static AssignOperation Mul(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Mul(IAssignView, string)

乘上

public static AssignOperation Mul(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

MulValue<TValue>(IAssignView, TValue)

乘上

public static AssignOperation MulValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

Not(AndLogic)

not And为not每个子项的Or

public static OrLogic Not(this AndLogic and)

参数

and AndLogic

返回

OrLogic

Not(ComplexAndLogic)

not And为not每个子项的Or

public static ComplexOrLogic Not(this ComplexAndLogic and)

参数

and ComplexAndLogic

返回

ComplexOrLogic

Not(ComplexOrLogic)

not And为not每个子项的Or

public static ComplexAndLogic Not(this ComplexOrLogic or)

参数

or ComplexOrLogic

返回

ComplexAndLogic

Not(Logic)

反逻辑

public static Logic Not(this Logic logic)

参数

logic Logic

返回

Logic

Not(OrLogic)

not Or为not每个子项的And

public static AndLogic Not(this OrLogic source)

参数

source OrLogic

返回

AndLogic

NotBetween(IAggregateField, string, string)

不在...之间逻辑

public static AtomicLogic NotBetween(this IAggregateField field, string begin = "", string end = "")

参数

field IAggregateField

begin string

end string

返回

AtomicLogic

NotBetween(ICompareField, string, string)

不在...之间逻辑

public static AtomicLogic NotBetween(this ICompareField field, string begin = "", string end = "")

参数

field ICompareField

begin string

end string

返回

AtomicLogic

NotBetweenValue(ICompareView, ISqlValue, ISqlValue)

不在...之间逻辑

public static AtomicLogic NotBetweenValue(this ICompareView field, ISqlValue begin, ISqlValue end)

参数

field ICompareView

begin ISqlValue

end ISqlValue

返回

AtomicLogic

NotBetweenValue<TValue>(ICompareView, TValue, TValue)

不在...之间逻辑

public static AtomicLogic NotBetweenValue<TValue>(this ICompareView field, TValue begin, TValue end)

参数

field ICompareView

begin TValue

end TValue

返回

AtomicLogic

类型参数

TValue

NotEqual(IAggregateField, string)

不相等逻辑

public static AtomicLogic NotEqual(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

NotEqual(ICompareField, string)

不相等逻辑

public static AtomicLogic NotEqual(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

NotEqual(ICompareView, ISqlValue)

不相等逻辑

public static AtomicLogic NotEqual(this ICompareView field, ISqlValue right)

参数

field ICompareView

right ISqlValue

返回

AtomicLogic

NotEqualValue<TValue>(ICompareView, TValue)

不相等逻辑

public static AtomicLogic NotEqualValue<TValue>(this ICompareView field, TValue value)

参数

field ICompareView

value TValue

返回

AtomicLogic

类型参数

TValue

NotExists<Query>(Query, ITableView)

NOT EXISTS子查询逻辑

public static Query NotExists<Query>(this Query query, ITableView source) where Query : IDataSqlQuery

参数

query Query

source ITableView

返回

Query

类型参数

Query

NotIn(IAggregateField, string)

不包含逻辑

public static AtomicLogic NotIn(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

NotIn(ICompareField, string)

不包含逻辑

public static AtomicLogic NotIn(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

NotIn(ICompareView, ISingleSelect)

NOT IN子查询逻辑

public static SubNotInLogic NotIn(this ICompareView field, ISingleSelect select)

参数

field ICompareView

select ISingleSelect

返回

SubNotInLogic

NotInValue<TValue>(ICompareView, params IEnumerable<TValue>)

不包含逻辑

public static AtomicLogic NotInValue<TValue>(this ICompareView field, params IEnumerable<TValue> values)

参数

field ICompareView

values IEnumerable<TValue>

返回

AtomicLogic

类型参数

TValue

NotIn<Query>(Query, ICompareView, ISingleSelect)

NOT IN子查询逻辑

public static Query NotIn<Query>(this Query query, ICompareView field, ISingleSelect select) where Query : IDataSqlQuery

参数

query Query

field ICompareView

select ISingleSelect

返回

Query

类型参数

Query

NotLike(IAggregateField, string)

否定Like匹配逻辑

public static AtomicLogic NotLike(this IAggregateField field, string parameter = "")

参数

field IAggregateField

parameter string

返回

AtomicLogic

NotLike(ICompareField, string)

否定Like匹配逻辑

public static AtomicLogic NotLike(this ICompareField field, string parameter = "")

参数

field ICompareField

parameter string

返回

AtomicLogic

NotLikeValue(ICompareView, string)

否定Like匹配逻辑

public static AtomicLogic NotLikeValue(this ICompareView field, string value)

参数

field ICompareView

value string

返回

AtomicLogic

NotNull(ICompareView)

是否不为空逻辑

public static AtomicLogic NotNull(this ICompareView field)

参数

field ICompareView

返回

AtomicLogic

OnColumn<TJoinOn>(TJoinOn, string, string)

对列进行联表查询

public static TJoinOn OnColumn<TJoinOn>(this TJoinOn joinOn, string leftColumn, string rightColumn) where TJoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TJoinOn

leftColumn string

rightColumn string

返回

TJoinOn

类型参数

TJoinOn

OnColumn<TJoinOn>(TJoinOn, string, string, string)

对列进行联表查询

public static TJoinOn OnColumn<TJoinOn>(this TJoinOn joinOn, string leftColumn, string op, string rightColumn) where TJoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TJoinOn

leftColumn string

op string

rightColumn string

返回

TJoinOn

类型参数

TJoinOn

On<TJoinOn>(TJoinOn, IColumn, CompareSymbol, IColumn)

按列联表

public static TJoinOn On<TJoinOn>(this TJoinOn joinOn, IColumn left, CompareSymbol compare, IColumn right) where TJoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TJoinOn

left IColumn

compare CompareSymbol

right IColumn

返回

TJoinOn

类型参数

TJoinOn

On<TJoinOn>(TJoinOn, IColumn, IColumn)

按列联表

public static TJoinOn On<TJoinOn>(this TJoinOn joinOn, IColumn left, IColumn right) where TJoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TJoinOn

left IColumn

right IColumn

返回

TJoinOn

类型参数

TJoinOn

On<TJoinOn>(TJoinOn, IPrefixField, CompareSymbol, IPrefixField)

按列联表

public static TJoinOn On<TJoinOn>(this TJoinOn joinOn, IPrefixField left, CompareSymbol compare, IPrefixField right) where TJoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TJoinOn

left IPrefixField

compare CompareSymbol

right IPrefixField

返回

TJoinOn

类型参数

TJoinOn

On<TJoinOn>(TJoinOn, IPrefixField, IPrefixField)

按列联表

public static TJoinOn On<TJoinOn>(this TJoinOn joinOn, IPrefixField left, IPrefixField right) where TJoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TJoinOn

left IPrefixField

right IPrefixField

返回

TJoinOn

类型参数

TJoinOn

On<TjoinOn>(TjoinOn, AtomicLogic)

按逻辑查询

public static TjoinOn On<TjoinOn>(this TjoinOn joinOn, AtomicLogic logic) where TjoinOn : JoinOnBase, IDataSqlQuery

参数

joinOn TjoinOn

logic AtomicLogic

返回

TjoinOn

类型参数

TjoinOn

On<TJoinOn>(TJoinOn, params IEnumerable<string>)

按原始sql查询

public static TJoinOn On<TJoinOn>(this TJoinOn joinOn, params IEnumerable<string> conditions) where TJoinOn : JoinOnBase, IDataSqlQuery

参数

joinOn TJoinOn

conditions IEnumerable<string>

返回

TJoinOn

类型参数

TJoinOn

On<TjoinOn>(TjoinOn, Func<IAliasTable, IAliasTable, AtomicLogic>)

On

public static TjoinOn On<TjoinOn>(this TjoinOn joinOn, Func<IAliasTable, IAliasTable, AtomicLogic> query) where TjoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TjoinOn

query Func<IAliasTable, IAliasTable, AtomicLogic>

返回

TjoinOn

类型参数

TjoinOn

On<TjoinOn>(TjoinOn, Func<IJoinOn, AtomicLogic>)

On

public static TjoinOn On<TjoinOn>(this TjoinOn joinOn, Func<IJoinOn, AtomicLogic> query) where TjoinOn : JoinOnBase, IJoinOn, IDataSqlQuery

参数

joinOn TjoinOn

query Func<IJoinOn, AtomicLogic>

返回

TjoinOn

类型参数

TjoinOn

Or(IAssignView, ISqlValue)

位或

public static AssignOperation Or(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Or(IAssignView, string)

位或

public static AssignOperation Or(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

Or(AndLogic, EmptyLogic)

或逻辑

public static Logic Or(this AndLogic other, EmptyLogic logic)

参数

other AndLogic

logic EmptyLogic

返回

Logic

Or(AndLogic, Logic)

或逻辑

public static Logic Or(this AndLogic logic, Logic other)

参数

logic AndLogic

other Logic

返回

Logic

Or(AtomicLogic, AndLogic)

或逻辑

public static Logic Or(this AtomicLogic logic, AndLogic other)

参数

logic AtomicLogic

other AndLogic

返回

Logic

Or(AtomicLogic, AtomicLogic)

或逻辑

public static OrLogic Or(this AtomicLogic logic, AtomicLogic other)

参数

logic AtomicLogic

other AtomicLogic

返回

OrLogic

Or(AtomicLogic, ComplexAndLogic)

或逻辑

public static Logic Or(this AtomicLogic logic, ComplexAndLogic other)

参数

logic AtomicLogic

other ComplexAndLogic

返回

Logic

Or(AtomicLogic, ComplexOrLogic)

或逻辑

public static ComplexOrLogic Or(this AtomicLogic logic, ComplexOrLogic other)

参数

logic AtomicLogic

other ComplexOrLogic

返回

ComplexOrLogic

Or(AtomicLogic, EmptyLogic)

或逻辑

public static AtomicLogic Or(this AtomicLogic other, EmptyLogic logic)

参数

other AtomicLogic

logic EmptyLogic

返回

AtomicLogic

Or(AtomicLogic, Logic)

或逻辑

public static Logic Or(this AtomicLogic logic, Logic other)

参数

logic AtomicLogic

other Logic

返回

Logic

Or(AtomicLogic, OrLogic)

或逻辑

public static OrLogic Or(this AtomicLogic logic, OrLogic other)

参数

logic AtomicLogic

other OrLogic

返回

OrLogic

Or(ComplexAndLogic, EmptyLogic)

或逻辑

public static Logic Or(this ComplexAndLogic other, EmptyLogic logic)

参数

other ComplexAndLogic

logic EmptyLogic

返回

Logic

Or(ComplexAndLogic, Logic)

或逻辑

public static Logic Or(this ComplexAndLogic logic, Logic other)

参数

logic ComplexAndLogic

other Logic

返回

Logic

Or(ComplexOrLogic, EmptyLogic)

或逻辑

public static ComplexOrLogic Or(this ComplexOrLogic other, EmptyLogic logic)

参数

other ComplexOrLogic

logic EmptyLogic

返回

ComplexOrLogic

Or(ComplexOrLogic, Logic)

或逻辑

public static Logic Or(this ComplexOrLogic logic, Logic other)

参数

logic ComplexOrLogic

other Logic

返回

Logic

Or(EmptyLogic, AndLogic)

或逻辑

public static Logic Or(this EmptyLogic logic, AndLogic other)

参数

logic EmptyLogic

other AndLogic

返回

Logic

Or(EmptyLogic, AtomicLogic)

或逻辑

public static AtomicLogic Or(this EmptyLogic logic, AtomicLogic other)

参数

logic EmptyLogic

other AtomicLogic

返回

AtomicLogic

Or(EmptyLogic, ComplexAndLogic)

或逻辑

public static Logic Or(this EmptyLogic logic, ComplexAndLogic other)

参数

logic EmptyLogic

other ComplexAndLogic

返回

Logic

Or(EmptyLogic, ComplexOrLogic)

或逻辑

public static ComplexOrLogic Or(this EmptyLogic logic, ComplexOrLogic other)

参数

logic EmptyLogic

other ComplexOrLogic

返回

ComplexOrLogic

Or(EmptyLogic, EmptyLogic)

或逻辑

public static EmptyLogic Or(this EmptyLogic logic, EmptyLogic other)

参数

logic EmptyLogic

other EmptyLogic

返回

EmptyLogic

Or(EmptyLogic, OrLogic)

或逻辑

public static OrLogic Or(this EmptyLogic logic, OrLogic other)

参数

logic EmptyLogic

other OrLogic

返回

OrLogic

Or(Logic, Logic)

或逻辑

public static Logic Or(this Logic logic, Logic other)

参数

logic Logic

other Logic

返回

Logic

Or(OrLogic, EmptyLogic)

或逻辑

public static OrLogic Or(this OrLogic other, EmptyLogic logic)

参数

other OrLogic

logic EmptyLogic

返回

OrLogic

Or(OrLogic, Logic)

或逻辑

public static Logic Or(this OrLogic logic, Logic other)

参数

logic OrLogic

other Logic

返回

Logic

Or(SqlOrQuery, AndLogic)

或运算嵌套与逻辑

public static SqlOrQuery Or(this SqlOrQuery query, AndLogic logic)

参数

query SqlOrQuery

logic AndLogic

返回

SqlOrQuery

Or(SqlOrQuery, ComplexAndLogic)

或运算嵌套与逻辑

public static SqlOrQuery Or(this SqlOrQuery query, ComplexAndLogic logic)

参数

query SqlOrQuery

logic ComplexAndLogic

返回

SqlOrQuery

OrValue<TValue>(IAssignView, TValue)

位或

public static AssignOperation OrValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

Or<Query>(Query, AndLogic)

或运算

public static Query Or<Query>(this Query query, AndLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic AndLogic

返回

Query

类型参数

Query

Or<Query>(Query, AtomicLogic)

或运算

public static Query Or<Query>(this Query query, AtomicLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic AtomicLogic

返回

Query

类型参数

Query

Or<Query>(Query, ComplexAndLogic)

或运算

public static Query Or<Query>(this Query query, ComplexAndLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic ComplexAndLogic

返回

Query

类型参数

Query

Or<Query>(Query, ComplexOrLogic)

或运算

public static Query Or<Query>(this Query query, ComplexOrLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic ComplexOrLogic

返回

Query

类型参数

Query

Or<Query>(Query, Logic)

或运算

public static Query Or<Query>(this Query query, Logic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Logic

返回

Query

类型参数

Query

Or<Query>(Query, OrLogic)

或运算

public static Query Or<Query>(this Query query, OrLogic logic) where Query : FilterBase, IDataQuery

参数

query Query

logic OrLogic

返回

Query

类型参数

Query

Or<Query>(Query, Func<IGroupByView, AndLogic>)

或运算嵌套与逻辑

public static Query Or<Query>(this Query query, Func<IGroupByView, AndLogic> logic) where Query : GroupByBase, IDataQuery

参数

query Query

logic Func<IGroupByView, AndLogic>

返回

Query

类型参数

Query

Or<Query>(Query, Func<IGroupByView, AtomicLogic>)

或运算

public static Query Or<Query>(this Query query, Func<IGroupByView, AtomicLogic> logic) where Query : GroupByBase, IDataQuery

参数

query Query

logic Func<IGroupByView, AtomicLogic>

返回

Query

类型参数

Query

Or<Query>(Query, Func<ITableView, AndLogic>)

或运算嵌套与逻辑

public static Query Or<Query>(this Query query, Func<ITableView, AndLogic> logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Func<ITableView, AndLogic>

返回

Query

类型参数

Query

Or<Query>(Query, Func<ITableView, AtomicLogic>)

或运算

public static Query Or<Query>(this Query query, Func<ITableView, AtomicLogic> logic) where Query : FilterBase, IDataQuery

参数

query Query

logic Func<ITableView, AtomicLogic>

返回

Query

类型参数

Query

OrderBy<TCursor>(TCursor, string)

添加排序

public static TCursor OrderBy<TCursor>(this TCursor cursor, string orderBy) where TCursor : CursorBase

参数

cursor TCursor

orderBy string

返回

TCursor

类型参数

TCursor

Prefix(IAliasTable, IColumn)

增加前缀

public static IPrefixField Prefix(this IAliasTable table, IColumn column)

参数

table IAliasTable

column IColumn

返回

IPrefixField

异常

ArgumentException

Prefix(IAliasTable, string)

定位到前缀字段

public static IPrefixField Prefix(this IAliasTable table, string columnName)

参数

table IAliasTable

columnName string

返回

IPrefixField

异常

ArgumentException

Prefix(IColumn, IAliasTable)

增加前缀

public static IPrefixField Prefix(this IColumn column, IAliasTable table)

参数

column IColumn

table IAliasTable

返回

IPrefixField

Prefix(IColumn, string)

增加前缀

public static PrefixField Prefix(this IColumn column, string tableName)

参数

column IColumn

tableName string

返回

PrefixField

Prefix(IJoinOn, IColumn)

增加前缀

public static IPrefixField Prefix(this IJoinOn join, IColumn column)

参数

join IJoinOn

column IColumn

返回

IPrefixField

异常

ArgumentException

Prefix(IJoinOn, string)

增加前缀

public static IPrefixField Prefix(this IJoinOn join, string columnName)

参数

join IJoinOn

columnName string

返回

IPrefixField

异常

ArgumentException

Prefix<TTable>(IAliasTable<TTable>, Func<TTable, IColumn>)

选择列

public static IPrefixField Prefix<TTable>(this IAliasTable<TTable> table, Func<TTable, IColumn> query) where TTable : ITable

参数

table IAliasTable<TTable>

query Func<TTable, IColumn>

返回

IPrefixField

类型参数

TTable

RightTableJoin(JoinOnQuery, IAliasTable)

用右表联新表

public static JoinOnQuery RightTableJoin(this JoinOnQuery joinOn, IAliasTable table)

参数

joinOn JoinOnQuery

table IAliasTable

返回

JoinOnQuery

RightTableJoin(JoinOnQuery, ITable)

用右表联新表

public static JoinOnQuery RightTableJoin(this JoinOnQuery joinOn, ITable table)

参数

joinOn JoinOnQuery

table ITable

返回

JoinOnQuery

RightTableJoin(JoinOnQuery, string)

用右表联新表

public static JoinOnQuery RightTableJoin(this JoinOnQuery joinOn, string tableName)

参数

joinOn JoinOnQuery

tableName string

返回

JoinOnQuery

RightTableJoin(JoinOnSqlQuery, IAliasTable)

用右表联新表

public static JoinOnSqlQuery RightTableJoin(this JoinOnSqlQuery joinOn, IAliasTable table)

参数

joinOn JoinOnSqlQuery

table IAliasTable

返回

JoinOnSqlQuery

RightTableJoin(JoinOnSqlQuery, ITable)

用右表联新表

public static JoinOnSqlQuery RightTableJoin(this JoinOnSqlQuery joinOn, ITable table)

参数

joinOn JoinOnSqlQuery

table ITable

返回

JoinOnSqlQuery

RightTableJoin(JoinOnSqlQuery, string)

用右表联新表

public static JoinOnSqlQuery RightTableJoin(this JoinOnSqlQuery joinOn, string tableName)

参数

joinOn JoinOnSqlQuery

tableName string

返回

JoinOnSqlQuery

Select<TSelectFields>(TSelectFields, ISingleSelect)

子查询作为字段

public static TSelectFields Select<TSelectFields>(this TSelectFields fields, ISingleSelect select) where TSelectFields : SelectFieldsBase

参数

fields TSelectFields

select ISingleSelect

返回

TSelectFields

类型参数

TSelectFields

Select<TSelectFields>(TSelectFields, params IEnumerable<IFieldView>)

筛选列

public static TSelectFields Select<TSelectFields>(this TSelectFields select, params IEnumerable<IFieldView> fields) where TSelectFields : SelectFieldsBase

参数

select TSelectFields

fields IEnumerable<IFieldView>

返回

TSelectFields

类型参数

TSelectFields

Select<TSelectFields>(TSelectFields, params IEnumerable<string>)

筛选列

public static TSelectFields Select<TSelectFields>(this TSelectFields select, params IEnumerable<string> columns) where TSelectFields : SelectFieldsBase

参数

select TSelectFields

columns IEnumerable<string>

返回

TSelectFields

类型参数

TSelectFields

SetEqualToValue<TUpdate, TValue>(TUpdate, string, TValue)

赋值

public static TUpdate SetEqualToValue<TUpdate, TValue>(this TUpdate update, string columnName, TValue value) where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

columnName string

value TValue

返回

TUpdate

类型参数

TUpdate

TValue

SetEqualTo<TUpdate>(TUpdate, string, string)

赋参数

public static TUpdate SetEqualTo<TUpdate>(this TUpdate update, string columnName, string parameter = "") where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

columnName string

parameter string

返回

TUpdate

类型参数

TUpdate

SetFields<TUpdate>(TUpdate, params IEnumerable<IAssignView>)

按字段修改

public static TUpdate SetFields<TUpdate>(this TUpdate update, params IEnumerable<IAssignView> fields) where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

fields IEnumerable<IAssignView>

返回

TUpdate

类型参数

TUpdate

SetRaw<TUpdate>(TUpdate, string)

赋值原生sql

public static TUpdate SetRaw<TUpdate>(this TUpdate update, string assignSql) where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

assignSql string

返回

TUpdate

类型参数

TUpdate

SetSelfFields<TUpdate>(TUpdate)

按自己的列修改

public static TUpdate SetSelfFields<TUpdate>(this TUpdate update) where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

返回

TUpdate

类型参数

TUpdate

SetValue<TUpdate, TValue>(TUpdate, string, TValue, string)

赋值

public static TUpdate SetValue<TUpdate, TValue>(this TUpdate update, string columnName, TValue value, string op = "=") where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

columnName string

value TValue

op string

返回

TUpdate

类型参数

TUpdate

TValue

Set<TUpdate>(TUpdate, IAssignInfo)

赋值操作

public static TUpdate Set<TUpdate>(this TUpdate update, IAssignInfo operation) where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

operation IAssignInfo

返回

TUpdate

类型参数

TUpdate

Set<TUpdate>(TUpdate, IAssignView, string)

按字段修改

public static TUpdate Set<TUpdate>(this TUpdate update, IAssignView field, string op = "=") where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

field IAssignView

op string

返回

TUpdate

类型参数

TUpdate

Set<TUpdate>(TUpdate, string, string, string)

赋参数

public static TUpdate Set<TUpdate>(this TUpdate update, string columnName, string op = "=", string parameter = "") where TUpdate : UpdateBase, IUpdate

参数

update TUpdate

columnName string

op string

parameter string

返回

TUpdate

类型参数

TUpdate

Skip<TCursor>(TCursor, int)

游标跳过数量

public static TCursor Skip<TCursor>(this TCursor cursor, int offset) where TCursor : CursorBase

参数

cursor TCursor

offset int

返回

TCursor

类型参数

TCursor

Sql(ISqlEngine, ISqlEntity, int)

拼写sql

public static string Sql(this ISqlEngine engine, ISqlEntity entity, int capacity = 16)

参数

engine ISqlEngine

entity ISqlEntity

capacity int

返回

string

Sql(ISqlEngine, ISqlFragment, int)

拼写sql

public static string Sql(this ISqlEngine engine, ISqlFragment fragment, int capacity = 128)

参数

engine ISqlEngine

fragment ISqlFragment

capacity int

返回

string

Strict(ITableView, string)

定位到字段(严格校验)

public static IField Strict(this ITableView view, string fieldName)

参数

view ITableView

fieldName string

返回

IField

异常

ArgumentException

Sub(IAssignView, ISqlValue)

减去

public static AssignOperation Sub(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Sub(IAssignView, string)

减去

public static AssignOperation Sub(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

SubValue<TValue>(IAssignView, TValue)

减去

public static AssignOperation SubValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue

Sum(ICompareField)

最大值聚合

public static IAggregateField Sum(this ICompareField field)

参数

field ICompareField

返回

IAggregateField

Sum(IGroupByView, string)

最大值聚合

public static IAggregateField Sum(this IGroupByView view, string field)

参数

view IGroupByView

field string

返回

IAggregateField

TableCompare(IMultiView, string, string)

获取指定表比较字段

public static ICompareField TableCompare(this IMultiView multi, string tableName, string fieldName)

参数

multi IMultiView

tableName string

fieldName string

返回

ICompareField

Take<TCursor>(TCursor, int)

游标获取数量

public static TCursor Take<TCursor>(this TCursor cursor, int limit) where TCursor : CursorBase

参数

cursor TCursor

limit int

返回

TCursor

类型参数

TCursor

ToAnd<Query>(Query)

切换为And

public static Query ToAnd<Query>(this Query query) where Query : IDataSqlQuery

参数

query Query

返回

Query

类型参数

Query

ToDelete(IAliasTable, ISqlLogic)

删除

public static AliasTableDelete ToDelete(this IAliasTable table, ISqlLogic where)

参数

table IAliasTable

where ISqlLogic

返回

AliasTableDelete

ToDelete(IMultiView)

删除

public static MultiTableDelete ToDelete(this IMultiView view)

参数

view IMultiView

返回

MultiTableDelete

ToDelete(ITable, ISqlLogic)

删除

public static TableDelete ToDelete(this ITable table, ISqlLogic where)

参数

table ITable

where ISqlLogic

返回

TableDelete

ToDelete<TTable>(TTable, Func<TTable, ISqlLogic>)

删除

public static TableDelete ToDelete<TTable>(this TTable table, Func<TTable, ISqlLogic> query) where TTable : ITable

参数

table TTable

query Func<TTable, ISqlLogic>

返回

TableDelete

类型参数

TTable

ToField(ISingleSelect)

子查询作为字段

public static SingleField ToField(this ISingleSelect select)

参数

select ISingleSelect

返回

SingleField

ToField(ISingleSelect, string)

子查询作为字段别名

public static SingleFieldAlias ToField(this ISingleSelect select, string alias)

参数

select ISingleSelect

alias string

返回

SingleFieldAlias

ToOr<Query>(Query)

切换为Or

public static Query ToOr<Query>(this Query query) where Query : IDataSqlQuery

参数

query Query

返回

Query

类型参数

Query

ToTruncate(ITable)

清空表

public static TruncateTable ToTruncate(this ITable table)

参数

table ITable

返回

TruncateTable

Update<TMultiUpdate>(TMultiUpdate, IAliasTable<IUpdateTable>)

指定被修改的表

public static TMultiUpdate Update<TMultiUpdate>(this TMultiUpdate update, IAliasTable<IUpdateTable> table) where TMultiUpdate : MultiTableUpdate

参数

update TMultiUpdate

table IAliasTable<IUpdateTable>

返回

TMultiUpdate

类型参数

TMultiUpdate

Update<TMultiUpdate>(TMultiUpdate, string)

指定被修改的表

public static MultiTableUpdate Update<TMultiUpdate>(this TMultiUpdate update, string tableName) where TMultiUpdate : MultiTableUpdate

参数

update TMultiUpdate

tableName string

返回

MultiTableUpdate

类型参数

TMultiUpdate

WherePrefix(ISqlEngine, StringBuilder)

WHERE前缀

public static void WherePrefix(this ISqlEngine engine, StringBuilder sql)

参数

engine ISqlEngine

sql StringBuilder

Where<Query>(Query, AtomicLogic)

按逻辑查询

public static Query Where<Query>(this Query query, AtomicLogic logic) where Query : IDataSqlQuery, IWhere

参数

query Query

logic AtomicLogic

返回

Query

类型参数

Query

Where<Query>(Query, params IEnumerable<string>)

按原始sql查询

public static Query Where<Query>(this Query query, params IEnumerable<string> conditions) where Query : IDataSqlQuery, IWhere

参数

query Query

conditions IEnumerable<string>

返回

Query

类型参数

Query

Where<Query>(Query, Func<ITableView, AtomicLogic>)

按逻辑查询

public static Query Where<Query>(this Query query, Func<ITableView, AtomicLogic> logic) where Query : IDataSqlQuery, IWhere

参数

query Query

logic Func<ITableView, AtomicLogic>

返回

Query

类型参数

Query

WriteInsertColumnName(ISqlEngine, StringBuilder, IColumn)

拼写插入列名(避免出现列名前缀可能导致错误)

public static void WriteInsertColumnName(this ISqlEngine engine, StringBuilder sql, IColumn column)

参数

engine ISqlEngine

sql StringBuilder

column IColumn

Xor(IAssignView, ISqlValue)

位异或

public static AssignOperation Xor(this IAssignView field, ISqlValue right)

参数

field IAssignView

right ISqlValue

返回

AssignOperation

Xor(IAssignView, string)

位异或

public static AssignOperation Xor(this IAssignView field, string parameter = "")

参数

field IAssignView

parameter string

返回

AssignOperation

XorValue<TValue>(IAssignView, TValue)

位异或

public static AssignOperation XorValue<TValue>(this IAssignView field, TValue value)

参数

field IAssignView

value TValue

返回

AssignOperation

类型参数

TValue