ID > 0 AND Year < 2007 AND Comment != null AND (!Seen OR Comment LIKE '%Awesome%')

Table of Contents

Usage

1. Install the NuGet package

PM> Install-Package Spectre.Query

2. Create the query provider

varprovider=QueryProviderBuilder.Build(context, options=>{options.Configure<Movie>(movie=>{movie.Map("Id", e=>e.MovieId);movie.Map("Genre", e=>e.Genre.Name);movie.Map("Title", e=>e.Name);movie.Map("Year", e=>e.ReleasedAt);movie.Map("Score", e=>e.Rating);movie.Map("Seen", e=>e.Seen);});});

3. Query the database

varmovies=provider.Query<Movie>(context,"NOT Seen AND Score > 60").ToList();

Usage (ASP.NET Core)

1. Install the NuGet package

PM> Install-Package Spectre.Query.AspNetCore

2. Register the query provider

publicvoidConfigureServices(IServiceCollectionservices){services.AddQueryProvider<MovieDbContext>(options=>{options.Configure<Movie>(movie=>{movie.Map("Id", e=>e.MovieId);movie.Map("Genre", e=>e.Genre.Name);movie.Map("Title", e=>e.Name);movie.Map("Year", e=>e.ReleasedAt);movie.Map("Score", e=>e.Rating);movie.Map("Seen", e=>e.Seen);});});// ...}

publicvoidConfigure(IApplicationBuilderapp,IHostingEnvironmentenv){// This is not required, but will make sure that all// initialization is performed at start up and not at// the first time the query provider is used.app.UseQueryProvider<MovieDbContext>();// ...}

3. Query the database

[ApiController][Route("api/movies")]publicclassMovieController:ControllerBase{privatereadonlyMovieContext_context;privatereadonlyIQueryProvider<MovieContext>_provider;publicMovieController(MovieContextcontext,IQueryProvider<MovieContext>provider){_context=context;_provider=provider;}[HttpGet]publicIActionResult<List<Movie>>Query([FromHeader]stringquery="Rating > 80 AND !Seen"){return_provider.Query<Movie>(_context,query).OrderByDescending(movie=>movie.Rating).ToList()}}

License