SqlClauseConditionals
Namespace: TagBites.Sql
Assembly: TagBites.DB.dll
Product: TagBites.DB v. 1.0.37
public class SqlClauseConditionals : TagBites.Sql.SqlClauseCollectionBase<TagBites.Sql.SqlCondition>Inheritance: SqlClauseCollectionBase<SqlCondition> → SqlClauseConditionals
Derived:
Constructors
Section titled “Constructors”SqlClauseConditionals()
Section titled “SqlClauseConditionals()”public SqlClauseConditionals()Methods
Section titled “Methods”Accept(SqlQueryResolver, SqlQueryBuilder)
Section titled “Accept(SqlQueryResolver, SqlQueryBuilder)”protected virtual void Accept(SqlQueryResolver resolver, SqlQueryBuilder builder)Parameters
Section titled “Parameters”resolverSqlQueryResolverbuilderSqlQueryBuilder
AddBetween(SqlExpression, SqlExpression, SqlExpression)
Section titled “AddBetween(SqlExpression, SqlExpression, SqlExpression)”public void AddBetween(SqlExpression expression, SqlExpression minValueExpression, SqlExpression maxValueExpression)Parameters
Section titled “Parameters”expressionSqlExpressionminValueExpressionSqlExpressionmaxValueExpressionSqlExpression
AddBetween(SqlTable, string, SqlExpression, SqlExpression)
Section titled “AddBetween(SqlTable, string, SqlExpression, SqlExpression)”public void AddBetween(SqlTable expressionTable, string expressionTableColumnName, SqlExpression minValueExpression, SqlExpression maxValueExpression)Parameters
Section titled “Parameters”expressionTableSqlTableexpressionTableColumnNamestringminValueExpressionSqlExpressionmaxValueExpressionSqlExpression
AddEquals(SqlExpression, SqlExpression)
Section titled “AddEquals(SqlExpression, SqlExpression)”public void AddEquals(SqlExpression leftExpression, SqlExpression rightExpression)Parameters
Section titled “Parameters”leftExpressionSqlExpressionrightExpressionSqlExpression
AddEquals(SqlTable, string, SqlExpression)
Section titled “AddEquals(SqlTable, string, SqlExpression)”public void AddEquals(SqlTable leftTable, string leftTableColumnName, SqlExpression rightExpression)Parameters
Section titled “Parameters”leftTableSqlTableleftTableColumnNamestringrightExpressionSqlExpression
AddEquals(SqlTable, string, SqlTable, string)
Section titled “AddEquals(SqlTable, string, SqlTable, string)”public void AddEquals(SqlTable leftTable, string leftTableColumnName, SqlTable rightTable, string rightTableColumnName)Parameters
Section titled “Parameters”AddIn(SqlTable, string, int[])
Section titled “AddIn(SqlTable, string, int[])”public void AddIn(SqlTable table, string columnName, int[] values)Parameters
Section titled “Parameters”AddIn(SqlTable, string, SqlExpression[])
Section titled “AddIn(SqlTable, string, SqlExpression[])”public void AddIn(SqlTable table, string columnName, SqlExpression[] values)Parameters
Section titled “Parameters”tableSqlTablecolumnNamestringvaluesSqlExpression[]
AddIntervalCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)
Section titled “AddIntervalCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)”public void AddIntervalCompleteIntersects(SqlExpression intervalAStart, SqlExpression intervalAEnd, SqlExpression intervalBStart, SqlExpression intervalBEnd)Parameters
Section titled “Parameters”intervalAStartSqlExpressionintervalAEndSqlExpressionintervalBStartSqlExpressionintervalBEndSqlExpression
AddIntervalIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)
Section titled “AddIntervalIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)”public void AddIntervalIntersects(SqlExpression intervalAStart, SqlExpression intervalAEnd, SqlExpression intervalBStart, SqlExpression intervalBEnd)Parameters
Section titled “Parameters”intervalAStartSqlExpressionintervalAEndSqlExpressionintervalBStartSqlExpressionintervalBEndSqlExpression
AddIntervalLeftCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)
Section titled “AddIntervalLeftCompleteIntersects(SqlExpression, SqlExpression, SqlExpression, SqlExpression)”public void AddIntervalLeftCompleteIntersects(SqlExpression intervalAStart, SqlExpression intervalAEnd, SqlExpression intervalBStart, SqlExpression intervalBEnd)Parameters
Section titled “Parameters”intervalAStartSqlExpressionintervalAEndSqlExpressionintervalBStartSqlExpressionintervalBEndSqlExpression
AddIsNotNull(SqlTable, string)
Section titled “AddIsNotNull(SqlTable, string)”public void AddIsNotNull(SqlTable table, string columnName)Parameters
Section titled “Parameters”AddIsNotNull(SqlExpression)
Section titled “AddIsNotNull(SqlExpression)”public void AddIsNotNull(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
AddIsNull(SqlTable, string)
Section titled “AddIsNull(SqlTable, string)”public void AddIsNull(SqlTable table, string columnName)Parameters
Section titled “Parameters”AddIsNull(SqlExpression)
Section titled “AddIsNull(SqlExpression)”public void AddIsNull(SqlExpression expression)Parameters
Section titled “Parameters”expressionSqlExpression
AddLiteralExpression(string, SqlExpression[])
Section titled “AddLiteralExpression(string, SqlExpression[])”public void AddLiteralExpression(string literalExpressionFormat, SqlExpression[] args)Parameters
Section titled “Parameters”literalExpressionFormatstringargsSqlExpression[]
AddNotEquals(SqlExpression, SqlExpression)
Section titled “AddNotEquals(SqlExpression, SqlExpression)”public void AddNotEquals(SqlExpression leftExpression, SqlExpression rightExpression)Parameters
Section titled “Parameters”leftExpressionSqlExpressionrightExpressionSqlExpression
AddNotEquals(SqlTable, string, SqlExpression)
Section titled “AddNotEquals(SqlTable, string, SqlExpression)”public void AddNotEquals(SqlTable leftTable, string leftTableColumnName, SqlExpression rightExpression)Parameters
Section titled “Parameters”leftTableSqlTableleftTableColumnNamestringrightExpressionSqlExpression
AddNotEquals(SqlTable, string, SqlTable, string)
Section titled “AddNotEquals(SqlTable, string, SqlTable, string)”public void AddNotEquals(SqlTable leftTable, string leftTableColumnName, SqlTable rightTable, string rightTableColumnName)