I had mentioned to the North Dallas 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 ...

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

So, I have started blogging.  I had been thinking about how and what I would start this off.  It occured to me that I should talk about something that I had learned throughout my life but never knew the name of until college.  Even after that, I wasn't sure ow to describe the methods I take when designing systems.  ...