Batch insert support about dapper.fsharp HOT 6 CLOSED

Hi @64J0,
you can insert more at the same time, but not in a batch manner. But I am open to discussing addition / PR.

from dapper.fsharp.

You mean... something like this?

https://github.com/Dzoukr/Dapper.FSharp/blob/34fb244d6088c26a36ad7da6d5f4bd28bfa8d323/tests/Dapper.FSharp.Tests/MSSQL/InsertTests.fs#L106C1-L122C10

from dapper.fsharp.

You mean... something like this?

Yes, that is it. I think this is enough to cover my use case. Thanks for sharing it @Dzoukr.

Just to clarify, why you don't consider this approach to be a batch insertion?

from dapper.fsharp.

Because I am not sure, how it would scale for hundreds of thousands of rows. AFAIK you cannot have more than 1000 rows in a single query it may require splitting before running. But for relatively reasonable numbers it's good enough.

from dapper.fsharp.

Got it. Thanks for the detailed replies. I'm going to close this issue now.

from dapper.fsharp.

The syntax I have in mind:

let listOfPerson : Person list = [personA; personB; personC]

insert {
   into personTable
   value listOfPerson
}

Where we pass a list of person instead of a single element.

from dapper.fsharp.