Is there a way, given a database or some other source specification for an application, for an entire WPF or Silverlight / XAML application to be generated that emits best practices?

For example, assuming I have a well-normalized database (or some other kind of base specification for an app), is there a tool that can create a well-formed MVVM application. This would include...

• XAML (Views) for all of the tables (list and edit) with no code-behind
• ViewModels that emits properties extracted from the db schema along with commands or behaviors for all of your standard CRUD operations
• Models built with the repository pattern (or some other db abstraction) with interfaces that emit the table design and relationships and a default implementation of your choice (sql, sql ce...whatever).

An ideal tool like this would only do a "first pass" of the application after which the developer would make all necessary changes and modifications.

I don't think there is any such tool but it seems like a tool like this should be possible.

Another related question, in the absence of such a tool (or even if there is one), what tool(s) are best used to get me from a database design (or some other kind of base specification for an app) to working app.

What STEP-BY-STEP process do you take to get from design to basic working application in a couple of hours?

I am just trying to figure all of these practices and patterns and I am getting a pretty good grasp of the pieces but not sure what workflow to use to make it all work together quickly but still allows unit testing of separate concerns.

Thanks in advance.

Seth

Hello,

Is there a way, given a database or some other source specification for an application, for an entire WPF or Silverlight / XAML application to be generated that emits best practices?

For example, assuming I have a well-normalized database (or some other kind of base specification for an app), is there a tool that can create a well-formed MVVM application. This would include...

• XAML (Views) for all of the tables (list and edit) with no code-behind
• ViewModels that emits properties extracted from the db schema along with commands or behaviors for all of your standard CRUD operations
• Models built with the repository pattern (or some other db abstraction) with interfaces that emit the table design and relationships and a default implementation of your choice (sql, sql ce...whatever).

An ideal tool like this would only do a "first pass" of the application after which the developer would make all necessary changes and modifications.

I don't think there is any such tool but it seems like a tool like this should be possible.

Another related question, in the absence of such a tool (or even if there is one), what tool(s) are best used to get me from a database design (or some other kind of base specification for an app) to working app.

What STEP-BY-STEP process do you take to get from design to basic working application in a couple of hours?

I am just trying to figure all of these practices and patterns and I am getting a pretty good grasp of the pieces but not sure what workflow to use to make it all work together quickly but still allows unit testing of separate concerns.

Thanks in advance.

Seth

Found this here…

http://www.sqlservercurry.com/2008/06/rebuild-all-indexes-of-all-tables-in.html

USE escore
GO
EXEC sp_MSforeachtable @command1=”print ‘?’ DBCC DBREINDEX (‘?’, ‘ ‘, 80)”
GO

Pretty cool.

Seth