Why isn't Entity Framework recognizing my procedure?

I am trying a function import, and EF doesn't recognize my procedure.

That's it:

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.

Answers


What about permissions?


Need Your Help

mp4 video cannot be played in Android VideoView and Mediaplayer

android media-player android-videoview rtsp

I have indeed tried to check here and else were for solution to this but no luck, probably because am a newbee.