Entity Framework update wizard only showing stored procedures in system
folder
I created a stored procedure in sql server called dbo.GetDrugSetHistory
I tested the SP, works fine.
I went into my .edmx file and right clicked, then clicked "update Model
from Database..."
I am unable to click the checkbox that says "Stored Procedures and
Functions", the checkbox at the bottom that says "Import selected stored
procedures and functions into the entity model" is greyed out and not
selectable.
I then click on the "Refresh" tab, and then click to expand "Stored
Procedures and Functions", below this I see one schema "dbo", when I click
to expand "dbo", I only get the dbo procedures listed in the "System
Stored Procedures" folder (i.e. fn_diagramobjects, sp_alterdiagram, etc.)
Does anyone know why I cannot see my newly created stored procedure? Is
this a permissions issue?
No comments:
Post a Comment