问题描述
我使用LINQ to SQL已有一段时间了，有一件事一直困扰着我.每当我修改表的架构时，为了在设计器中刷新它，我都必须先删除它，然后再将其重新添加.很好，但这意味着我必须实际上在设计器中找到表格.我的数据库中大约有100多个表，每次执行此操作时，就像在大海捞针中找针.好吧，也许还不算那么糟糕，但是很严重的是，它花费的时间比应该花的时间长.
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?
推荐答案
有人使用 SqlMetal 的解释，以刷新/更新"其Linq2Sql设计器.当数据库更改时，设计器不支持刷新架构.您必须手动删除表格，然后将其重新添加回去.
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实体框架.我没有使用过，但是我想我在今年的TechEd演示中看到了这一点.
ADO Entity Framework i believe can refresh. I've not used it, but I think I saw this at a TechEd demo this year.
有用的信息: Google的搜索结果 SqlMetal.
Helpful Info: Google's results for SqlMetal.
这篇关于在LINQ to SQL设计器中刷新表时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！