Browse by Tags

• ASP.Net
• 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 and ADO.Net

  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(), Read More... Posted Thursday, June 03, 2004 10:28 AM by dpenton | 91 Comments Filed under: General Programming, SQL Server, 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#