search

zzzprojects / EntityFramework-Extensions

Entity Framework Bulk Operations | Improve Entity Framework performance with Bulk SaveChanges, Insert, update, delete and merge for SQL Server, SQL Azure, SQL Compact, MySQL and SQLite.
https://entityframework-extensions.net
346 stars 57 forks source link

Suggestion - Create BulkColumnStoreInsert + BulkColumnStoreMerge extension methods #139

Closed jzabroski closed 5 years ago

jzabroski commented 6 years ago

Following guidance from Microsoft, here: Columnstore indexes - Data loading guidance

Note: This is not a high priority for us, but just a potentially generally good feature for your library. You can say to customers that you automatically follow Microsoft guidance.

JonathanMagnan commented 6 years ago

Hello @jzabroski ,

Thank you, we will read about this tomorrow probably.

Best Regards,

Jonathan

JonathanMagnan commented 5 years ago

Hello @jzabroski ,

We will close this request.

I do not believe it will ever happen as it has not been accepted by our architect and the solution was often slower than a traditional table. At this point, I don't think adding more complexity by our library will also be a good idea.

Best Regards,

Jonathan

outinspace commented 4 weeks ago

Hi @JonathanMagnan, I am trying to use this library to bulk insert into a columnstore table. I understand from your comment that BulkInsert/BulkInsertOptimized were not created with columnstore tables in mind. Is there a better option that you would recommend for the use case of inserting 100k-500k rows into a columnstore table?

jzabroski commented 4 weeks ago

@outinspace This is marked as closed/completed. I'd recommend you open a new issue. You can copy-paste my initial specification idea.