Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
There are a lot of articles and presentations that show little love for ORMs. This is mainly because some queries are so complex and heavy on the database that they lead to significant issues in p...
#1: Initial revision
by
Alexei
·
2022-02-06T13:13:54Z (almost 3 years ago)
How to write database friendly code when using an ORM?
There are [a](https://www.youtube.com/watch?v=evLx2TKTFI8) [lot](https://www.linkedin.com/pulse/can-we-talk-orm-crisis-vedran-bilopavlovi%C4%87/) [of articles](https://martinfowler.com/bliki/OrmHate.html) [and presentations](https://en.wikipedia.org/wiki/Object%E2%80%93relational_impedance_mismatch) that show little love for ORMs. This is mainly because some queries are so complex and heavy on the database that they lead to significant issues in production. After quickly reading the aforementioned article I understand that there are many incompatibilities between how databases (tables) work and ORM which is typically tied to an OOP language and that one should not expect them to work together very well. I am interested in a short guide that shows how to try to get the best of both worlds, as much as possible. For narrowing down the request, I will focus on the Entity Framework.