Explain the ways to increase the performance of EF.

1.	Explain the ways to increase the performance of EF.
Answer» Entity Framework's performance is enhanced by following these steps: Choose the RIGHT collection for data manipulation. Do not put all DB objects into one entity model. When the entity is no longer REQUIRED, its tracking should be disabled and altered. Use pre-generating Views to reduce response TIME for the first request. Don't fetch all fields unless needed. Whenever possible, avoid USING Views and Contains. Bind data to a grid or paging only by retrieving the number of records needed. Optimize and debug LINQ queries. Whenever possible, use compiled queries.

Answer»

Entity Framework's performance is enhanced by following these steps:

Choose the RIGHT collection for data manipulation.
Do not put all DB objects into one entity model.
When the entity is no longer REQUIRED, its tracking should be disabled and altered.
Use pre-generating Views to reduce response TIME for the first request.
Don't fetch all fields unless needed.
Whenever possible, avoid USING Views and Contains.
Bind data to a grid or paging only by retrieving the number of records needed.
Optimize and debug LINQ queries.
Whenever possible, use compiled queries.

Discussion