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()
Assembly: FreeSql.dll
Syntax
public static class SqlExtExtensions
Methods
|
Improve this Doc
View Source
Case()
Declaration
public static SqlExtExtensions.ICaseWhenEnd Case()
Returns
|
Improve this Doc
View Source
Distinct(SqlExtExtensions.IGroupConcat)
Declaration
public static SqlExtExtensions.IGroupConcat Distinct(this SqlExtExtensions.IGroupConcat that)
Parameters
Returns
|
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
Returns
Type Parameters
|
Improve this Doc
View Source
End<TValue>(SqlExtExtensions.ICaseWhenEnd<TValue>)
Declaration
public static TValue End<TValue>(this SqlExtExtensions.ICaseWhenEnd<TValue> that)
Parameters
Returns
Type Parameters
|
Improve this Doc
View Source
GroupConcat(Object)
Declaration
public static SqlExtExtensions.IGroupConcat GroupConcat(object column)
Parameters
Type |
Name |
Description |
System.Object |
column |
|
Returns
|
Improve this Doc
View Source
OrderBy(SqlExtExtensions.IGroupConcat, Object)
Declaration
public static SqlExtExtensions.IGroupConcat OrderBy(this SqlExtExtensions.IGroupConcat that, object column)
Parameters
Returns
|
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
Returns
Type Parameters
|
Improve this Doc
View Source
OrderByDescending(SqlExtExtensions.IGroupConcat, Object)
Declaration
public static SqlExtExtensions.IGroupConcat OrderByDescending(this SqlExtExtensions.IGroupConcat that, object column)
Parameters
Returns
|
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
Returns
Type Parameters
|
Improve this Doc
View Source
Over<TValue>(SqlExtExtensions.ISqlOver<TValue>)
Declaration
public static SqlExtExtensions.ISqlOver<TValue> Over<TValue>(this SqlExtExtensions.ISqlOver<TValue> that)
Parameters
Returns
Type Parameters
|
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
Returns
Type Parameters
|
Improve this Doc
View Source
Separator(SqlExtExtensions.IGroupConcat, Object)
Declaration
public static SqlExtExtensions.IGroupConcat Separator(this SqlExtExtensions.IGroupConcat that, object separator)
Parameters
Returns
|
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
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
Returns
Type Parameters
|
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
Returns
Type Parameters
|
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
Returns
Type Parameters