locked
Entity Framework Speed Consideration RRS feed

  • Question

  • Hello,

    I am building a rather large application with Entity Framework and it is working very well for the vast majority of the program. However, I am currently facing a page with a complex request that takes a very long time to finish. I pinpointed the delay to the database call, but when I make that same request directly in SQL Server Management Studio, it completes a lot faster (about five seconds compared to one minute).

    I made some searches that indicate that the overhead for Entity Framework to build a complex request can result in performance loss. Some websites recommanded using a tool like dapper for complex queries.

    I would like to have your opinion before changing anything.

    Thank you very much for your assistance,

    Francis

    Thursday, February 23, 2012 9:40 PM

Answers

All replies