Database query filtering in ASP.Net core web api

Question

I am creating a web API in ASP.net core for my angular frontend and right now I have implemented a filtering feature on my frontend page where the users can filter and sort the data using any field, with regex filters, and also allow the user to only show a number of elements on each page. the problem with this is that: every time I have to send all the data from my backend which won't come in handy when I have a big database, so I must do the filtering, ordering, and paging on my backend depending on what the user requested from the front. How's this problem usually solved? are there known technics for doing this?

Dmitry Grebennikov · Accepted Answer · 2020-11-16 10:25:04Z

2

You have a lot of options for that:

Use Dapper. It's great solution for query, filter, arrange data. Link to documentation - Dapper documentation
Use Entity Framework Core or other ORM. But first you need to create a model from your existing database. Link to documentation - EF Core documentation
Use ADO.Net. It's a proprietary way to access SQL database for .NET solutions. Link to documentation - ADO.Net docmentation

I hope it will help you to quick query and filter your data on backend side.

answered Nov 16, 2020 at 10:25

Dmitry Grebennikov

4543 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

YOUSFI Mohamed Walid Over a year ago

thanks for the guidance, I will dig into that alone now

Collectives™ on Stack Overflow

Database query filtering in ASP.Net core web api

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related