Stored procedures get unmapped on data model changes in Entity Framework 4

Question

I'm using VS2010, .NET 4.0, and Entity Framework 4 on a new project. I've been building out the data model iteratively and just started adding some stored procedures. Every time I "Update Model From Database," the stored procedure mappings disappear from my project and it breaks at runtime. I assume I'm missing something fairly simple. Has anyone seen this happen? Do I have something checked or unchecked that's torching my proc mappings with each update?

Thanks!

Are your stored procedures using temporary tables? If so, see here: http://stackoverflow.com/questions/7128747/ef4-the-selected-stored-procedure-returns-no-columns — brian, Nov 22 '11 at 22:09
unfortunately, no. They're actually just doing SELECTS, but the logic was complicated enough that i wanted to capture it in the database itself and not in the Entity Framework code — dudemonkey, Nov 22 '11 at 23:35

score 0 · Answer 1 · edited May 23 '17 at 12:03

0

Are your project have setup the permission to see the stored procedures and function import mapping.

There is existing thread which might help you vs-2010-edmx-stored-procedure-missing

edited May 23 '17 at 12:03

Community

1
1

answered Dec 01 '11 at 14:57

Turbot

5,095
1
22
30

score 0 · Answer 2 · answered Jan 18 '12 at 11:10

0

Remove the procedure from your Data Model and again add it from DataBase.

answered Jan 18 '12 at 11:10

Kishor

201
2
12

Stored procedures get unmapped on data model changes in Entity Framework 4

2 Answers2