entity framework extensions
BULK INSERT and
MERGE INTO statements with entity framework using Entity Framework Extensions. A free trial exists but the paid option is worth it and the developer responds and fixes issues very quickly.
disable client evaluation
Client evaluation can occur unexpectedly for some developers (in addition to the
GroupBy case above), but efcore can be configured to throw where client evaluation occurs;
optionsBuilder .UseSqlServer(...) .ConfigureWarnings(warnings => warnings.Throw(RelationalEventId.QueryClientEvaluationWarning));
Until efcore 2.1,
GroupBy is performed by the client, and not in the database.