C# using linq to sql-add column to table

Question

In a C# 2008/2010 desktop application it uses linq to sql to point to a sql server 2008 r2 database. I was told by the analysis group that a new column will be added in the middle of one of the tables. The table that is being accessed is used in my *.designer.cs file. With the new column being added to a table I am assuming that I will need to drag the table off of the designer surface and redrag the table back into the *.designer.cs surface to get the new column. Is this correct? (Note; my current code will not access this new code.) If this is not correct can you explain your answer to me? Also is there a different way of how to add a column to a table that is already in the *.desginer.cs file? If so can you tell me how to add the add the extra column in another method?

Jignesh Trivedi · Answer

hi yes you are right. you have delete the existing table and drag the table from Server Explorer on to designer and save and recompile. Also dbml is XML file so you can also update it mannually. To update dbml there are also 3rd party tool is available (Dbmetal). hope this will help you.