Allow more granular configuration of batch size

[justhoma-zz]

We are running into an issue where EF is creating a merge statement for inserts of multiple records within the same context.
The query runs fine when we are pointed at a physical table, but in our case, our implementation is running an insert against a View.

When executed against SQL Server, we get the following error:

The column reference "inserted.rec_id" is not allowed because it refers to a base table that is not being modified in this statement.

So in order to get the insert to work against the view, we needed to comment out the following from the generated EF statement:

            DECLARE @inserted4 TABLE ([REC_ID] int, [_Position] [int]);
            OUTPUT INSERTED.[REC_ID], i._Position
            INTO @inserted4

Is there a way to get EF to generate this insert as multiple insert statements? Or Generate the statements without the Declare/Output/Input commands.

Further technical details

EF Core version: 2.0.3
Database Provider: Microsoft.EntityFrameworkCore.SqlServer
Operating system: Win10
IDE: Visual Studio 2017 15.7.4

[ErikEJ]

I think you can try to set MaxBatchSize to 1

[justhoma-zz]

This would impact all updates...correct? Is it possible to do this at a more granular level?

[ajcvickers]

Triage: Putting this on the backlog to allow maximum batch size to be set with more granularity--probably per table.

[jzabroski]

Can you post sample repro code?