.NET 4.0 Bug with SqlConnection Object

We recently completed some load tests and found a bug with the SqlConnection object in .NET 4.0.  When reviewing the results of our load test we noticed that the handle count climbed up to 85,000 and never went down.  After investigation we found the problem is with the SqlConnection object. We contacted Microsoft about the [...]

SQL Saturday #95

I hope everyone in southern California is planning to attend this years SQL Saturday in San Diego, CA on September 17th. It’s always a great time and lots of free training! I will have a limited number of my latest book to sell "David McCarter's .NET Coding Standards" ($12) and a DVD full of conference [...]

ADO.NET Entity Framework 4.1 – Update 1

ADO.NET Entity Framework 4.1 introduces two new features: The DbContext API is a simplified abstraction over ObjectContext and a number of other types that were included in previous releases of the ADO.NET Entity Framework. The DbContext API surface is optimized for common tasks and coding patterns. Code First is a new development pattern for the [...]

Fullerton Code Camp 2011

I hope everyone in southern California is planning to attend this years SoCal Code Camp in Fullerton, Ca on 1/29 – 1/30. It’s always a great time and lots of free training! I will be presenting the following sessions and I hope you will attend. Building nTier Applications with Entity Framework Services Learn how to [...]

Los Angeles Code Camp 2010

I hope everyone in southern California is planning to attend this years SoCal Code Camp in Los Angeles on 10/23 – 10/24. It’s always a great time and lots of free training! I will be presenting the following sessions and I hope you will attend. Back-2-Basics: Exception & Event Instrumentation in .NET This session will [...]

Checking a DataTable for Data

Whenever you retrieve a DataTable from a data source, there no guarantee that there is actual data in it. Before you start looking for rows, you should always validate that that is it's not null and also there are rows. Here is a easy way to do it using extensions. public static class DataTableExtensions   [...]