sql server connection close issue

Question

Possible Duplicate:
Why always close Database connection?

I usually use VS2010 and ASP.NET to develop my web projects, also my host providers often give me access to SQL Server 2008, I have a general question regarding connection close, should I always close my SQL connection after I'm done with SQL? what happens if I do NOT close my connection? is it harmful?

thanks

score 2 · Accepted Answer · answered Dec 29 '11 at 07:25

Microsoft strongly recommends that you always close the connection when you are finished using it so that the connection will be returned to the pool. You can do this using either the Close or Dispose methods of the Connection object, connections are released back into the pool when they are closed or disposed.

Read about connection pooling

score 1 · Answer 2 · edited May 23 '17 at 10:34

1

I think you might get your appropriate answer here, thanks for your time.

edited May 23 '17 at 10:34

Community

1
1

answered Dec 29 '11 at 07:27

Elias Hossain

4,410
1
19
33

2

thanks for your constructive replies, it really helped me – Ali_dotNet Dec 29 '11 at 07:38
Well copied and pasted ... very constructive thanks alot – Dec 29 '11 at 08:50

score 1 · Answer 3 · answered Dec 29 '11 at 07:34

1

if we don't close the connection , it wil lead to connection memory leakage.unless until application server/web server is shut down ,connection wil remain activate even though the user logs out .

answered Dec 29 '11 at 07:34

Terry chan

106
7

sql server connection close issue

3 Answers3