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

URL for jQuery Page State

jquery url

I am taking over a "one-page" site that uses numerous jQuery show/hide instructions to navigate content—turning divs on and off to reveal images and simulate new windows opening and closing on the ...

recv function fails when used twice

c++ sockets winapi network-programming

Hello all I have been working on a Server that receives the two address from a simple client and then prints them out using Asynchronous Sockets and the WINAPI, So far I have set up the window and ...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.