.NET Library for programmatically generating SQL objects

Question

I am looking for a .NET library for programmatically generating tables, stored procedures, views and relationships against an SQL 2008 database. Other than raw ADO.NET, what are my options?

Answer 1

It's hard to tell what you're asking so I'll answer as best I can given the information I've got.

Personally I'd go with an object-relational mapping framework such as NHibernate.

This will create an environment for you that makes it easy to work with your database in an abstracted way, affording you more time to focus on the other portions of your application.

To answer your question on creating database tables etc, DataObjects.NET seems to offer something that sounds like it fits with what you want.

Answer 2

It seems, you are looking some king of ORM... Here are some links

WCF RIA Services: http://www.silverlight.net/getstarted/riaservices/

NHibernate: http://community.jboss.org/wiki/NHibernateForNET

Also there are numerous commercial products,offering such functionality.

Answer 3

SQL Server Management Objects (SMO) comes with SQL Server out of the box.