Fast search pages in .NET: stored procedures, Dapper and DataTables
The simple pattern we use for admin search screens on SQL Server: a parameterized stored procedure, Dapper to call it and jQuery DataTables to present it - and what to change when results get big.
ASP.NET Core SQL Server