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