SQL Server实体表和storedproc自动化工具？(SQL Server entity tables and storedproc automation tools?)

SQL Server实体表和storedproc自动化工具？(SQL Server entity tables and storedproc automation tools?)

是否有任何自动化工具可以轻松创建表并添加标准插入/选择/更新存储过程，而不是为大量表创建手工创建？

如果我在SQL Server 2008中创建了100个表（以及后来的ALTER）及其关联的存储过程，那么最方便的方法是什么？

添加：

是否有工具可以自动生成与相应表绑定的漂亮类骨架（带有数据字段）？

我在Visual Studio 2010和Microsoft SQL Server 2008中使用C＃.NET 4.0。

我们从头开始一个新项目，因此从纸上设计到初始代码获取快速引导工具会很有帮助。

任何其他相关的建议表示赞赏！

Are there any automation tools to ease creation of tables and adding standard insert/select/update stored procs, rather than doing hand creation for a large number of tables ?

If i have 100 tables to create (and later ALTER) and their associated stored procs in SQL Server 2008, what is the most convenient way to do it ?

ADDED:

Are there tools to auto-generate nice class skeletons (with data fields) tied-up with corresponding tables ?

I am using C# .NET 4.0 in Visual studio 2010 and Microsoft SQL Server 2008.

We are starting off a new project from scratch, so it would be helpful to get tools for quick bootstrap from Design on paper to initial code.

Any other related suggestions are appreciated!

最满意答案

使用SSMS数据库图表设计100个表，因为只需键入列名称，并且可以指向并单击数据类型，主键，可空性，外键等。为每个功能分组创建一个图表。 设计完成后，您可以编写一个脚本，该脚本将为存储的proc编写SQL，以对表执行插入/更新。

当您创建脚本来编写脚本时，您可以在此处发布您的工作。

Use SSMS Database Diagrams to design you 100 tables because one only has to type the column name and can point and click for data type, primary key, nullability, foreign key, etc. Create a diagram for each functional grouping. When the design is done you can write a script which will write the SQL for the stored proc to do the insert/update for the tables.

As you create the script to write the script you could post your work here.