Refereshing SQL schema changes in LinQ to SQL O/R designer

[silpa]

Hi,

The Visual Studio Linq for SQL designer is not supporting refreshing tables and column information from the database.
For example,I have created LINQ to SQL classes that are mapped to database tables by dragging tables from Server Explorer onto the O/R Designer.
I dragged a table named emp onto the O/R designer.

Now,if add a new column in emp table in database,and if I refresh O/R designer,
the added column is not effected on the table in O/R designer.
If I remove the table and again if I drag the emp table from Server Explorer onto O/R designer,I can see the added column now.


Without removing table and adding again,
Is there any way to refresh the designer.

Please help me regarding this.

Thanks,
Silpa

[softsoft]

Hi,

The Visual Studio Linq for SQL designer is not supporting refreshing tables and column information from the database.
For example,I have created LINQ to SQL classes that are mapped to database tables by dragging tables from Server Explorer onto the O/R Designer.
I dragged a table named emp onto the O/R designer.

Now,if add a new column in emp table in database,and if I refresh O/R designer,
the added column is not effected on the table in O/R designer.
If I remove the table and again if I drag the emp table from Server Explorer onto O/R designer,I can see the added column now.


Without removing table and adding again,
Is there any way to refresh the designer.

Please help me regarding this.

Thanks,
Silpa

Hello Silpa,

Have you heard about a new database synchronization tool Database Restyle (http://www.perpetuumso ft.com/Product.aspx?la ng=en&pid=55) that supports LINQ To SQL object model and allows automatic synchronzation of LINQ To SQL model with your live database. Hope this helps.

Kind Regards,
Kate