Dynamic High Performance Query Builder using DataTables and LinqKit for Over a Million Records

In this article, we will see how to perform specific and multiple column searches, sorting, dynamic page sizing, be non-database specific, handle very large data, have elegant code structure, least coding effort and most of all performance features in a single, easy to code and easy to manage solution without degrading the performance aspect.