Using dynamic LINQ

The IQueryable<T> interface offers interesting possibilities for composing queries with some degree of dynamism. However, sometimes that is enough. Imagine, for example, that you want to filter by some text expression or order by a property for which you only have the name. Enter Dynamic LINQ: a means to combine strongly typed LINQ queries with text expressions. Let's see how it works.

Getting ready

We will be using the NuGet Package Manager to install the Entity Framework Core 1 package, Microsoft.EntityFrameworkCore. We will also be using a SQL Server database for storing the data, so we will also need Microsoft.EntityFrameworkCore.SqlServer.

Finally, xunit is the package we will be using for the unit tests and dotnet-text-xunit ...

Get Entity Framework Core Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.