loading...

re: ORM vs. SQL? VIEW POST

FULL DISCUSSION
 

I see a lot of "ORM for simplifying CRUD Logic, Raw SQL for specific business logic".

I wanted to get into using an ORM for the first reason mentioned. However, the "Read" part of CRUD logic was never a simple read. I was using Entity Framework. Creating complex queries with Linq expressions usually involved loading all of them into memory and filtering in memory. Performance was a big issue. Also all our legacy code had lots of business logic within SQL queries, which is usually a no-no for using an ORM.

Instead, we're working on creating our own slimmed down ORM for just the CRUD logic. Similar to the dataMapper solution that has been suggested.

code of conduct - report abuse