Add BulkInsert/Bulk Copy to the ormlite databases you can
Being able to bulk insert/copy would be cool.
Adding support in so I could just take a list and
Db.BulkCopy(listOfObjects);
would be pretty sweet.
SqlServer has the bulkCopy object, postgres has the copy command, sqlite has import (although no idea how well that works) , and mysql...well...who cares (i don't know what they have)
Having a single interface for bulk copying objects into different databases I think would be a nice feature for ormlite. (not sure how feasible)
Kyle Gobel
shared this idea
-
Eli Gassert
commented
FWIW I've been using DapperPlus (poorly named... you don't need Dapper for it!) as my solution and have had a TON of success with it. The only thing you gotta do is convert your OrmLite connection to the raw DB connection. There's an extension method for it. The exact name escapes me, but it's something like ToDbConnection() or something like that.
-
Kevin Howard
commented
Check out this link: https://gist.github.com/zelid/6965002
It's a little dated, but with a couple of small changes, it does work.
-
Marco
commented
Great idea!
-
Johann Klemmack
commented
I've used SqlBulkCopy frequently, and I often have to "tweak" the load parameters. To make this effective, and cross-DB compatible, we'd have to make a BulkLoaderFactory(tablename) Further, I suspect we'd have to create DB-provider-specific "BulkLoader" class that abstracts the most common interfaces....