"Can I search by this field too? And by these two, but only when…"
Your users need to search by many different parameters, in various combinations. The usual search form is a mess of controls, one per database field. It takes the whole screen and still doesn't cover the combinations people ask for, so each new request means a new field, a new query and a new release.
The EasyQuery interface is simple and intuitive: users build almost any combination of conditions they could wish for, on any field you allow, and you stop adding search fields.
EasyQuery reads your Entity Framework DbContext and offers its entities and fields to the users, under the names
you give them. You can hide fields, add lookups, and add hidden conditions of your own to every query.
EasyQuery generates the SQL and runs it on your connection.
The UI is EasyQuery.JS in your Razor pages or MVC views, or in a React, Angular, Vue or Blazor frontend. There are WinForms and WPF versions too.
builder.Services.AddEasyQuery()
.UseSqlManager()
.AddDefaultExporters();
...
app.MapEasyQuery(options => {
options.DefaultModelId = "nwind";
options.ConnectionString = connectionString;
options.UseDbContext<AppDbContext>();
});
The same scenario as a project you can open in Visual Studio and run on your machine:
Step by step: getting started with ASP.NET Core.
Don't hesitate to contact us; we are eager to assist with any inquiries.