Cannot use parameter name more than once in a script about fsharp.data.sqlclient HOT 3 OPEN

I used to use this provider all the time, but it has been years. It cannot be upgraded to dotnet without a lot of work.
IIRC there is a workaround, which is to define a new @variable for each time it is used. You can do it within your script. Declare and set the second variable to the original variable submitted to the script.

from fsharp.data.sqlclient.

@xperiandri this is described in question 4 in the faq: https://fsprojects.github.io/FSharp.Data.SqlClient/faq.html and due to how sys.sp_describe_undeclared_parameters works.

from fsharp.data.sqlclient.

I think it also works if you declare the type in TableVarMapping
TableVarMapping = "@assetId=Int"

from fsharp.data.sqlclient.