SqlExpression
Namespace: TagBites.Sql
Assembly: TagBites.DB.dll
Product: TagBites.DB v. 1.0.37
public abstract class SqlExpressionInheritance: object → SqlExpression
Derived:
- SqlArgument
- SqlColumn
- SqlCondition
- SqlExpressionBinaryOperator
- SqlExpressionCastOperator
- SqlExpressionFunctionCall
- SqlExpressionIndexerOperator
- SqlExpressionQuery
- SqlExpressionSelect
- SqlExpressionUnaryOperator
- SqlExpressionWithAlias
- SqlLiteral
- SqlLiteralExpression
- SqlOperatorExpression
- SqlTable
Fields
Section titled “Fields”EmptyString
Section titled “EmptyString”public SqlExpression EmptyStringField Value
Section titled “Field Value”public SqlCondition FalseField Value
Section titled “Field Value”public SqlExpression NullField Value
Section titled “Field Value”public SqlExpression OneField Value
Section titled “Field Value”public SqlCondition TrueField Value
Section titled “Field Value”public SqlExpression ZeroField Value
Section titled “Field Value”Indexers
Section titled “Indexers”public SqlExpression Item[int index] { get; }Property Value
Section titled “Property Value”public SqlExpression Item[SqlExpression index] { get; }Property Value
Section titled “Property Value”Methods
Section titled “Methods”Accept(ISqlExpressionVisitor)
Section titled “Accept(ISqlExpressionVisitor)”public virtual void Accept(ISqlExpressionVisitor visitor)Parameters
Section titled “Parameters”visitorISqlExpressionVisitor
Accept(SqlQueryResolver, SqlQueryBuilder)
Section titled “Accept(SqlQueryResolver, SqlQueryBuilder)”protected internal virtual void Accept(SqlQueryResolver resolver, SqlQueryBuilder builder)Parameters
Section titled “Parameters”resolverSqlQueryResolverbuilderSqlQueryBuilder
And(SqlCondition, SqlCondition)
Section titled “And(SqlCondition, SqlCondition)”public static SqlCondition And(SqlCondition leftOperand, SqlCondition rightOperand)Parameters
Section titled “Parameters”leftOperandSqlConditionrightOperandSqlCondition
Returns
Section titled “Returns”And(SqlCondition[])
Section titled “And(SqlCondition[])”public static SqlCondition And(SqlCondition[] conditions)Parameters
Section titled “Parameters”conditionsSqlCondition[]
Returns
Section titled “Returns”And(IEnumerable<SqlCondition>)
Section titled “And(IEnumerable<SqlCondition>)”public static SqlCondition And(IEnumerable<SqlCondition> conditions)Parameters
Section titled “Parameters”conditionsIEnumerable<SqlCondition>
Returns
Section titled “Returns”AreBitRangeEquals(SqlExpression, int, int, int)
Section titled “AreBitRangeEquals(SqlExpression, int, int, int)”public static SqlCondition AreBitRangeEquals(SqlExpression integerExpression, int bitIndex, int bitCount, int bitRangeValue)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitCountintbitRangeValueint
Returns
Section titled “Returns”AreBitRangeNotEquals(SqlExpression, int, int, int)
Section titled “AreBitRangeNotEquals(SqlExpression, int, int, int)”public static SqlCondition AreBitRangeNotEquals(SqlExpression integerExpression, int bitIndex, int bitCount, int bitRangeValue)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitCountintbitRangeValueint
Returns
Section titled “Returns”AreDistinct(SqlExpression, SqlExpression)
Section titled “AreDistinct(SqlExpression, SqlExpression)”public static SqlCondition AreDistinct(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”AreEquals(SqlExpression, SqlExpression)
Section titled “AreEquals(SqlExpression, SqlExpression)”public static SqlCondition AreEquals(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”AreNotDistinct(SqlExpression, SqlExpression)
Section titled “AreNotDistinct(SqlExpression, SqlExpression)”public static SqlCondition AreNotDistinct(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”AreNotEquals(SqlExpression, SqlExpression)
Section titled “AreNotEquals(SqlExpression, SqlExpression)”public static SqlCondition AreNotEquals(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Argument(object)
Section titled “Argument(object)”public static SqlExpression Argument(object argumentValue)Parameters
Section titled “Parameters”argumentValueobject
Returns
Section titled “Returns”Between(SqlExpression, SqlExpression, SqlExpression)
Section titled “Between(SqlExpression, SqlExpression, SqlExpression)”public static SqlCondition Between(SqlExpression expression, SqlExpression min, SqlExpression max)Parameters
Section titled “Parameters”expressionSqlExpressionminSqlExpressionmaxSqlExpression
Returns
Section titled “Returns”BitwiseAnd(SqlExpression, SqlExpression)
Section titled “BitwiseAnd(SqlExpression, SqlExpression)”public static SqlExpression BitwiseAnd(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”BitwiseComplement(SqlExpression)
Section titled “BitwiseComplement(SqlExpression)”public static SqlExpression BitwiseComplement(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”BitwiseLeftShift(SqlExpression, SqlExpression)
Section titled “BitwiseLeftShift(SqlExpression, SqlExpression)”public static SqlExpression BitwiseLeftShift(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”BitwiseLeftShift(SqlExpression, int)
Section titled “BitwiseLeftShift(SqlExpression, int)”public static SqlExpression BitwiseLeftShift(SqlExpression leftOperand, int rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandint
Returns
Section titled “Returns”BitwiseOr(SqlExpression, SqlExpression)
Section titled “BitwiseOr(SqlExpression, SqlExpression)”public static SqlExpression BitwiseOr(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”BitwiseRightShift(SqlExpression, SqlExpression)
Section titled “BitwiseRightShift(SqlExpression, SqlExpression)”public static SqlExpression BitwiseRightShift(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”BitwiseRightShift(SqlExpression, int)
Section titled “BitwiseRightShift(SqlExpression, int)”public static SqlExpression BitwiseRightShift(SqlExpression leftOperand, int rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandint
Returns
Section titled “Returns”BitwiseXor(SqlExpression, SqlExpression)
Section titled “BitwiseXor(SqlExpression, SqlExpression)”public static SqlExpression BitwiseXor(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Cast(SqlExpression, Type)
Section titled “Cast(SqlExpression, Type)”public static SqlExpression Cast(SqlExpression operand, Type netType)Parameters
Section titled “Parameters”operandSqlExpressionnetTypeType
Returns
Section titled “Returns”Cast(SqlExpression, DbType)
Section titled “Cast(SqlExpression, DbType)”public static SqlExpression Cast(SqlExpression operand, DbType dbType)Parameters
Section titled “Parameters”operandSqlExpressiondbTypeDbType
Returns
Section titled “Returns”Cast(SqlExpression, string)
Section titled “Cast(SqlExpression, string)”public static SqlExpression Cast(SqlExpression operand, string dbTypeName)Parameters
Section titled “Parameters”operandSqlExpressiondbTypeNamestring
Returns
Section titled “Returns”Coalesce(SqlExpression, SqlExpression)
Section titled “Coalesce(SqlExpression, SqlExpression)”public static SqlExpression Coalesce(SqlExpression operand1, SqlExpression operand2)Parameters
Section titled “Parameters”operand1SqlExpressionoperand2SqlExpression
Returns
Section titled “Returns”Coalesce(SqlExpression[])
Section titled “Coalesce(SqlExpression[])”public static SqlExpression Coalesce(SqlExpression[] operands)Parameters
Section titled “Parameters”operandsSqlExpression[]
Returns
Section titled “Returns”Column(SqlTable, string)
Section titled “Column(SqlTable, string)”public static SqlExpression Column(SqlTable table, string columnName)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Column(string, string)
Section titled “Column(string, string)”public static SqlExpression Column(string tableAlias, string columnName)Parameters
Section titled “Parameters”Returns
Section titled “Returns”Concat(SqlExpression, SqlExpression)
Section titled “Concat(SqlExpression, SqlExpression)”public static SqlExpression Concat(SqlExpression operand1, SqlExpression operand2)Parameters
Section titled “Parameters”operand1SqlExpressionoperand2SqlExpression
Returns
Section titled “Returns”Concat(SqlExpression[])
Section titled “Concat(SqlExpression[])”public static SqlExpression Concat(SqlExpression[] operands)Parameters
Section titled “Parameters”operandsSqlExpression[]
Returns
Section titled “Returns”Contains(SqlExpression, SqlExpression)
Section titled “Contains(SqlExpression, SqlExpression)”public static SqlCondition Contains(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Divide(SqlExpression, SqlExpression)
Section titled “Divide(SqlExpression, SqlExpression)”public static SqlExpression Divide(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”EndsWith(SqlExpression, SqlExpression)
Section titled “EndsWith(SqlExpression, SqlExpression)”public static SqlCondition EndsWith(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Exists(SqlExpression)
Section titled “Exists(SqlExpression)”public static SqlCondition Exists(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
Returns
Section titled “Returns”FlagBit(SqlExpression, int)
Section titled “FlagBit(SqlExpression, int)”public static SqlExpression FlagBit(SqlExpression integerExpression, int bitIndex)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexint
Returns
Section titled “Returns”FlagBitRange(SqlExpression, int, int)
Section titled “FlagBitRange(SqlExpression, int, int)”public static SqlExpression FlagBitRange(SqlExpression integerExpression, int bitIndex, int bitCount)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitCountint
Returns
Section titled “Returns”FlagSetBit(SqlExpression, int, bool)
Section titled “FlagSetBit(SqlExpression, int, bool)”public static SqlExpression FlagSetBit(SqlExpression integerExpression, int bitIndex, bool bitValue)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitValuebool
Returns
Section titled “Returns”FlagSetBit(SqlExpression, int, SqlExpression)
Section titled “FlagSetBit(SqlExpression, int, SqlExpression)”public static SqlExpression FlagSetBit(SqlExpression integerExpression, int bitIndex, SqlExpression bitValueExpression)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitValueExpressionSqlExpression
Returns
Section titled “Returns”FlagSetBitRange(SqlExpression, int, int, int)
Section titled “FlagSetBitRange(SqlExpression, int, int, int)”public static SqlExpression FlagSetBitRange(SqlExpression integerExpression, int bitIndex, int bitCount, int bitRangeValue)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitCountintbitRangeValueint
Returns
Section titled “Returns”FlagSetBitRange(SqlExpression, int, int, SqlExpression)
Section titled “FlagSetBitRange(SqlExpression, int, int, SqlExpression)”public static SqlExpression FlagSetBitRange(SqlExpression integerExpression, int bitIndex, int bitCount, SqlExpression bitRangeValueExpression)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexintbitCountintbitRangeValueExpressionSqlExpression
Returns
Section titled “Returns”Function(string)
Section titled “Function(string)”public static SqlExpression Function(string name)Parameters
Section titled “Parameters”namestring
Returns
Section titled “Returns”Function(string, SqlExpression[])
Section titled “Function(string, SqlExpression[])”public static SqlExpression Function(string name, SqlExpression[] args)Parameters
Section titled “Parameters”namestringargsSqlExpression[]
Returns
Section titled “Returns”Greatest(SqlExpression[])
Section titled “Greatest(SqlExpression[])”public static SqlExpression Greatest(SqlExpression[] operands)Parameters
Section titled “Parameters”operandsSqlExpression[]
Returns
Section titled “Returns”In(SqlExpression, int[])
Section titled “In(SqlExpression, int[])”public static SqlCondition In(SqlExpression expression, int[] values)Parameters
Section titled “Parameters”expressionSqlExpressionvaluesint[]
Returns
Section titled “Returns”In(SqlExpression, SqlExpression[])
Section titled “In(SqlExpression, SqlExpression[])”public static SqlCondition In(SqlExpression expression, SqlExpression[] values)Parameters
Section titled “Parameters”expressionSqlExpressionvaluesSqlExpression[]
Returns
Section titled “Returns”In(SqlExpression, IEnumerable<SqlExpression>)
Section titled “In(SqlExpression, IEnumerable<SqlExpression>)”public static SqlCondition In(SqlExpression expression, IEnumerable<SqlExpression> values)Parameters
Section titled “Parameters”expressionSqlExpressionvaluesIEnumerable<SqlExpression>
Returns
Section titled “Returns”IntervalCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)
Section titled “IntervalCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)”public static SqlCondition IntervalCompleteIntersects(SqlExpression intervalAStart, SqlExpression intervalAEnd, SqlExpression intervalBStart, SqlExpression intervalBEnd)Parameters
Section titled “Parameters”intervalAStartSqlExpressionintervalAEndSqlExpressionintervalBStartSqlExpressionintervalBEndSqlExpression
Returns
Section titled “Returns”IntervalIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)
Section titled “IntervalIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)”public static SqlCondition IntervalIntersects(SqlExpression intervalAStart, SqlExpression intervalAEnd, SqlExpression intervalBStart, SqlExpression intervalBEnd)Parameters
Section titled “Parameters”intervalAStartSqlExpressionintervalAEndSqlExpressionintervalBStartSqlExpressionintervalBEndSqlExpression
Returns
Section titled “Returns”IntervalLeftCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)
Section titled “IntervalLeftCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)”public static SqlCondition IntervalLeftCompleteIntersects(SqlExpression intervalAStart, SqlExpression intervalAEnd, SqlExpression intervalBStart, SqlExpression intervalBEnd)Parameters
Section titled “Parameters”intervalAStartSqlExpressionintervalAEndSqlExpressionintervalBStartSqlExpressionintervalBEndSqlExpression
Returns
Section titled “Returns”IsBitOff(SqlExpression, int)
Section titled “IsBitOff(SqlExpression, int)”public static SqlCondition IsBitOff(SqlExpression integerExpression, int bitIndex)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexint
Returns
Section titled “Returns”IsBitOn(SqlExpression, int)
Section titled “IsBitOn(SqlExpression, int)”public static SqlCondition IsBitOn(SqlExpression integerExpression, int bitIndex)Parameters
Section titled “Parameters”integerExpressionSqlExpressionbitIndexint
Returns
Section titled “Returns”IsGreater(SqlExpression, SqlExpression)
Section titled “IsGreater(SqlExpression, SqlExpression)”public static SqlCondition IsGreater(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”IsGreaterOrEqual(SqlExpression, SqlExpression)
Section titled “IsGreaterOrEqual(SqlExpression, SqlExpression)”public static SqlCondition IsGreaterOrEqual(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”IsLess(SqlExpression, SqlExpression)
Section titled “IsLess(SqlExpression, SqlExpression)”public static SqlCondition IsLess(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”IsLessOrEqual(SqlExpression, SqlExpression)
Section titled “IsLessOrEqual(SqlExpression, SqlExpression)”public static SqlCondition IsLessOrEqual(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”IsLike(SqlExpression, SqlExpression)
Section titled “IsLike(SqlExpression, SqlExpression)”public static SqlCondition IsLike(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”IsNotNull(SqlExpression)
Section titled “IsNotNull(SqlExpression)”public static SqlCondition IsNotNull(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
Returns
Section titled “Returns”IsNull(SqlExpression)
Section titled “IsNull(SqlExpression)”public static SqlCondition IsNull(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
Returns
Section titled “Returns”Least(SqlExpression[])
Section titled “Least(SqlExpression[])”public static SqlExpression Least(SqlExpression[] operands)Parameters
Section titled “Parameters”operandsSqlExpression[]
Returns
Section titled “Returns”Like(SqlExpression, SqlExpression)
Section titled “Like(SqlExpression, SqlExpression)”public static SqlCondition Like(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Literal(string)
Section titled “Literal(string)”public static SqlExpression Literal(string sqlLiteral)Parameters
Section titled “Parameters”sqlLiteralstring
Returns
Section titled “Returns”LiteralCondition(string)
Section titled “LiteralCondition(string)”public static SqlCondition LiteralCondition(string sqlLiteral)Parameters
Section titled “Parameters”sqlLiteralstring
Returns
Section titled “Returns”LiteralConditionExpression(string, SqlExpression[])
Section titled “LiteralConditionExpression(string, SqlExpression[])”public static SqlCondition LiteralConditionExpression(string sqlLiteralExpressionFormat, SqlExpression[] args)Parameters
Section titled “Parameters”sqlLiteralExpressionFormatstringargsSqlExpression[]
Returns
Section titled “Returns”LiteralExpression(string, SqlExpression[])
Section titled “LiteralExpression(string, SqlExpression[])”public static SqlExpression LiteralExpression(string sqlLiteralExpressionFormat, SqlExpression[] args)Parameters
Section titled “Parameters”sqlLiteralExpressionFormatstringargsSqlExpression[]
Returns
Section titled “Returns”Minus(SqlExpression, SqlExpression)
Section titled “Minus(SqlExpression, SqlExpression)”public static SqlExpression Minus(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Modulo(SqlExpression, SqlExpression)
Section titled “Modulo(SqlExpression, SqlExpression)”public static SqlExpression Modulo(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Multiply(SqlExpression, SqlExpression)
Section titled “Multiply(SqlExpression, SqlExpression)”public static SqlExpression Multiply(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”Negate(SqlExpression)
Section titled “Negate(SqlExpression)”public static SqlExpression Negate(SqlExpression operand)Parameters
Section titled “Parameters”operandSqlExpression
Returns
Section titled “Returns”Not(SqlCondition)
Section titled “Not(SqlCondition)”public static SqlCondition Not(SqlCondition condition)Parameters
Section titled “Parameters”conditionSqlCondition
Returns
Section titled “Returns”NotExists(SqlExpression)
Section titled “NotExists(SqlExpression)”public static SqlCondition NotExists(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
Returns
Section titled “Returns”Or(SqlCondition, SqlCondition)
Section titled “Or(SqlCondition, SqlCondition)”public static SqlCondition Or(SqlCondition leftOperand, SqlCondition rightOperand)Parameters
Section titled “Parameters”leftOperandSqlConditionrightOperandSqlCondition
Returns
Section titled “Returns”Or(SqlCondition[])
Section titled “Or(SqlCondition[])”public static SqlCondition Or(SqlCondition[] conditions)Parameters
Section titled “Parameters”conditionsSqlCondition[]
Returns
Section titled “Returns”Or(IEnumerable<SqlCondition>)
Section titled “Or(IEnumerable<SqlCondition>)”public static SqlCondition Or(IEnumerable<SqlCondition> conditions)Parameters
Section titled “Parameters”conditionsIEnumerable<SqlCondition>
Returns
Section titled “Returns”Plus(SqlExpression, SqlExpression)
Section titled “Plus(SqlExpression, SqlExpression)”public static SqlExpression Plus(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”SearchFilter(string, IEnumerable<SqlExpression>, bool)
Section titled “SearchFilter(string, IEnumerable<SqlExpression>, bool)”public static SqlCondition SearchFilter(string filter, IEnumerable<SqlExpression> expressions, bool ignoreCase)Parameters
Section titled “Parameters”filterstringexpressionsIEnumerable<SqlExpression>ignoreCasebool
Returns
Section titled “Returns”SearchFilter(string, IEnumerable<SqlSearchFilerRule>)
Section titled “SearchFilter(string, IEnumerable<SqlSearchFilerRule>)”public static SqlCondition SearchFilter(string filter, IEnumerable<SqlSearchFilerRule> columns)Parameters
Section titled “Parameters”filterstringcolumnsIEnumerable<SqlSearchFilerRule>
Returns
Section titled “Returns”SearchFilter(string, IEnumerable<SqlSearchFilerRule>, bool)
Section titled “SearchFilter(string, IEnumerable<SqlSearchFilerRule>, bool)”public static SqlCondition SearchFilter(string filter, IEnumerable<SqlSearchFilerRule> columns, bool ignoreCase)Parameters
Section titled “Parameters”filterstringcolumnsIEnumerable<SqlSearchFilerRule>ignoreCasebool
Returns
Section titled “Returns”SearchFilterRule(string, SqlExpression)
Section titled “SearchFilterRule(string, SqlExpression)”public static SqlSearchFilerRule SearchFilterRule(string adjustFunctionName, SqlExpression expression)Parameters
Section titled “Parameters”adjustFunctionNamestringexpressionSqlExpression
Returns
Section titled “Returns”StartsWith(SqlExpression, SqlExpression)
Section titled “StartsWith(SqlExpression, SqlExpression)”public static SqlCondition StartsWith(SqlExpression leftOperand, SqlExpression rightOperand)Parameters
Section titled “Parameters”leftOperandSqlExpressionrightOperandSqlExpression
Returns
Section titled “Returns”ToCondition()
Section titled “ToCondition()”public SqlCondition ToCondition()Returns
Section titled “Returns”ToCondition(object)
Section titled “ToCondition(object)”public static SqlCondition ToCondition(object value)Parameters
Section titled “Parameters”valueobject
Returns
Section titled “Returns”ToString()
Section titled “ToString()”public virtual string ToString()Returns
Section titled “Returns”When(SqlCondition, SqlExpression)
Section titled “When(SqlCondition, SqlExpression)”public static SqlExpression When(SqlCondition whenCondition, SqlExpression operandWhenTrue)Parameters
Section titled “Parameters”whenConditionSqlConditionoperandWhenTrueSqlExpression
Returns
Section titled “Returns”When(SqlCondition, SqlExpression, SqlExpression)
Section titled “When(SqlCondition, SqlExpression, SqlExpression)”public static SqlExpression When(SqlCondition whenCondition, SqlExpression operandWhenTrue, SqlExpression operandWhenFalse)Parameters
Section titled “Parameters”whenConditionSqlConditionoperandWhenTrueSqlExpressionoperandWhenFalseSqlExpression
Returns
Section titled “Returns”WhenNotEqualsTo(SqlExpression, SqlExpression)
Section titled “WhenNotEqualsTo(SqlExpression, SqlExpression)”public static SqlExpression WhenNotEqualsTo(SqlExpression resultOperand, SqlExpression notEqualsToOperand)Parameters
Section titled “Parameters”resultOperandSqlExpressionnotEqualsToOperandSqlExpression
Returns
Section titled “Returns”operator +(SqlExpression, SqlExpression)
Section titled “operator +(SqlExpression, SqlExpression)”public static SqlExpression operator +(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator &(SqlExpression, SqlExpression)
Section titled “operator &(SqlExpression, SqlExpression)”public static SqlExpression operator &(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator |(SqlExpression, SqlExpression)
Section titled “operator |(SqlExpression, SqlExpression)”public static SqlExpression operator |(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator /(SqlExpression, SqlExpression)
Section titled “operator /(SqlExpression, SqlExpression)”public static SqlExpression operator /(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator ^(SqlExpression, SqlExpression)
Section titled “operator ^(SqlExpression, SqlExpression)”public static SqlExpression operator ^(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”explicit operator SqlExpression(SqlQuerySelect)
Section titled “explicit operator SqlExpression(SqlQuerySelect)”public static explicit operator SqlExpression(SqlQuerySelect select)Parameters
Section titled “Parameters”selectSqlQuerySelect
Returns
Section titled “Returns”operator >(SqlExpression, SqlExpression)
Section titled “operator >(SqlExpression, SqlExpression)”public static SqlCondition operator >(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator >=(SqlExpression, SqlExpression)
Section titled “operator >=(SqlExpression, SqlExpression)”public static SqlCondition operator >=(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator <<(SqlExpression, int)
Section titled “operator <<(SqlExpression, int)”public static SqlExpression operator <<(SqlExpression left, int right)Parameters
Section titled “Parameters”leftSqlExpressionrightint
Returns
Section titled “Returns”operator <(SqlExpression, SqlExpression)
Section titled “operator <(SqlExpression, SqlExpression)”public static SqlCondition operator <(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator <=(SqlExpression, SqlExpression)
Section titled “operator <=(SqlExpression, SqlExpression)”public static SqlCondition operator <=(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator %(SqlExpression, SqlExpression)
Section titled “operator %(SqlExpression, SqlExpression)”public static SqlExpression operator %(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator *(SqlExpression, SqlExpression)
Section titled “operator *(SqlExpression, SqlExpression)”public static SqlExpression operator *(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator ~(SqlExpression)
Section titled “operator ~(SqlExpression)”public static SqlExpression operator ~(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
Returns
Section titled “Returns”operator >>(SqlExpression, int)
Section titled “operator >>(SqlExpression, int)”public static SqlExpression operator >>(SqlExpression left, int right)Parameters
Section titled “Parameters”leftSqlExpressionrightint
Returns
Section titled “Returns”operator -(SqlExpression, SqlExpression)
Section titled “operator -(SqlExpression, SqlExpression)”public static SqlExpression operator -(SqlExpression left, SqlExpression right)Parameters
Section titled “Parameters”leftSqlExpressionrightSqlExpression
Returns
Section titled “Returns”operator -(SqlExpression)
Section titled “operator -(SqlExpression)”public static SqlExpression operator -(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression