It is a must to use some type of code generator or o/r mapper to help with a lot of the data access code generation, business objects code generation, and user interface code generation. The key is finding a code generator or o/r mapper that works pretty much out of the box for your needs and yet provides enough flexibility when you need to hand make changes when necessary.
I haven't tried TierDeveloper from Alachisoft, but they just came out with a new version that supports .NET 2.0 and Visual Studio 2005 that I might give a spin just to see how it works and what kind of code it produces. TierDeveloper appears to be a code generator for all layers of your application: data access layer, business layer, rich client windows forms, and n-tier ASP.NET applications. That is a heck of a claim.
Per their website:
“TierDeveloper is a perfect code generation tool / code generator that helps you develop real life applications in record time and large complex code generation scenarios. It is an object-to-relational mapping code generator that lets you map, generate, and maintain 50% of your .NET application code, namely your business and data objects. Use these objects in ASP.NET, Windows Forms, console and Windows Services apps.
- Business and Data Objects Framework
- Map objects to relational databases
- Embed SQL, stored procedure calls, and business rules
- Generate .NET components in C# and VB.NET
- Use components in your own high-traffic custom applications
- Powerful ASP.NET & Windows Forms Applications
- Generate fully working database apps for real-life use
- ASP.NET, Windows Forms, and .NET Remoting client
- Customize GUI layout. Use combo-boxes and more“
Might be worth a look if you are tired of writing a lot of the same code over and over and haven't decided on a code generation tool or o/r mapper for your .NET Development.