I just added a stored proc. in my database. I want to add this proc to my edm, in solution explorer I opened my edm and in the model browser I did "Update Model from database". Could not find my proc.. How add my proc to edm?
Ok... the reason I couldn't see the proc was very simple.. The proc did not have the correct permissions for the userid that I am using in the edm connection. Oooops...
nissan
Participant
1065 Points
618 Posts
How can I add my proc to the edm
Apr 24, 2012 09:06 PM|LINK
I just added a stored proc. in my database. I want to add this proc to my edm, in solution explorer I opened my edm and in the model browser I did "Update Model from database". Could not find my proc.. How add my proc to edm?
Gaspard
Contributor
2066 Points
416 Posts
Re: How can I add my proc to the edm
Apr 24, 2012 10:36 PM|LINK
Maybe this tutorial can help
http://msdn.microsoft.com/en-us/library/bb896231.aspx
Regards
nissan
Participant
1065 Points
618 Posts
Re: How can I add my proc to the edm
Apr 25, 2012 01:51 PM|LINK
Ok... the reason I couldn't see the proc was very simple.. The proc did not have the correct permissions for the userid that I am using in the edm connection. Oooops...