Import Column-Comments/Description from SQL-Server to Entity model

Question

4.00/5 (1 vote)

See more:

I was wondering if there is an easy way to import the column-description (or comments) from an SQL-Server 2008 database schema to an EntityModel(ideally xml-comments on the generated properties)in EF 4?

[edit]
I re-formulated the question in my comment:

I create an EntityFramework 4 EntityModel (edmx-file) from my SQL-Server 2008 database with VisualStudion 2010, EntityFramework generates an class structure representing my database - but it doesn't take the comments from the database, but generates empty summary blocks on the code (C# in my case).

So my question is: how to get the comments during/after creating/updating the model out of the database?

Posted 20-Mar-12 10:00am

johannesnestler

Updated 20-Mar-12 11:56am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

foxyland · Answer 1 · 2012-03-20T11:34:00

Solution 1

I have used Microsoft Visio to reverse engineer databases in ER since 2005 (I am still on Microsoft Visio 2003). I use it to create software documentation. The result is a nice ER Diagram. You can get the schema properties as well on the diagram.

[edited]: Oh, and yes, it is very easy. You simply specify ODBC connection properties and password, and wait for Visio to do its job --- which took about a minute. And you got your ERD on screen :)

hth,
foxyland

Posted 20-Mar-12 11:34am

foxyland

Updated 20-Mar-12 11:36am

v2

Comments

johannesnestler 20-Mar-12 17:54pm

Thank you for your solution. But I don't know if this helps me much... Most important reason - I have no Viso... forgive me I didn't understand what you was trying to tell me... Maybe I should try to formulate my question a little clearer. If I create an EntityFramework 4 EntityModel (edmx-file) from my SQL-Server 2008 database with VisualStudion 2010. EF then generates an class structure representing my database - but it doesn't take the comments from the database, but generates empty summary blocks on the code (C# in my case). So my question is: how to get the comments during/after creating/updating the model out of the database?