Can we create multiple sql connection object from multiple thread

[Sudip_inn]

On button click i want to load multiple instance of same user controls onto form with proper positioning. user control will have background worker and when user control load then background worker start. from background worker DoWork event i am going to open a sql server connection and perform Insert data operation to few db tables. each user control will insert different in few specific tables.

the way i am thing to do the job would be right? does it create any problem for insert data in sql server ?

how many sql server connection i can create from my c# application.

please advise how to do this job proper and performant way. thanks

Continue reading...