There is an error in using multithreading to write to the database. How to solve it?

Question

SqlCommand cmd = new SqlCommand(str, con);
cmd.ExecuteNonQuery();

I use multiple threads for insert operation, but an error will occur at some time. Is it because all threads share a SqlConnection? How to solve it?

Answer 1

Do not share connections among multiple threads.

Create a SqlConnection object for each of your queries, and wrap it with a using statement to close it in time after the execution ends.

.NET, the SqlConnection object, and multi-threading

Using the same open SQL connection from different threads

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.