Your are developed web app using the following LINQ to Entities query:

var query = from p in myContext.Orders
where p.Price < 50
select p;
int numberOfItems = query.Count();
var Orders = query.ToList();

You are suffering performance problems. How can you improve your query

 Posted by Rajkatie on 8/31/2013 | Category: .NET Framework Interview questions | Views: 2357 | Points: 40
Select from following answers:
  1. Avoid hitting the database multiple times.
  2. Don’t execute ToList() on the query
  3. Change the query to method syntax
  4. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response