Class SqlExt
SqlExt 是利用自定表达式函数解析功能,解析默认常用的SQL函数,欢迎 PR
Inheritance
System.Object
SqlExt
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Assembly: FreeSql.dll
Syntax
public static class SqlExt
Methods
|
Improve this Doc
View Source
Avg(Object)
avg(..) over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<decimal> Avg(object column)
Parameters
Type |
Name |
Description |
System.Object |
column |
|
Returns
|
Improve this Doc
View Source
Case()
Declaration
public static SqlExtExtensions.ICaseWhenEnd Case()
Returns
|
Improve this Doc
View Source
CaseDict<TInput, TOutput>(TInput, Dictionary<TInput, TOutput>)
Declaration
public static TOutput CaseDict<TInput, TOutput>(TInput input, Dictionary<TInput, TOutput> dict)
Parameters
Type |
Name |
Description |
TInput |
input |
|
System.Collections.Generic.Dictionary<TInput, TOutput> |
dict |
|
Returns
Type Parameters
Name |
Description |
TInput |
|
TOutput |
|
|
Improve this Doc
View Source
Count(Object)
count() over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<long> Count(object column)
Parameters
Type |
Name |
Description |
System.Object |
column |
|
Returns
|
Improve this Doc
View Source
DenseRank()
dense_rank() over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<long> DenseRank()
Returns
|
Improve this Doc
View Source
DistinctCount<T>(T)
Declaration
public static long DistinctCount<T>(T column)
Parameters
Type |
Name |
Description |
T |
column |
|
Returns
Type |
Description |
System.Int64 |
|
Type Parameters
|
Improve this Doc
View Source
EqualIsNull<TValue>(TValue)
Declaration
public static bool EqualIsNull<TValue>(TValue value1)
Parameters
Type |
Name |
Description |
TValue |
value1 |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
|
Improve this Doc
View Source
FindInSet<TValue>(TValue, String)
MySql find_in_set(str, strlist)
Declaration
public static int FindInSet<TValue>(TValue str, string strlist)
Parameters
Type |
Name |
Description |
TValue |
str |
|
System.String |
strlist |
|
Returns
Type |
Description |
System.Int32 |
|
Type Parameters
|
Improve this Doc
View Source
GreaterThan<TValue>(TValue, TValue)
Declaration
public static bool GreaterThan<TValue>(TValue value1, TValue value2)
Parameters
Type |
Name |
Description |
TValue |
value1 |
|
TValue |
value2 |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
|
Improve this Doc
View Source
GreaterThanOrEqual<TValue>(TValue, TValue)
Declaration
public static bool GreaterThanOrEqual<TValue>(TValue value1, TValue value2)
Parameters
Type |
Name |
Description |
TValue |
value1 |
|
TValue |
value2 |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
|
Improve this Doc
View Source
GroupConcat(Object)
MySql group_concat(distinct .. order by .. separator ..)
Declaration
public static SqlExtExtensions.IGroupConcat GroupConcat(object column)
Parameters
Type |
Name |
Description |
System.Object |
column |
|
Returns
|
Improve this Doc
View Source
IsNull<TValue>(TValue, TValue)
isnull、ifnull、coalesce、nvl
Declaration
public static TValue IsNull<TValue>(TValue value, TValue defaultValue)
Parameters
Type |
Name |
Description |
TValue |
value |
|
TValue |
defaultValue |
|
Returns
Type Parameters
|
Improve this Doc
View Source
LessThan<TValue>(TValue, TValue)
Declaration
public static bool LessThan<TValue>(TValue value1, TValue value2)
Parameters
Type |
Name |
Description |
TValue |
value1 |
|
TValue |
value2 |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
|
Improve this Doc
View Source
LessThanOrEqual<TValue>(TValue, TValue)
Declaration
public static bool LessThanOrEqual<TValue>(TValue value1, TValue value2)
Parameters
Type |
Name |
Description |
TValue |
value1 |
|
TValue |
value2 |
|
Returns
Type |
Description |
System.Boolean |
|
Type Parameters
|
Improve this Doc
View Source
Max<T>(T)
max(..) over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<T> Max<T>(T column)
Parameters
Type |
Name |
Description |
T |
column |
|
Returns
Type Parameters
|
Improve this Doc
View Source
Min<T>(T)
min(..) over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<T> Min<T>(T column)
Parameters
Type |
Name |
Description |
T |
column |
|
Returns
Type Parameters
|
Improve this Doc
View Source
Rank()
rank() over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<long> Rank()
Returns
|
Improve this Doc
View Source
RowNumber()
SqlServer row_number() over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<long> RowNumber()
Returns
|
Improve this Doc
View Source
StringAgg(Object, Object)
PostgreSQL string_agg(.., ..)
Declaration
public static string StringAgg(object column, object delimiter)
Parameters
Type |
Name |
Description |
System.Object |
column |
|
System.Object |
delimiter |
|
Returns
Type |
Description |
System.String |
|
|
Improve this Doc
View Source
Sum(Object)
sum(..) over(order by ...)
Declaration
public static SqlExtExtensions.ISqlOver<decimal> Sum(object column)
Parameters
Type |
Name |
Description |
System.Object |
column |
|
Returns