I think until someone comes out with something like VFE for .Net your best choice is to choose a framework and then use a template based code generator tool to create your entity/business objects and SP's.
Some good code genertors are
http://www.ericjsmith.net/codesmith/http://www.mygenerationsoftware.comhttp://www.olymars.net/latest.zipThe last above is pretty cool stuff. It was written by a guy at MS France. It is free but not supported.
Also, Kathleen Dollard wrote a book on Code Generation for/with .Net that I am planning on getting.
At this point I am leaning on using a persistence layer for appllications which goes against the current main stream of using SP's for data access. However, the Java camp has been using this technique for quite a while with plenty of success. Unfortunatly MS has dropped there version of this (Object Spaces) from Whidbey... so, I have been investigating third party implementations.
BOb