Query extensions

Watch the Query Extensions video on YouTube.

The query extension methods PLINQO generates are composable: you chain them to build the query you need out of smaller, reusable parts.

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

The methods are generated by the Query extensions template.

Comparison operators

Equality only covers some of your queries. The query extensions also take a comparison operator. For example, to find the users older than 21:

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

The comparison operators are Equals, GreaterThan, GreaterThanOrEquals, LessThan, LessThanOrEquals and NotEquals.