Browse by Tags

• C#
• SQL Server

• A better, more manageable DataReader

  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 Read More... Posted Monday, September 20, 2004 8:57 AM by dpenton | 87 Comments Filed under: General Programming, SQL Server, ASP.Net, C#

• More on Interfaces for System.Data

  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 Read More... Posted Tuesday, March 16, 2004 2:09 PM by dpenton | 326 Comments Filed under: General Programming, SQL Server, ASP.Net, C#

• Security Warning

  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 Read More... Posted Monday, February 23, 2004 8:59 AM by dpenton | 50 Comments Filed under: General Programming, SQL Server, ASP.Net