Re:The ORM Debate Still Rages On
by scarface74 on Monday April 24, 2017 @03:47PM
(#14187472)
Coming from c# and using Linq:
1. Type safety instead of magic strings
2. Composibiity of queries.
3. Testability - I can mock out the dbcontext in unit test and use an in memory List<T> to test queries without having a database dependencies.
But these days, for any new project, my default is to avoid relational databases unless there is good reason for them. Even for BI, my live database is more than likely going to be NoSql and use a combination of CQRS, Event Sourcing, and messaging.
1. Type safety instead of magic strings
2. Composibiity of queries.
3. Testability - I can mock out the dbcontext in unit test and use an in memory List<T> to test queries without having a database dependencies.
But these days, for any new project, my default is to avoid relational databases unless there is good reason for them. Even for BI, my live database is more than likely going to be NoSql and use a combination of CQRS, Event Sourcing, and messaging.