Jason Salas has a nice post about how you can use the "using" keyword in C# when doing data access, and ensure that your objects are cleaned up properly.

The template for DALs in CodeSmith that we are using had this built right in. I had to do some research when we started seeing some memory problems to verify that the code was correct. Had this been up sooner, that research would have been a lot easier!