3 ms·
At least when I see raw sql I know me and the author are on a level playing field. I would rather deal with a directory full of sql statement that get run than
by sherburt3 1y ago
At least when I see raw sql I know me and the author are on a level playing field. I would rather deal with a directory full of sql statement that get run than some mysterious build tool that generates sql on the fly and thinks its smarter than me.
For example, I'm working on a project right now where I have to do a database migration. The project uses c# entity framework, I made a migration to create a table, realized I forgot a column, deleted the table and tried to start from scratch. For whatever reason, entity framework refuses to let go of the memory of the original table and will create migrations to restore the original table. I hate this so much.
- krawcu 1y agoi think you should just create another migration with alter table that adds that column
- indigo945 1y agoYou can use EF by writing the migrations yourself ("database first"). Also, whatever problem you have there seems to be easily fixed either by a better understanding of how EF's code generation works, or by more aggressive use of version control.
- Xss3 1y agoTheir point is they understand sql and dbs. They shouldnt need to learn EF and all its footguns.