Using CodeDOM
I have been messing around with the CodeDOM namespaces. I have written a tool that will take your SQL Server database and produce all the stored procedures, “Model” classes and an initial business layer that accesses all the tables via the stored procs. I will post all the code when I get to a more stable release. The codename of the project right now is “Skeletor”. It will be able to produce skeleton code for various situations where you do not want to write all that code for your data access. There are tools out there that do this, but they are expensive. I would like to make something flexible and tailored for the .NET Community. Make it open source and see how it works out.
I would appreciate any thoughts any of you might have about this...