Overview
Basics
Operations
Providers
Operations
Comparison
Service Query supports the following general comparison operations:
- Between
- Equal
- Not Equal
- Less Than
- Less Than or Equal
- Greater Than
- Greater Than or Equal
- In Set
- Not In Set
Additionally it also supports the following string comparison operations:
- Contains
- StartsWith
- EndsWith
Note about DateTime and DateTimeOffset
The default .ToString() method for DateTime and DateTimeOffset does not include timezone information. Because of this, when using comparisons against these datatypes you must use the ToString("o") method.
Example
var builder = ServiceQueryRequestBuilder.New().IsEqual("DateTimeOffsetPropertyName", myVal.ToString("o"));
Between
Example
var builder = ServiceQueryRequestBuilder.New().Between("PropertyName", "LowValue", "HighValue");
Equal
Example
var builder = ServiceQueryRequestBuilder.New().IsEqual("PropertyName", "Value");
Not Equal
Example
var builder = ServiceQueryRequestBuilder.New().IsNotEqual("PropertyName", "Value");
Less Than
Example
var builder = ServiceQueryRequestBuilder.New().IsLessThan("PropertyName", "Value");
Less Than Or Equal
Example
var builder = ServiceQueryRequestBuilder.New().IsLessThanOrEqual("PropertyName", "Value");
Greater Than
Example
var builder = ServiceQueryRequestBuilder.New().IsGreaterThan("PropertyName", "Value");
Greater Than Or Equal
Example
var builder = ServiceQueryRequestBuilder.New().IsGreaterThanOrEqual("PropertyName", "Value");
In Set
Example
var builder = ServiceQueryRequestBuilder.New().IsInSet("PropertyName", "Value1", "Value2", etc...);
Not In Set
Example
var builder = ServiceQueryRequestBuilder.New().IsNotInSet("PropertyName", "Value1", "Value2", etc...);
String Comparisons
Contains
Example
var builder = ServiceQueryRequestBuilder.New().Contains("PropertyName", "Value");
StartsWith
Example
var builder = ServiceQueryRequestBuilder.New().StartsWith("PropertyName", "Value");
EndsWith
Example
var builder = ServiceQueryRequestBuilder.New().EndsWith("PropertyName", "Value");