1.

How Can You Enhance The Performance Of Entity Framework?

Answer»

To enhance the performance of Entity Framework, you have to follow the following steps

  • Try to avoid to put all the DB objects into one single entity model
  • Disable change tracking for entity if not NEEDED
  • Reduce response TIME for the first request by using pre-generating Views
  • If not required try to avoid FETCHING all the fields
  • For data manipulation select appropriate collection
  • Wherever needed USE compiled query
  • Avoid using Views and Contains
  • While binding data to GRID or paging, retrieve only required no of records
  • Debug and Optimize LINQ query

To enhance the performance of Entity Framework, you have to follow the following steps


Discussion

No Comment Found

Related InterviewSolutions