API Reference
Class
ConditionBuilder
Adds typed conditions.
Inheritance
- Object
- ConditionBuilder
Constructors
public ConditionBuilder() #Methods
public ConditionBuilder Between(String column, Double from, Double to, Boolean inclusive = true) #Returns:
ConditionBuilderNumber between range.
Parameters
- column System.String
- from System.Double
- to System.Double
- inclusive System.Boolean = true
public ConditionBuilder BoolEq(String column, Boolean value) #Returns:
ConditionBuilderBoolean equals.
Parameters
- column System.String
- value System.Boolean
public ConditionBuilder CaseSensitive(Boolean enable = true) #Returns:
ConditionBuilderSets CaseSensitive on the most recent string condition.
Parameters
- enable System.Boolean = true
public ConditionBuilder DateBetween(String column, DateTime from, DateTime to, Boolean inclusive = true, String inputFormat = null) #Returns:
ConditionBuilderDate between range.
Parameters
- column System.String
- from System.DateTime
- to System.DateTime
- inclusive System.Boolean = true
- inputFormat System.String = null
public ConditionBuilder DateEq(String column, DateTime value, String inputFormat = null) #Returns:
ConditionBuilderDate equals.
Parameters
- column System.String
- value System.DateTime
- inputFormat System.String = null
public ConditionBuilder Format(String format) #Returns:
ConditionBuilderSets the input date format on the last date condition.
Parameters
- format System.String
public ConditionBuilder Ge(String column, Double value) #Returns:
ConditionBuilderNumber greater or equal.
Parameters
- column System.String
- value System.Double
public ConditionBuilder Greater(String column, Double value) #Returns:
ConditionBuilderAlias for Double) to improve readability.
Parameters
- column System.String
- Column identifier.
- value System.Double
- Threshold value.
Returns
The current builder.
public ConditionBuilder GreaterOrEqual(String column, Double value) #Returns:
ConditionBuilderAlias for Double) to improve readability.
Parameters
- column System.String
- Column identifier.
- value System.Double
- Threshold value.
Returns
The current builder.
public ConditionBuilder Gt(String column, Double value) #Returns:
ConditionBuilderNumber greater than.
Parameters
- column System.String
- value System.Double
public ConditionBuilder Le(String column, Double value) #Returns:
ConditionBuilderNumber less or equal.
Parameters
- column System.String
- value System.Double
public ConditionBuilder Less(String column, Double value) #Returns:
ConditionBuilderAlias for Double) to improve readability.
Parameters
- column System.String
- Column identifier.
- value System.Double
- Threshold value.
Returns
The current builder.
public ConditionBuilder LessOrEqual(String column, Double value) #Returns:
ConditionBuilderAlias for Double) to improve readability.
Parameters
- column System.String
- Column identifier.
- value System.Double
- Threshold value.
Returns
The current builder.
public ConditionBuilder Like(String column, String rx) #Returns:
ConditionBuilderString regex like.
Parameters
- column System.String
- rx System.String
public ConditionBuilder Lt(String column, Double value) #Returns:
ConditionBuilderNumber less than.
Parameters
- column System.String
- value System.Double
public ConditionBuilder NotLike(String column, String rx) #Returns:
ConditionBuilderString regex not-like.
Parameters
- column System.String
- rx System.String
public ConditionBuilder NumberEq(String column, Double value) #Returns:
ConditionBuilderNumber equals.
Parameters
- column System.String
- value System.Double
NumberIn 2 overloads
public ConditionBuilder NumberIn(String column, IEnumerable<Double> values) #Returns:
ConditionBuilderCreates an IN filter for numeric columns.
Parameters
- column System.String
- values System.Collections.Generic.IEnumerable{System.Double}
public ConditionBuilder NumberIn(String column, params Double[] values) #Returns:
ConditionBuilderNumber IN (...) convenience params overload.
Parameters
- column System.String
- values System.Double[]
public ConditionBuilder NumberNe(String column, Double value) #Returns:
ConditionBuilderNumber not equals.
Parameters
- column System.String
- value System.Double
NumberNotIn 2 overloads
public ConditionBuilder NumberNotIn(String column, IEnumerable<Double> values) #Returns:
ConditionBuilderCreates a NOT IN filter for numeric columns.
Parameters
- column System.String
- values System.Collections.Generic.IEnumerable{System.Double}
public ConditionBuilder NumberNotIn(String column, params Double[] values) #Returns:
ConditionBuilderNumber NOT IN (...) convenience params overload.
Parameters
- column System.String
- values System.Double[]
public ConditionBuilder Reverse(Boolean enable = true) #Returns:
ConditionBuilderSets ReverseCondition on the last added condition.
Parameters
- enable System.Boolean = true
public ConditionBuilder StringContains(String column, String pattern, Boolean caseSensitive = false) #Returns:
ConditionBuilderString contains (regex).
Parameters
- column System.String
- pattern System.String
- caseSensitive System.Boolean = false
public ConditionBuilder StringEq(String column, String value, Boolean caseSensitive = false) #Returns:
ConditionBuilderString equals condition.
Parameters
- column System.String
- value System.String
- caseSensitive System.Boolean = false
StringIn 2 overloads
public ConditionBuilder StringIn(String column, IEnumerable<String> values) #Returns:
ConditionBuilderCreates an IN filter for string columns.
Parameters
- column System.String
- values System.Collections.Generic.IEnumerable{System.String}
public ConditionBuilder StringIn(String column, params String[] values) #Returns:
ConditionBuilderString IN (...) convenience params overload.
Parameters
- column System.String
- values System.String[]
public ConditionBuilder StringNe(String column, String value, Boolean caseSensitive = false) #Returns:
ConditionBuilderString not equals condition.
Parameters
- column System.String
- value System.String
- caseSensitive System.Boolean = false
public ConditionBuilder StringNotContains(String column, String pattern, Boolean caseSensitive = false) #Returns:
ConditionBuilderString not contains (regex).
Parameters
- column System.String
- pattern System.String
- caseSensitive System.Boolean = false
StringNotIn 2 overloads
public ConditionBuilder StringNotIn(String column, IEnumerable<String> values) #Returns:
ConditionBuilderCreates a NOT IN filter for string columns.
Parameters
- column System.String
- values System.Collections.Generic.IEnumerable{System.String}
public ConditionBuilder StringNotIn(String column, params String[] values) #Returns:
ConditionBuilderString NOT IN (...) convenience params overload.
Parameters
- column System.String
- values System.String[]
public ConditionBuilder UsingHtmlStore() #Returns:
ConditionBuilderForces the most recent condition to use the HTML data store.
public ConditionBuilder UsingJavaScriptStore() #Returns:
ConditionBuilderForces the most recent condition to use the JavaScript data store.