NPredicateBuilder.EF 5.1.1

NPredicateBuilder

Simple, testable, LINQ queries.

NPredicateBuilder allows you to build small and easily testable Where and Order clauses that you can chain together to create complex queries.

Quick Overview

class PeopleQuery : BaseQuery<People>
{
    public PeopleQuery AndNameIs(string name)
    {
        AddAndCriteria(x => x.Name == name);

        return this;
    }

    public PeopleQuery OrAgeIsOver(int age)
    {
        AddOrCriteria(x => x.Age > age);

        return this;
    }
}

Then create a complex query by chaining them together.

var peopleQuery = new PeopleQuery()
    .AndNameIs("brad")
    .OrAgeIsOver(10);

Pass your queries and orders to the designated extension method.

var result = ApplicationContext.People
            .NPredicateBuilderEFWhere(peopleQuery);

Because it's just an extension method, it behaves like any other LINQ to Object or LINQ to Entities query.

var result = ApplicationContext.People
            .NPredicateBuilderEFWhere(peopleQuery)
            .Skip(10)
            .Take(15)
            .Select(x => new { x.Name, x.Age })
            .ToList();

NPredicateBuilder can easily be added to any existing or new codebase, no matter what size!

NPredicateBuilder can simplify Ordering in the same way it handles Queries.

Install NPredicateBuilder

The best way is to install with NuGet.

In your domain layer.

Install-Package NPredicateBuilder

If you are doing LINQ to Entities, install the following in your data access layer.

Install-Package NPredicateBuilder.EF

Documentation

Any and all documentation can be viewed in the wiki.

It's only a five minute read!