The daab is responsible for opening/closing the connection. Except for the excecuteReader that must be explicitly closed. Just like what is shown in your code. You can add your finally block if you have other process which you want to add after the execution.