LINQ SQL DataBase Diagram to <DataBase Name>DataClasses.dbml sync

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

viepia@nospam.com - 19 Feb 2008 22:37 GMT

Hi,

My project writes records to a new SQL Server 2005 database with
currently 18 tables. When I change the Database Diagram for my
database I save the copy the list of changed tables to a notepad text
file; then one at a time I delete the changed tables from my DBML
Diagram and drag a replacement from the Server Explorer Table list. Is
there a better way to keep the Database Diagram and DBML Diagram in
sync? I would rather not need to find out the consequences of
developing with an obsolete DBML Diagram.

Thanks,
Viepia

Reply to this Message

Marc Gravell - 20 Feb 2008 07:58 GMT

For minor "added a column" etc changes, I rather suspect that I will
end up editing the xml directly ("Open With...", "XML Editor") to
avoid losing the assorted table configuration options. But I don't
know if there are more elegant ways...

To be honest, I'm kinda waiting for entity framework to be fully
released before I stress too much about the tooling...

Marc

Reply to this Message

viepia@nospam.com - 20 Feb 2008 10:51 GMT

>For minor "added a column" etc changes, I rather suspect that I will
>end up editing the xml directly ("Open With...", "XML Editor") to
[quoted text clipped - 5 lines]
>
>Marc

As a SQL newby I am using the entity framework to add rows to my tables and to call my
SPROCS, I haven't seen any problems so far. Thanks for telling me about the table
configuration options, I had no idea the Configure Behavior sceen existed.

Viepia

Reply to this Message

LINQ SQL DataBase Diagram to <DataBase Name>DataClasses.dbml sync

Free Magazines