Is it required to open and close the data connection for every database operation?

[Mic Mathi]

I was a windows application programmer. I am newbie in web. What i did in windows application is that the database connection will implemented at the time of start up the program. But when i started the work on web application i got an advice to open and close the database connection for every database operation. As an explanation they said it is the safest method. But what is the risk? I searched some time in Google i couldn't find a good answer. Can i store sqlconnection object in application variables? Or is there any other good method? Can i get any useful links for this? Thanks and regards

Ken,Mexico(Guanajuato)

[ganeshkuppuswamy]

you are using asp.net(c# or vb) coding language ,Whatever may be if you are asp.net the you can use webconfig file to declare connection and you can use the single connection where ever you want in your project.

ganeshk

[Mic Mathi]

Yes i am following this method. I wrote the connection string in web.config file. But what is my problem that opening database connection each time makes my site slow. I noticed that some of the functions are slow because it take 1 or 2 seconds to open a connection. Thanks and regards

Ken,Mexico(Guanajuato)

[Brady Kelly]

That doesn't sound right. You should be enjoying connection pooling[^] as automatically provided by ADO.NET.

[Mic Mathi]

Thanks for that link. Actually i was blind on this problem. Now i got a thread. Let me to read that article for creating a systematic database connection. Thanks and regards

Ken,Mexico(Guanajuato)