Re: Entity Framework is an abomination and shouldn't even exist
Valid points, however...
An ORM Like EF allows you to build a database driven app that's decoupled from any particular RDBMS. As such it's very popular for moduralization and open source projects, etc.
If you build an app on EF, you can move it from MS SQL Server to PostgreSQL to MySql, etc just by changing your connection string and running "dotnet ef database update" in a command line.
If you write all the SQL yourself, you have to maintain separate sets of SQL for each RDBMS you want to support in your product. Most cases, the product just get's limited to one specific RDBMS e.g. "Microsoft SQL Server".
As such, using EF cuts costs drastically in development time, and it's a lot faster in dotnet Core than it was previously on .Net with EF6. EF7 is pretty quick compared to EF6 in my opinion.
Also, there are Micro ORM's like PetaPoco which are really fast and give the same benefits of EF in terms of being able to support multiple RDBMS's. However with peta poco you are basically just making tables and not using any views or stored procedures.
Biting the hand that feeds IT
