在LINQ to SQL设计器中刷新表时出现问题 [英] Problem refreshing tables in the LINQ to SQL designer

问题描述

我使用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?

推荐答案

有人使用

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设计器中刷新表时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！