Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Your are developed web app using the following LINQ to Entities query:
var query = from p in myContext.Orders
where p.Price < 50
int numberOfItems = query.Count();
var Orders = query.ToList();
You are suffering performance problems. How can you improve your query
on 8/31/2013 | Category:
.NET Framework Interview questions
| Views: 2534 |
Select from following answers:
Avoid hitting the database multiple times.
Don’t execute ToList() on the query
Change the query to method syntax
Because of the deferred execution nature of LINQ, you execute the query twice—one for getting the number of items, and one for getting all the orders
Show Correct Answer
Many Interviews |
< Previous :
You have a private method in your class and you wa ...
Next > :
You are developing web application in which you de ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You are developing web application in which you deploy an assembly to ...
You are using custom code generation to insert security checks into yo ...
You are using the TraceSource class to trace data for your developed w ...
You are working on a global application with lots of users. Design thi ...
Your developed web app reporting more errors and you want to configure ...
You are debugging an web application for a online shop and are inspec ...
You are done with web app development and now ready to deploy your cod ...
You developed web app use an assembly that will be used by a couple of ...
Latest Interview Questions
How to import Excel into Sql table by using Store Procedure?
How to Delete the Duplicate values in sql table?
Which is correct about controller.
What is View models
Why can't you open a new browser window from within server code?
What is the main difference between the Button server control and the ...
List the EmpNo,EName,Sal Daily Sal of all Emps in the ascending order ...
write a query the name ends with 'i' using sql server?