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()
Namespace: FreeSql
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
Type Description
SqlExtExtensions.ISqlOver<System.Decimal>
| Improve this Doc View Source

Case()

case when .. then .. end

Declaration
public static SqlExtExtensions.ICaseWhenEnd Case()
Returns
Type Description
SqlExtExtensions.ICaseWhenEnd
| Improve this Doc View Source

CaseDict<TInput, TOutput>(TInput, Dictionary<TInput, TOutput>)

case when .. then .. end

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 Description
TOutput
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
Type Description
SqlExtExtensions.ISqlOver<System.Int64>
| Improve this Doc View Source

DenseRank()

dense_rank() over(order by ...)

Declaration
public static SqlExtExtensions.ISqlOver<long> DenseRank()
Returns
Type Description
SqlExtExtensions.ISqlOver<System.Int64>
| Improve this Doc View Source

DistinctCount<T>(T)

count(distinct name)

Declaration
public static long DistinctCount<T>(T column)
Parameters
Type Name Description
T column
Returns
Type Description
System.Int64
Type Parameters
Name Description
T
| Improve this Doc View Source

EqualIsNull<TValue>(TValue)

value1 IS NULL

Declaration
public static bool EqualIsNull<TValue>(TValue value1)
Parameters
Type Name Description
TValue value1
Returns
Type Description
System.Boolean
Type Parameters
Name Description
TValue
| 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
Name Description
TValue
| 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
Name Description
TValue
| 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
Name Description
TValue
| 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
Type Description
SqlExtExtensions.IGroupConcat
| 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 Description
TValue
Type Parameters
Name Description
TValue
| 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
Name Description
TValue
| 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
Name Description
TValue
| 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 Description
SqlExtExtensions.ISqlOver<T>
Type Parameters
Name Description
T
| 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 Description
SqlExtExtensions.ISqlOver<T>
Type Parameters
Name Description
T
| Improve this Doc View Source

Rank()

rank() over(order by ...)

Declaration
public static SqlExtExtensions.ISqlOver<long> Rank()
Returns
Type Description
SqlExtExtensions.ISqlOver<System.Int64>
| Improve this Doc View Source

RowNumber()

SqlServer row_number() over(order by ...)

Declaration
public static SqlExtExtensions.ISqlOver<long> RowNumber()
Returns
Type Description
SqlExtExtensions.ISqlOver<System.Int64>
| 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
Type Description
SqlExtExtensions.ISqlOver<System.Decimal>