MutableIdeas.Web.Linq.Query.Service 2.4.5

MutableIdeas.Web.Linq.Query.Service

Parses a formatted string and that provides the user a an expression for filtering.

Parses a formatted string that will sort an entity set by its property be acsending or descending order.

Filtering

Format for Filtering

String values

propertyName comparison 'stringValue'

Numeric values

propertyName comparison numericvalue

Joined Filters

propertyName comparison 'value' operator propertyName comparison 'value'

Definitions

propertyName - The property name of the entity which to filter. Property names are not case sensitive.

comparison - The type of comparison on the property needed to filter

Valid comparison values are:

• eq - Equal
• lt - Less Than
• lte - Less Than or Equal to
• ne - Not Equal
• gt - Greater Than
• gte - Greater Than or Equal to
• ct - For string values, contains
• ctic - For string values, contains ignore case
• in - Looks for values in an array supplied
• leneq - the length of a string or an enumerable.Count is equal
• lenne - the length of a string or an enumerable.Count is not equal. This will include null values.
• lengt - the length of a string or an enumerable.Count is greater than
• lengte - the length of a string or an enumerable.Count is greater than or equal to
• lenlt - the length of a string or an enumerable.Count is less than. This will include null values.
• lenlte - the length of a string or an enumerable.Count is less than or equal to. This will include null values.

value - The value of the property you want to filter. String values need to be enclosed by single quotes and need to be URL ESCAPED.

operator

Valid operator values

• and
• or

Examples for Filtering

• name eq 'Red%20Wings' - Entity.Name == "Red Wings"
• name ne 'Avs' - Entity.Name != "Avs"
• name ct 'Red' - Entity.Name.Contains("Red")
• name ctic 'Red' - Entity.Name.ToLower().Contains("red")
• price gt 20 and price lt 50 - *Entity.Price > 20 && Entity.Price < 50
• price gte 20 and price lte 50 - Entity.Price ⇒ 20 && Entity.Price ⇐ 50
• name eq 'Red%20Wings' or price eq 5 - Entity.Name == "Red Wings" || Entity.Price == 5

Enumerables

Note - Enumerable properties must be initialized in your entities.

• enumerable in ['value1', 'value2', 'value3'] - * arrayValuesSupplied.Contains(Entity.enumerable.value);
• enumerable leneq 3 - Entity.Enumerable.Distinct().Count() == 3
• enumerable lenne 4 - Entity.Enumerable.Distinct().Count() != 4
• enumerable lengt 2 - Entity.Enumerable.Distinct().Count() > 2
• enumerable lengte 4 - Entity.Enumerable.Distinct().Count() >= 4
• enumerable lenlt 3 - Entity.Enumerable.Distinct().Count() < 3
• enumerable lenlte 3 - Entity.Enumerable.Distinct().Count() ⇐ 3

Nested Enumerables

• enumerable.enumerableProperty lengt 3 - Entity.Enumerable != null && Entity.Enumerable.Where(p ⇒ p.EnumerableProperty.Any()).SelectMany(p ⇒ p.EnumerableProperty).Distinct().Count() > 3

Assuming name is a string

• name leneq 3 - Entity.name != null && Entity. name.Length == 3
• name lenne 3 -Entity.name == null || Entity.name.Length != 3
• name lengt 2 - Entity.name != null && Entity.name.Length > 2
• name lengte 2 - Entity.name != null && Entity.name.Length >= 2
• name lenlt 3 - Entity.name == null || Entity.name.Length < 3
• name lenlte 3 - Entity.name == null || Entity.name.length ⇐ 3

Sorting

Format for Sorting

propertyName sortOrder

Definitions

propertyName - The property name of the entity which to filter. Property names are not case sensitive.

sortOrder (optional) - By default this will be in ascending order

Valid values for sortOrder

• asc - Ascending order
• desc - Descending order
• natasc - Natural sorting for string values in ascending order, ex: ⇒ ["C1", "C2", "C10"]
• natdesc - Natural sorting for string values in descending order, ex ⇒ ["C10", "C2", "C1"]

Examples for sorting

• name - default ascending order
• name desc - sort descending order
• name asc - sort ascending order

C# Services

QueryExpressionService<T>

Methods

Expression<Func<T, bool>> GetExpression(string filter)

• filter - From the filters listed above, this will parse the string and create and expression that can be used for filtering.

IQueryable<T> Sort(string sort, IQueryable<T> queryable)

This will sort the entities of the queryable parameter per the sort string.

• sort - From the sorting string listed above
• queryable - A queryable entity set

FilterService<T>

Methods

By(string propertyName, string value, FilterType filtertype)

Creates a filter expression by the propertyName, value, and the type of comparison.

And()

Adds the conditional And expression for the next expression.

Or()

Adds the conditional Or expression for the next expression.

Expression<Func<T, bool>> Build() Builds the Expression from the statements above and will clear the statements

Examples

var _filterService = new FilterService<SomeClass>();

_filterService.By("Name", "Red", FilterType.Equals);

_filterService.Or();

_filterService.By("Name", "Avs", FilterType.Equals);

Expression<Func<SomeClass, bool>> expression = _filterService.Build();

Fluent Extension

var _filterService = new FilterService<SomeClass>();

_filterService.By("Name", "Red", FilterType.Equals) .Or("Name", "Blue", FilterType.Equals) .And("Status", "1", FilterType.Equals")