3 ms·
Modern EF Core can generate SQL very close to handwritten and will aggressively warn you if you do something dumb. I wouldn't worry about it.
by Hawxy 2y ago
Modern EF Core can generate SQL very close to handwritten and will aggressively warn you if you do something dumb. I wouldn't worry about it.
- magicalhippo 2y agoGood to know, though we have mostly either trivial (ie by indexed key) or complex queries, with very few "medium complexity" queries. For the complex ones we like to have full control as it almost always turns into a major ops issue if the queries are not performing well. Though perhaps if we can catch changes of the generated queries in our test suite we could let EF generate them. Trust but verify kinda deal.
- ThinkBeat 2y agoMy example was 9 months old. At least in this instance EF did not warn, and caused great problems.