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 ...

I spoke at the Plano DNUG last night and had a pretty good time.  Basically I presented some information on interfaces, talked about the interfaces in System.Data, discussed what happens behind the scenes with SqlConnection.Close() and SqlConnection.Dispose(), presented issues with creating a data layer, then some discussion on the ...

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 ...