Why isn't Entity Framework recognizing my procedure?
I am trying a function import, and EF doesn't recognize my procedure.
ALTER PROCEDURE dbo.AddNewTicketFieldOption ( @ticketFieldID INT, @optionID INT ) AS BEGIN INSERT INTO tbTicketFieldOptions (cdTicketField, cdOption) VALUES (@ticketFieldID, @optionID) --only to return something, EF hack SELECT 0 END
Actually this procedure doesn't need a return. But I know EF requires it, so I've tried this scalar return (using RETURN 0 also), and selecting top 1 from an entity, using the select of an already recognized procedure.
When I try to update the model, it doesn't show up with this new procedure.
Is it something with the naming? I'm lost with it.
What about permissions?