An enthusiastic "second" for mygeneration, as well as dOOdads, Mike Griffin's amazing object-relational mapping framework. I use both extensively with SQL Server and  VS.NET 2005.