the incoming request has too many parameters about repodb HOT 3 CLOSED

That error is not a bug…it’s a limitation of SQL Seever where only 2100 parameters can be sent in a single query…by parameters it’s referring to arguments that begin with @.

RepoDB is automating that for you and using parameters, for every field value for every entity/record, just as it should to avoid SQL injection risks! However it does not do a bounds check so your just passing in too much data into that method….every field on every record is resulting in a variable/param.

You should look into the BulkInsert API (RepoDB provides this also) as a much more reliable way to send large amounts of data in the fastest way possible…InsertAll is for smaller batches of dozens of records…if you have hundreds or thousands then BulkInsert is more appropriate.

from repodb.

thank you @cajuncoding! like I said, I was monkeying with it... I want to point out that the mention was not "parameters" but "batch", I thought it was a record, an entry, not a single field value. Thank you for your good advise! :-)

from repodb.

Thanks @cajuncoding. @sipi41 yes, please the real Bulk Operation if you have such requirement.

from repodb.