Linq to entity framework: what happens if i modified DB schema in SSMS ? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>DotNet - 窗口里的风景

Linq to entity framework: what happens if i modified DB schema in SSMS ?

Linq to entity framework: what happens if i modified DB schema in SSMS ?# DotNet - 窗口里的风景

w*s2013-07-13 07:07

1 楼

1. say my c# code uses Linq to entity framework.
2. Now in SQL Server Management Studio, i added another column to a table
how's my c# project pick up this change pls ?
i didn't see a "refresh data source" ...

x*n2013-07-13 07:07

2 楼

If you use EF tool to generate the mapping, just right click the design
window and choose update from the context menu. If you use poco and code
first, do mapping by your self.

w*s2013-07-13 07:07

3 楼

大牛，
0. in SQL management studio 2012, added 1 more column for a table.
1. In VS C# 2012 project, in Model Browser, right click and do "update ...",
i got this, see attachment.
2. Then i go back to SQL management studio, i can attach file database.
3. Then i detach it from SQL, reboot.
4. Try again in VS C# 2012， same error.
Any thoughts ?

【在 x**n 的大作中提到】

: If you use EF tool to generate the mapping, just right click the design
: window and choose update from the context menu. If you use poco and code
: first, do mapping by your self.

c*e2013-07-13 07:07

4 楼

有時候，我用最原始的办法。把原来的那个什么edmx文件删除掉，重新生成一個edmx文
件，就好了。

",

【在 w*s 的大作中提到】

: 大牛，
: 0. in SQL management studio 2012, added 1 more column for a table.
: 1. In VS C# 2012 project, in Model Browser, right click and do "update ...",
: i got this, see attachment.
: 2. Then i go back to SQL management studio, i can attach file database.
: 3. Then i detach it from SQL, reboot.
: 4. Try again in VS C# 2012， same error.
: Any thoughts ?

H*g2013-07-13 07:07

5 楼

right click and select Update... In the pop up window, select the middle one
, called Refresh something...
老兄，你用啥操作系统啊。。。为嘛你这个VS 2012整天出现奇怪的问题。。。

",

【在 w*s 的大作中提到】

w*s2013-07-13 07:07

6 楼

yes, i clicked the "Update model from database", but didn't see the "refresh
..."
i'm using 64-bit win 7, all standard stuff ...

one

【在 H*******g 的大作中提到】

: right click and select Update... In the pop up window, select the middle one
: , called Refresh something...
: 老兄，你用啥操作系统啊。。。为嘛你这个VS 2012整天出现奇怪的问题。。。
:
: ",

H*g2013-07-13 07:07

7 楼

EXPRESS的VISUAL STUDIO？

refresh

【在 w*s 的大作中提到】

: yes, i clicked the "Update model from database", but didn't see the "refresh
: ..."
: i'm using 64-bit win 7, all standard stuff ...
:
: one

w*s2013-07-13 07:07

8 楼

ultimate from your post
http://www.mitbbs.com/article_t/DotNet/31108179.html

【在 H*******g 的大作中提到】

: EXPRESS的VISUAL STUDIO？
:
: refresh

w*s2013-07-13 07:07

9 楼

ok, i thought i detached the database from mssms, but i didn't.
after i detach it, not it's updated.
don't understand why VS cannot spit out an error message ...
thanks brother.

one

【在 H*******g 的大作中提到】