Using dynamic LINQ
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.
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
xunit is the package we will be using for the unit tests and