I had mentioned to the Plano DNUG when I presented a while back that I didn't like the idea of passing back a DataReader at all from a DAL.  You lose control of what happens to it when you do (as in the DAL no longer has the responsibility of closing the reader and ensuring its disposal).  Well, Teemu Kieski had a great idea for how to ...

Aaron blogged about interfaces and asked about people usage.  I have been using them more and more in code.  Here are some examples of closing and disposing of System.Data (and Microsoft.Data) resources using interfaces: static void DisposeIDbDataAdapter(ref IDbDataAdapter da) { if(da != null) { if(da is IDisposable) ...

Something I was reading on a list I am on made me think of security.  Periodically I do searches on Google to see how secure some sites are designed.  I won't put my actual search here, but if you search for specific parts of connection strings you may occasionally find more information than you bargained for (such as user names and ...