No, there are no drawbacks unless getting done on time and under budget is a problem for you
My name is Mike Griffin, creator of download.coms #1 .NET Development tool,MyGenerationan OR Mapper Code Generator and a very sweet architecture called EntitySpaces. You definitely shoud be using code generation and a proven architecture, don't waste time on mind numbing gruntwork (and all the mistakes that go with it). See MyGeneration - 100% Free @http://www.mygenerationsoftware.com
And here's a snippet about EntitySpaces, a very nice architecture for .NET 2.0 that costs less than an average consultant charges for a single hours work. Best of luck to you, if you want you can write to me atmike.griffin@entityspaces.net
EntitySpaces
Persistence Layer and Business Objects for Microsoft .NET 2.0
The EntitySpaces architecture for .NET is a new persistence layer and business object system for the Microsoft .NET 2.0 Framework. The EntitySpaces architecture is also database independent. The EntitySpaces data providers are loosely coupled to your application and allow you to use the same compiled code to access a whole host of databases.
The EntitySpaces architecture for .NET has in its ancestry the popular dOOdads architecture. The EntitySpaces architecture is generated from your database's metadata or schema using the popular code generator and OR Mapping tool, MyGeneration.MyGeneration is 100% free.
Features:
- Hierarchical Data Models
- LINQ Support
- Serialization
- Nullable Types
- Powerful Dynamic Queries
- Powerful Dynamic Queries
- Saving via Stored Procedures or Dynamic SQL
- Two Different Transaction Models
- Design Time Data Binding
- Generated from your Database Schema
- Regenerate Without Losing Custom Business Logic
- Admin Grid Template Suite for ASP.NET
- Admin Grid Template Suite for ASP.NET
- Admin Grid Template Suite for DotNetNuke
- Source Code Available
Providers Available:
- Microsoft SQL Server
- Microsoft Access
- Oracle
- MySQL

