search

neisbut / EntityFramework.MemoryJoin

Extension for EntityFramework for joins to in-memory data
MIT License
56 stars 24 forks source link

Variable insert limit 2100 error #13

Closed Eits-Ian closed 4 years ago

Eits-Ian commented 4 years ago

If you try to insert more than 2100 itemes in the FromLocalList it will error and you will need to batch and concat before the query. I tried the same using Thinktecture.EntityFrameworkCore.SqlServer BulkInsertValuesIntoTempTableAsync which worked with greater than the 2100 limit.

neisbut commented 4 years ago

Hi @Eits-Ian, please try calling FromLocalList with specifying ValuesInjectionMethod.ViaSqlQueryBody like this:

var query = context.FromLocalList(data, ValuesInjectionMethod.ViaSqlQueryBody);

Please let me know if that helps.

Eits-Ian commented 4 years ago

Hi Anton,

That was the first thing I did making it implicit however no difference.

neisbut commented 4 years ago

@Eits-Ian , hm, that is weird. Can provide more details please? What EF version, what entity and mapping was used? I will try to replicate on my side.

neisbut commented 4 years ago

Closed due to inactivity