in reply to Database field names in code

1. It doesn't need to get worse because of stored procedures. It may get better. Depending on the nature of the change you may end up having to change just the procedures without having to leak the change to the upper levels. That is if your stored procedures are more than just SELECT All, Columns FROM TableName WHERE ID = @ID.

2. Data Abstraction layer is one of the best places to use code generation. The functions/methods look very similar so there is no need to maintain them by hand.

Jenda
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live.
   -- Rick Osborne

Edit by castaway: Closed small tag in signature