Looking for a C# Code generator

[werrocklo]

Hi guys,
I am a web programmer and I have recently been involved in developing my first ASP.NET application written in C#. I am looking for a code generator to help me to implement the skeleton of the application. I tried to search on the Internet and found a few, but none of them generate the stored procedures, the data access layer and the business layer. Can someone suggest me a good and bug-free code generator so I can focus on implementing the business rules rather than writing stored procedures and developing logic to load and save the data?
Thanks in advance!

[rossable]

pm hoags

my uneducated guess would be that doing such things is what really tailors the project to your specific needs though and to neglect this step would kill your optimization.
but i'm just paid to make things look like they work... functionality is beyond me at the moment.

[mjhoagland]

Ok. The thing with code generators is that all of them have bugs and flaws. No program can surpass the judgement and expertise of a knowledgable programmer. Hence, why progammers make programs and not the other way around.

The neatest skeleton framework that does what you're describing is Ruby on Rails and that's not ASP.Net. So, the best thing I can recommend for you is to take your time and develop your own basic data access layer that is flexible enough to work with any data structure and yet rigid enough to include error checking, recovery, etc.

Not the answer you're looking for, I know but it's the best way to address your problem. This is a very common situation for programmers and this is the "best practices" solution for it.

As far as a prebuilt business layer, that is what describes your business rules. If there's code in the business layer that doesn't describe those rules then it shouldn't be in your business layer, no exceptions. That is the single most layer that changes the most from application to application whether it be a desktop app, web app, server/client app, etc.

A good data access layer should not change much from application to application. There are really only three requirements you need to focus on when making this layer. Requirement 1) get data, 2) put data and 3) an exception recovery model in case 1 or 2 fails. This should be the most light-weight and efficient layer of the application as it's accessed the most since in the vast majority of applications it is accessed by everything.

The business layer should be all the heavy duty logic, your 800lb gorilla. The data layer is the heart and the business layer is the brain. And as a brain, it carries everything from differentiating bool from string, etc.

So, in summary, avoid generators and, instead, develop your own data framework that you can carry from project to project. Not saying it's a straight copy/paste from each application but the changes will be minimal if you do it correctly.

[mjhoagland]

Spammer!!!

[picky-very-picky]

delete the post they should know better

[mstools]

I recommend Advantage Builder
http://AdvantageBuilder.googlepages.com

It's free, powerfull and simple to use. Point and click architecture throughout. You can build out of the box stored procs classes and web forms.

You can also script your templates using JScript.

[net.developer]

This one was great.

URL: pureobjects.com

It generates c# and vb.net objects as well as create sql table and stored procs all in one shot.