I've been tasked to scour the internet and search out tools that will allow us to automate a bunch of mundane coding tasks in our app.

What we DON'T want is an additional layer that sits between us and the data... we've already got that covered. What we DO need is something we can point to a database table(s) and say, GO, and get the usual CRUD SProcs. At the same time, generate the DAL (Data Access Layer), and the BOL(Business Object Layer). Or just the DAL... or Just the BOL.

I've already looked a dozen different products, and most of them either add another layer to the app (which we don't want) or create a dependency by being another project type that has to be added (again, something we don't want).

Basically, what we are looking for is a straight-up code generator that's got a decent templating model that we can use to automate a bunch of boring, repetitious, mundane coding.

If it integrates into VS2005/VS2008, all the better, but I'll take a stand-alone app as well.

So.... any recommendations, suggestions, ideas, comments?

Two I'm currently looking at are CodeSmith and MyGeneration.... are there any others I should know about?


-tg