.net - Convert C# classes (class library) to SQL DDL (tables) -


I want to convert a set of C # classes (class library) into SQL table by SQL Server, so that the data stored in the database Can be done and manipulated through the database.

The problem is that the number of these classes is large (over 1000 square), and manually enough time to setup such database schema (tables, indexes, stored procedures, etc.) manually I do not need to maintain to mention the class hierarchy.

So, the question is:

Is there a tool that will help me in creating a database schema, a C # Class Library?

I am not looking for the right tool (but I would be very happy if this is the device), but for a device that will help me make at least one starting point. Please note that I would prefer to refer you to the recommended solution to the version 2.0 of the NAT Framework, and create traditional practices (T-SQL code like: tables ... ), although every suggestion is welcomed.

If you can use the Visual Studio 2010 v4.0 framework for something new to generation The capabilities are using the script "Model first" and the organization framework. This is clearly not useful for v2.0, but I thought this is an important thing.

The "Model First" feature lets you design a conceptual (CSDL) model in the unit designer, and then between the storage (SSDL) model, as well as the mapping (MSL) between them In addition, we also generate T-SQL scripts for you to create a database. To run model first wizard, just right-click on the surface of the antiquity designer, and select "Generate database from model ..." Also, check out a deeper blog post.


Comments

Popular posts from this blog

Eclipse CDT variable colors in editor -

AJAX doesn't send POST query -

wpf - Custom Message Box Advice -