• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!


Entity Framework Performance and What You Can Do About It

Page history last edited by Nathan T Suver 5 years, 1 month ago




The article, from 2015, discussed some performance enhancement techniques for optimizing entity framework generated sql calls.

Entity framework is an object relational mapping tool that allows developers to write classes which model their data, and the framework uses information from the class metadata to dynamically construct Sql statements to perform CRUD operations.  Performance of entity framework is generally known to be poor, so this article addresses some tricks and techniques for mitigating performance problems.  EF might be a useful tool to use for this project, to assist in potentially reducing refactor time.  One useful optimization, for example, is the "MultipleActiveResultSet"  connection property, which allows the caller to retrieve multiple distinct query results at once for a given connection, reducing round trips to the database.  They also recommend the use of caching whenever possible.  It might not be a bad idea to explore some research on using a high availability in-memory cache such as redis.

Comments (0)

You don't have permission to comment on this page.