views:

25

answers:

1

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.

+1  A: 

What about permissions?

gbn
Man, you're genious \o/
Victor Rodrigues
Sir, you are most kind ;-)
gbn