OK, so its not ground breaking, earth shattering nor will it solve world hunger … but I am pretty stoked over the addition of the Merge method to the DataTable object in ADO.NET 2. It has always been an annoyance of mine that when I want to merge a DataTable into another one that I have to have a Da

Here’s a quick tip in response to some questions I recently have been asked by several readers & bloggers: When using the Command.ExecuteReader method to get a DataReader, pass it the System.Data.CommandBehavior.CloseConnection argument. This argument closes the Connection when the DataReader is

Microsoft's Enterprise Library [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp] (Ent Lib) was developed using the oft spoken of Test Driven Development methodology (TDD). But of course if you are new to TDD or are aware of it but have not used it yet, yo

Just confirmed that I’ll be at VSLive in Boston [http://www.ftponline.com/conferences/vslive/2005/bo/]this June. If you plan on attending VSLive, drop by. I’ll be presenting 2 topics: Get Ready for ADO.NET 2 (5:45 pm to 6:45 pm, Wednesday, June 29, 2005) Data access using ADO.NET is at the core o

I ran into a situation today where I wanted to know why ADO.NET’s DataSet.Merge method worked the way it did. Then it occurred to me that I could use reflection to find out. Using the Reflector [http://www.aisto.com/roeder/dotnet/] software found on Lutz Roeder’s site [http://www.aisto.com/roeder/do