C# Multiple thread connect to one SQL Server database, dbconnection.open hang

  • Thread starter Thread starter Hi, Shirley
  • Start date Start date
H

Hi, Shirley

Guest
my code process is as below:
1. create database connection
2. create database dbCommand
3. call ExecuteReader and get reader (parse database data)
4. dbCommand cancel
5. reader close
6. database connection close


my connection string is as below:
string SQLConnection = "Server=192.168.0.111;Database=MySqlDB;Intefrated Security=SSPI;Connect Timeout=5";
SqlConnection sqlConnection = new SqlConnection(SQLConnection);


The above processing will be done in parallel in multiple threads, one time hang in the db.open()
So why?


Continue reading...
 
Back
Top