Query Extensions

Query Extensions

For more information on query extensions, check out this PLINQO feature video.

Each of the query extension methods generated are composable meaning you can chain the methods together to build the desired functionality out of smaller parts and take full advantage of reuse.

task = context.Task.GetByKey(1);
tasks = context.Task.ByAssignedId(1).ByStatusId(1);
List taskList = tasks.ToList();

Comparison Operators

We have found that querying equality only solves a portion of your querying needs and that is not going to cut it. We want all of our querying needs met. To do that, the PLINQO query extensions use containment operators. For example, the database contains a person table and the requirement is to find all the record with an age greater than 21, there is a comparison operator for that.

db.User.ByAge(21, ComparisonOperator.GreaterThan);

The comparison operators provide all the options to filter data(Equals, GreaterThan, GreaterThanOrEquals, LessThan, LessThanOrEquals and NotEquals). PLINQO makes it a lot simpler and easier to meet all requirements when filtering data.

Next: Caching