How to load huge data in entity framework

Feb 21 2019 12:32 PM

How to load huge data in entity framework mvc. For indexing how to write indexing for complex queries or for join queries. please give me a small example for this. i have huge records and in my project i am loading full data once and then pagination i am doing so it tooks so much time. Please suggest me some idea where i can load the first 100 data first and then it loads as per pagination.