Ad

Problem Refreshing Tables In The LINQ To SQL Designer

I have been using LINQ to SQL for a while, and there is one thing that has always bothered me. Whenever I modify the schema of a table, in order to refresh it in the designer, I have to delete it and then add it back. That's fine, but this means I have to actually find the table in the designer. I have about 100+ tables in my database, and every time I do this, it's like finding a needle in a haystack. Well, maybe it's not that bad, but seriously, it takes way longer than it should.

Is there another option for refreshing tables that I am unaware of?

Ad

Answer

Some people use SqlMetal to 'refresh/update' their Linq2Sql designer. The designer does not have support for refreshing the schema, when the DB changes. You have to manually drop the table and re-add it back in.

ADO Entity Framework i believe can refresh. I've not used it, but I think I saw this at a TechEd demo this year.

Helpful Info: Google's results for SqlMetal.

Ad
source: stackoverflow.com
Ad