Server side processing in jQuery-ajax datatable with asp.net core mvc

• asp.net core mvc 3.1
• microsoft sql server
• jQuery-ajax

Needed tools

• Visual Studio 2019 or VS code
• .Net Core SDK 3.1
• Microsoft SQL Server Management Studio or Azure Data Studio

To run

• Clone or download source code from this repo.
• Open with visual studio 2019 or VS code.
• Run script file from DB script folder to your Microsoft SQL Database.
• Change your database credentials to appsettings in code.

What you'll Learn

With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to a server where an SQL Server. See official documentation here.

Demo with image: