Zaid-Ajaj/Npgsql.FSharp

question: how can I insert lists?

thomasd3 opened this issue · 2 comments

thomasd3 commented

let's say I have:

type A =
    {
        a: string
        b: int
    }

and then and list of it: let l : A list = [.....]

how can I batch insert that list and map the fields to the columns?

Zaid-Ajaj commented

Hi there, check out https://zaid-ajaj.github.io/Npgsql.FSharp/#/usecases/batch-updates-or-inserts from the docs which explain transactions to insert multiple rows in one go

thomasd3 commented

I had missed that whole section with use cases! thanks a lot!

  • 🎉1