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

[viepia]

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

 

[Marc Gravell]

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

 

[viepia]

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

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