Some experienced developer shared a same conclusion about MVC and ORM.
FIRST the ENTHUSIASM
For administrative web sites where CRUD feature are the core purpose. The entity framework (or ORM) combined with the MVC model allow to quickly develop the interface.
But when it comes to add complex reporting Entity Framework and the ORM in general are showing their limits.
- First in terms of simplicity in the implementation. the queries are becoming complex and the need of modifying the generated classes (Partial Class) will be time consuming.
- The other consequence is the performance of the solution. Mainly the performance of the ORM for these queries.
Regarding the MVC, it becomes complexe when the design of the solution is not limited to the CRUD feature. Passing the model to the controler and the view can become complex.