JSON in SQL Server 2016: 

JSON in SQL Server 2016: Part 1 of 4

JSON in SQL Server 2016: Part 2 of 4

JSON in SQL Server 2016: Part 3 of 4

JSON in SQL Server 2016: Part 4 of 4

https://sqlwithmanoj.com/2015/06/01/exportconvert-table-or-sql-query-data-to-json-string-format-sql-server-2016-part-1/

https://sqlwithmanoj.com/2015/10/30/importread-a-json-string-and-convert-it-in-tabular-rowcolumn-form-sql-server-2016-part-2/

https://sqlwithmanoj.com/2015/11/01/reading-json-string-with-nested-elements-sql-server-2016-part-3/

https://sqlwithmanoj.com/2015/11/02/store-json-data-in-a-table-openjson-and-json_value-functions-sql-server-2016-part-4/

Stored Procedure: Searching, Paging, Sorting

1. Creating Stored Procedures with Dynamic Search (filter)

2. Creating Stored Procedures with Dynamic Search & Paging (Pagination)

3. Creating Stored Procedure with Dynamic Search, Paging and Sorting

Older

http://www.csharpdocs.com/sorting-filtering-searching-pagination-using-sql-stored-procedure/

https://www.c-sharpcorner.com/UploadFile/6bb76f/searching-sorting-and-paging-using-sql-query/

https://dotnetdaily.net/featured/fast-sql-server-stored-procedure-with-filtering-sorting-and-paging

http://www.sqlpointers.com/2009/10/custom-sorting-and-paging-in-sql-server.html

.NET Core Model Binding

https://andrewlock.net/model-binding-json-posts-in-asp-net-core/