#Start Here.

You want a simply structured database

By simply structured I mean;

• Auto-number integer primary keys
• References, with indexed foreign key constraints
• Trigger based Referential Integrity
• Indexes

By removing some of the complex things that you can do with a database this method can get your project up and running very quickly.

The generated database can be used with Linq to SQL and Linq to Entity models or a traditional ado.net approach.

You can create an assembly simply for the creation and maintenance of the database, and not have it referenced in your application. You could have logical functionality in separate assemblies which you could mix and match to create a quick database for a new project.

Point the Builder at your test database during development to allow for quick changes and testing during development, then when your ready you can point it at a live db to generate a change script for your roll out.

Available Attributes

• DataTableAttribute - Generate Table Create/Alter SQL
• DataIndexAttribute - Generate Index Create/Alter SQL
• DataColumnAttribute - Generate Column Create/Alter SQL