I'm working on the big project who has edmx file with lots of table. I want to update a table from DB. But when I update the edmx file, it also refresh the other tables from DB. How do I update single table?
AFAIK, the designer doesn't support selective refreshing. The command line tool (EdmGen.exe
http://msdn.microsoft.com/en-us/library/bb387165.aspx) doesn't appear to have support for selective refreshing either. In the past, when I've wanted to accomplish this, I've had to use my
favorite text editor.
~ Remember To Mark The Post(s) That Helped You As The ANSWER ~
sp_412000@ya...
Member
661 Points
347 Posts
update a single table in edmx file
Sep 23, 2010 02:20 PM|LINK
I'm working on the big project who has edmx file with lots of table. I want to update a table from DB. But when I update the edmx file, it also refresh the other tables from DB. How do I update single table?
robv8r
Participant
889 Points
138 Posts
Re: update a single table in edmx file
Sep 23, 2010 02:49 PM|LINK
AFAIK, the designer doesn't support selective refreshing. The command line tool (EdmGen.exe http://msdn.microsoft.com/en-us/library/bb387165.aspx) doesn't appear to have support for selective refreshing either. In the past, when I've wanted to accomplish this, I've had to use my favorite text editor.
sp_412000@ya...
Member
661 Points
347 Posts
Re: update a single table in edmx file
Sep 23, 2010 02:57 PM|LINK
could you please elaborate more on this? i didn't get the use of text editor.
robv8r
Participant
889 Points
138 Posts
Re: update a single table in edmx file
Sep 23, 2010 03:08 PM|LINK
Open the edmx file in a text editor and modify the XML by hand.
sp_412000@ya...
Member
661 Points
347 Posts
Re: update a single table in edmx file
Sep 28, 2010 08:29 PM|LINK
That works. thanks