From Dev.to
One Line of EF Core Config Cut My Query’s Reads by 99%
Your EF Core query is correct. It returns the right row. The column has an index. And SQL Server still reads the whole index to find one row. The cause is one EF Core default that most C# developers n...