Dumawich Sample >>> Auto Mainframe Generator

Hi,

Many of my sites are based on the Dumawish Sample included in VS.NET.

I think its a powerfull, stable and easy to use component.
The only problem with it, is that you need a lot of typing :(

For those who dont know the project ...

The "Mainframe" used for the site has different components using different layers.

1. Common.Data <<< Database Model Component
2. DataAccess <<< Database Provider (SQL)
3. Business.Rules <<< Kind of Validator (not yet used in my project)
4. Business.Facade <<< All frontend and backoffice applications and sites can connect directly to this public component.

===

To make this lots easier i made a small tool that creates all there components for you.

By entering a simple Database Layout, the program will create:
1. SQL Deployment Script (Create Database / Tables, Create Stored Procs / Views)
2. DataModel
3. DataAccess
4. BusinessFacade

For the last 3 components, the full .vb file is writen by the tool.
With this tool, few days / months of work can be saved.

===

What i wanna do next:

I wanna work out the full mainframe, also let some WebControls automaticly builded so you only need to drag and drop them into your webpage.

I want to adjust the mainframe, so it can use remoting.
This i wanna do, cause then the mainframe can be installed on a separated server. (later i wanna use only 1 mainframe for different sites, using different tpc channels in remoting.

I need a good GUI for the application, so the users can enter the database layout very easy.

Finally the tool must not only create the .vb files, but also the project files, sollution files, auto deploy the site / database ,
......

Any other ideas to add into this is welcome.
Maybe i will make the project full opensourced, and put it on my site as like the ASP.NET Starters Kits.

With this project you should be able to create a full database driven site in a few minutes.

===

How doest the project structure looks like

- Namespace (Namespace Used for Project / Also Databasename)
- Classes (Group of Tables)
- Tables
- Fields

===

The project has been started, cause i was working for a few weeks now on a new site using this kind of mainframe.

I dint wanna write it all over again, so i started this project yesterday evening.
This evening i gone test the script files.
The SQL Deployment file has allready been tested and is only compactible with SQL 2000 or above.

For identities the database is using BigInt datatypes what is not known by SQL 7

:) Greets Nightmare :)