Database Locks

[StephenMcAllister]

Hi, I am writing an SQL Server database application and I have noticed that under Management there are some database locks from my application. I don't think this is a good thing and want to make sure I am releasing the connection properly. How can I do this? At the moment I am doing this. connection.Close(); connection.Dispose(); connection = null; Is this enough? Thanks Stephen

[Uri Lavi]

It's enough to use Connection.Close() method. About the locks, what kind of queries do you use?

[StephenMcAllister]

Hi, The queries are all SELECT, INSERT, DELETE and UPDATE queries. Thanks Stephen

[J4amieC]

Do you use any Transactions? If so, you may want to add WITH (NOLOCK) to your select's used within the transaction