Class SqlExtExtensions

Inheritance
System.Object
SqlExtExtensions
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 SqlExtExtensions

Methods

| Improve this Doc View Source

Case()

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

Distinct(SqlExtExtensions.IGroupConcat)

Declaration
public static SqlExtExtensions.IGroupConcat Distinct(this SqlExtExtensions.IGroupConcat that)
Parameters
Type Name Description
SqlExtExtensions.IGroupConcat that
Returns
Type Description
SqlExtExtensions.IGroupConcat
| Improve this Doc View Source

Else<TValue>(SqlExtExtensions.ICaseWhenEnd<TValue>, TValue)

Declaration
public static SqlExtExtensions.ICaseWhenEnd<TValue> Else<TValue>(this SqlExtExtensions.ICaseWhenEnd<TValue> that, TValue then)
Parameters
Type Name Description
SqlExtExtensions.ICaseWhenEnd<TValue> that
TValue then
Returns
Type Description
SqlExtExtensions.ICaseWhenEnd<TValue>
Type Parameters
Name Description
TValue
| Improve this Doc View Source

End<TValue>(SqlExtExtensions.ICaseWhenEnd<TValue>)

Declaration
public static TValue End<TValue>(this SqlExtExtensions.ICaseWhenEnd<TValue> that)
Parameters
Type Name Description
SqlExtExtensions.ICaseWhenEnd<TValue> that
Returns
Type Description
TValue
Type Parameters
Name Description
TValue
| Improve this Doc View Source

GroupConcat(Object)

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

OrderBy(SqlExtExtensions.IGroupConcat, Object)

Declaration
public static SqlExtExtensions.IGroupConcat OrderBy(this SqlExtExtensions.IGroupConcat that, object column)
Parameters
Type Name Description
SqlExtExtensions.IGroupConcat that
System.Object column
Returns
Type Description
SqlExtExtensions.IGroupConcat
| Improve this Doc View Source

OrderBy<TValue>(SqlExtExtensions.ISqlOver<TValue>, Object)

Declaration
public static SqlExtExtensions.ISqlOver<TValue> OrderBy<TValue>(this SqlExtExtensions.ISqlOver<TValue> that, object column)
Parameters
Type Name Description
SqlExtExtensions.ISqlOver<TValue> that
System.Object column
Returns
Type Description
SqlExtExtensions.ISqlOver<TValue>
Type Parameters
Name Description
TValue
| Improve this Doc View Source

OrderByDescending(SqlExtExtensions.IGroupConcat, Object)

Declaration
public static SqlExtExtensions.IGroupConcat OrderByDescending(this SqlExtExtensions.IGroupConcat that, object column)
Parameters
Type Name Description
SqlExtExtensions.IGroupConcat that
System.Object column
Returns
Type Description
SqlExtExtensions.IGroupConcat
| Improve this Doc View Source

OrderByDescending<TValue>(SqlExtExtensions.ISqlOver<TValue>, Object)

Declaration
public static SqlExtExtensions.ISqlOver<TValue> OrderByDescending<TValue>(this SqlExtExtensions.ISqlOver<TValue> that, object column)
Parameters
Type Name Description
SqlExtExtensions.ISqlOver<TValue> that
System.Object column
Returns
Type Description
SqlExtExtensions.ISqlOver<TValue>
Type Parameters
Name Description
TValue
| Improve this Doc View Source

Over<TValue>(SqlExtExtensions.ISqlOver<TValue>)

Declaration
public static SqlExtExtensions.ISqlOver<TValue> Over<TValue>(this SqlExtExtensions.ISqlOver<TValue> that)
Parameters
Type Name Description
SqlExtExtensions.ISqlOver<TValue> that
Returns
Type Description
SqlExtExtensions.ISqlOver<TValue>
Type Parameters
Name Description
TValue
| Improve this Doc View Source

PartitionBy<TValue>(SqlExtExtensions.ISqlOver<TValue>, Object)

Declaration
public static SqlExtExtensions.ISqlOver<TValue> PartitionBy<TValue>(this SqlExtExtensions.ISqlOver<TValue> that, object column)
Parameters
Type Name Description
SqlExtExtensions.ISqlOver<TValue> that
System.Object column
Returns
Type Description
SqlExtExtensions.ISqlOver<TValue>
Type Parameters
Name Description
TValue
| Improve this Doc View Source

Separator(SqlExtExtensions.IGroupConcat, Object)

Declaration
public static SqlExtExtensions.IGroupConcat Separator(this SqlExtExtensions.IGroupConcat that, object separator)
Parameters
Type Name Description
SqlExtExtensions.IGroupConcat that
System.Object separator
Returns
Type Description
SqlExtExtensions.IGroupConcat
| Improve this Doc View Source

StringJoinFirebirdList(Object, Object)

Declaration
public static string StringJoinFirebirdList(object column, object delimiter)
Parameters
Type Name Description
System.Object column
System.Object delimiter
Returns
Type Description
System.String
| Improve this Doc View Source

StringJoinGBaseWmConcatText(Object, Object)

Declaration
public static string StringJoinGBaseWmConcatText(object column, object delimiter)
Parameters
Type Name Description
System.Object column
System.Object delimiter
Returns
Type Description
System.String
| Improve this Doc View Source

StringJoinMySqlGroupConcat(Object, Object)

Declaration
public static string StringJoinMySqlGroupConcat(object column, object delimiter)
Parameters
Type Name Description
System.Object column
System.Object delimiter
Returns
Type Description
System.String
| Improve this Doc View Source

StringJoinOracleGroupConcat(Object, Object)

Declaration
public static string StringJoinOracleGroupConcat(object column, object delimiter)
Parameters
Type Name Description
System.Object column
System.Object delimiter
Returns
Type Description
System.String
| Improve this Doc View Source

StringJoinPgsqlGroupConcat(Object, Object)

Declaration
public static string StringJoinPgsqlGroupConcat(object column, object delimiter)
Parameters
Type Name Description
System.Object column
System.Object delimiter
Returns
Type Description
System.String
| Improve this Doc View Source

StringJoinSqliteGroupConcat(Object, Object)

Declaration
public static string StringJoinSqliteGroupConcat(object column, object delimiter)
Parameters
Type Name Description
System.Object column
System.Object delimiter
Returns
Type Description
System.String
| Improve this Doc View Source

ToValue(SqlExtExtensions.IGroupConcat)

Declaration
public static string ToValue(this SqlExtExtensions.IGroupConcat that)
Parameters
Type Name Description
SqlExtExtensions.IGroupConcat that
Returns
Type Description
System.String
| Improve this Doc View Source

ToValue<TValue>(SqlExtExtensions.ISqlOver<TValue>)

Declaration
public static TValue ToValue<TValue>(this SqlExtExtensions.ISqlOver<TValue> that)
Parameters
Type Name Description
SqlExtExtensions.ISqlOver<TValue> that
Returns
Type Description
TValue
Type Parameters
Name Description
TValue
| Improve this Doc View Source

When<TValue>(SqlExtExtensions.ICaseWhenEnd, Boolean, TValue)

Declaration
public static SqlExtExtensions.ICaseWhenEnd<TValue> When<TValue>(this SqlExtExtensions.ICaseWhenEnd that, bool test, TValue then)
Parameters
Type Name Description
SqlExtExtensions.ICaseWhenEnd that
System.Boolean test
TValue then
Returns
Type Description
SqlExtExtensions.ICaseWhenEnd<TValue>
Type Parameters
Name Description
TValue
| Improve this Doc View Source

When<TValue>(SqlExtExtensions.ICaseWhenEnd<TValue>, Boolean, TValue)

Declaration
public static SqlExtExtensions.ICaseWhenEnd<TValue> When<TValue>(this SqlExtExtensions.ICaseWhenEnd<TValue> that, bool test, TValue then)
Parameters
Type Name Description
SqlExtExtensions.ICaseWhenEnd<TValue> that
System.Boolean test
TValue then
Returns
Type Description
SqlExtExtensions.ICaseWhenEnd<TValue>
Type Parameters
Name Description
TValue