How to load huge data in entity framework
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.