Is it possible to create Batch insert?

Question

i just started discovering serviceStack ORMlite , and i am trying to figure out how to do batch inserts. Are there any example of this anywhere ?

Thanks in advance

Answer 1

There's currently no built-in support take take advantage of custom RDBMS's support for this feature. E.g. MySQL's Batch Insert support.

The Insert and InsertAll methods in OrmLite do already accept multiple entities, but they're executed individually.

Depending on the database (that support batch insert via SQL) you can execute custom arbitrary SQL by using IDbCommand.ExecuteSql method.