Navratna Pawale

Navratna Pawale

  • NA
  • 186
  • 27.2k

How to optimize LINQ query to fetch data from multiple table

Jan 25 2016 8:30 AM
I've to fetch data from 4 tables by joining them using LINQ and also have to apply sorting on it,
But it takes about 8-9 seconds to execute from the MVC application,
so how do I optimize it to be executed in just 2-3 seconds with sorting.
There are about 1000 records to be fetched.

Answers (6)