entity-framework

Add 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.

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;

        
csharp
        

            
        
     
optionsBuilder
    .UseSqlServer(...)
    .ConfigureWarnings(warnings => warnings.Throw(RelationalEventId.QueryClientEvaluationWarning));

More information

Until efcore 2.1, GroupBy is performed by the client, and not in the database.

• IRepository & IUnitOfWork