Loading

Multitasking in C Sharp

Aniket Narvankar

How to use parallel.foreach to update multiple records in databse? I am using parallel.foreach but it is giving dataabse connection errors. How this can be resolved?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
You can open connection string before loop so that you can prevent multiple sql connection as shown:
using ( var con = new SqlConnection(conStr))
{
con.Open();
//....
Parallel.ForEach(numbers, number =>
            {
             //do operations use con - sql connection
            });

//..
}
0
Sachin Singh5y ago
1. Parallel.ForEach(list, s=>
3. {
4. using (var con= new SqlConnection(cs))
5. {
6. con.Open();
7. // write your query
8. }
9. }
10. }
+2