SqlFunction
Namespace: TagBites.Sql
Assembly: TagBites.DB.dll
Product: TagBites.DB v. 1.0.37
public static class SqlFunctionInheritance: object → SqlFunction
Methods
Section titled “Methods”Abs(SqlExpression)
Section titled “Abs(SqlExpression)”public static SqlExpression Abs(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Avg(SqlExpression)
Section titled “Avg(SqlExpression)”public static SqlExpression Avg(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Count()
Section titled “Count()”public static SqlExpression Count()Returns
Section titled “Returns”Count(SqlExpression)
Section titled “Count(SqlExpression)”public static SqlExpression Count(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Custom(string, SqlExpression[])
Section titled “Custom(string, SqlExpression[])”public static SqlExpression Custom(string functionName, SqlExpression[] operands)Parameters
Section titled “Parameters”functionNamestringoperandsSqlExpression[]
Returns
Section titled “Returns”Length(SqlExpression)
Section titled “Length(SqlExpression)”public static SqlExpression Length(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Lower(SqlExpression)
Section titled “Lower(SqlExpression)”public static SqlExpression Lower(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Max(SqlExpression[])
Section titled “Max(SqlExpression[])”public static SqlExpression Max(SqlExpression[] operands)Parameters
Section titled “Parameters”operandsSqlExpression[]
Returns
Section titled “Returns”Min(SqlExpression[])
Section titled “Min(SqlExpression[])”public static SqlExpression Min(SqlExpression[] operands)Parameters
Section titled “Parameters”operandsSqlExpression[]
Returns
Section titled “Returns”NullIf(SqlExpression, SqlExpression)
Section titled “NullIf(SqlExpression, SqlExpression)”The NULLIF function returns a null value if operand1 equals operand2; otherwise it returns operand1.
public static SqlExpression NullIf(SqlExpression operand1, SqlExpression operand2)Parameters
Section titled “Parameters”operand1SqlExpressionoperand2SqlExpression
Returns
Section titled “Returns”Random()
Section titled “Random()”public static SqlExpression Random()Returns
Section titled “Returns”Replace(SqlExpression, SqlExpression, SqlExpression)
Section titled “Replace(SqlExpression, SqlExpression, SqlExpression)”public static SqlExpression Replace(SqlExpression operand, SqlExpression what, SqlExpression with)Parameters
Section titled “Parameters”operandSqlExpressionwhatSqlExpressionwithSqlExpression
Returns
Section titled “Returns”Round(SqlExpression)
Section titled “Round(SqlExpression)”public static SqlExpression Round(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Round(SqlExpression, int)
Section titled “Round(SqlExpression, int)”public static SqlExpression Round(SqlExpression operand, int decimalPlaces)Parameters
Section titled “Parameters”operandSqlExpressiondecimalPlacesint
Returns
Section titled “Returns”Substring(SqlExpression, int)
Section titled “Substring(SqlExpression, int)”public static SqlExpression Substring(SqlExpression operand, int index)Parameters
Section titled “Parameters”operandSqlExpressionindexint
Returns
Section titled “Returns”Substring(SqlExpression, int, int)
Section titled “Substring(SqlExpression, int, int)”public static SqlExpression Substring(SqlExpression operand, int index, int count)Parameters
Section titled “Parameters”operandSqlExpressionindexintcountint
Returns
Section titled “Returns”Sum(SqlExpression)
Section titled “Sum(SqlExpression)”public static SqlExpression Sum(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Trim(SqlExpression)
Section titled “Trim(SqlExpression)”public static SqlExpression Trim(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”TrimEnd(SqlExpression)
Section titled “TrimEnd(SqlExpression)”public static SqlExpression TrimEnd(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”TrimStart(SqlExpression)
Section titled “TrimStart(SqlExpression)”public static SqlExpression TrimStart(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Upper(SqlExpression)
Section titled “Upper(SqlExpression)”public static SqlExpression Upper(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression