I have a .dbml file that I have dragged several tables on to from a database in the Server Explorer. I have written a lot of code against the model that was created.
Now I have added another table (Companies) to the database and a Foreign Key in one of my existing tables (People) which references the PK of the new table. I have refreshed the Server Explorer and can see the new table and the new FK in my existing table. I can drag the new table on to the dbml workspace, no problem. But how do I make the new FK appear in the dbml class? I have tried right-clicking on the .dbml file in the Solution Explorer and choosing "Run Custom Tool" but that doesn't do anything. I suppose I could just delete the .dbml file and start all over again, but surely there is a better way! Eventually there will be dozens of tables involved and recreating every time one column changes in one table would be very painful.
Please tell me that I am overlooking something simple.
As a matter of interest, what if I went the other way and added or modifed a class in the dbml, can I get the database schema updated?
thanks in advance
View Complete Post