title: SQL SP using LINQ and EF
body: <p>I am using LINQ for my DB EF model. I have a particularly complex logic to generate a report and I initially tried to create a view and access it using LINQ. The performance was quite low due to multiple joins and multiple sub queries in the view so now I am thinking of moving the logic to an SP which I believe will increase the performance.</p>
  
  <p>I need to know if there are any known issues with using SP with LINQ in EF. And am I doing something wrong or anti-pattern. Please let me know if there are any alternatives too.</p>
  
  <p>Regards,
  Bhavik</p>