> These are the basic problems ORMs solve splendidly. Depends on the ORM. I have noticed that typically, 'unit of work' type ORMs (EFCore and Hibernate/NHiber

> These are the basic problems ORMs solve splendidly. Depends on the ORM. I have noticed that typically, 'unit of work' type ORMs (EFCore and Hibernate/NHibernate as examples) prevent being 'true to the ORM' but 'efficient'. i.e. Hibernate and EFCore (pre 7 or 8.0ish) cannot do a 'single pass update'. You have to first pull the entities in, and it does a per-entity-id update statement. > I just fail to see what else would you do, besides implementing a bug-ridden, half-ORM yourself. Eh, you can do 'basic' active-record style builders on top of dapper as an afternoon kata, if you keep feature set simple, shouldn't have bugs. That said, I prefer micro-ORMs that at most provide a DSL for the SQL layer. less surprises and more concise code.