You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We have encountered the deadlock while using BulkInsert from DapperPlusActionSet. The deadlock is happened due to the concurrent update of the parent table and insert to a child table in few different transactions. The possible way to fix the issue is to use the SQL server hint for the insert query: OPTION (LOOP JOIN). However, I did not find any way to specify the hint while using dapperplus methods.
Is there a way to specify SQL server hints for insert statement located in the merge statement produced by the BulkInsert method?
Thanks.
The text was updated successfully, but these errors were encountered:
I speak with my developer and we are not sure exactly where you will put the option OPTION (LOOP JOIN).
Our library uses the MERGE statement and not an "INSERT SELECT + INNER
Is it possible for you to provide an example of syntax? We want to make sure that's possible and it will currently work with the way we already generate our SQL.
Hello there.
We have encountered the deadlock while using BulkInsert from DapperPlusActionSet. The deadlock is happened due to the concurrent update of the parent table and insert to a child table in few different transactions. The possible way to fix the issue is to use the SQL server hint for the insert query: OPTION (LOOP JOIN). However, I did not find any way to specify the hint while using dapperplus methods.
Is there a way to specify SQL server hints for insert statement located in the merge statement produced by the BulkInsert method?
Thanks.
The text was updated successfully, but these errors were encountered: