Brent Ozar points out one issue you might run into when using Entity Framework:
Most of the time, I love Entity Framework, and ORMs in general. These tools make it easier for companies to ship applications. Are the apps perfect? Of course not – but they’re good enough to get to market, bring in revenue to pay salaries, and move a company forwards.
However, just like any tool, if you don’t know how to use it, you’re gonna get hurt.
One classic example popped up again last month with a client who’d used EF Core to design their database for them. The developers just had to say which columns were numbers, dates, or strings, and EF Core handled the rest.
Read on for the scenario.