Add Function Import not available for function

Question

I've added a function in my database and I wanted it to be callable in my code. For stored procedures I've right clicked on the SP and selected Add Function Import in Model Browser to achieve this, but this option is not available for my function. What can I do to import the function?

Did you update your model from the database after adding the stored procedure? — Pawel, Jun 25 '12 at 17:42

score 6 · Accepted Answer · answered Jun 26 '12 at 08:32

6

Database functions are not available for Function import. Function import works only with stored procedures. You must manually create stub function and mark it with EdmFunction attribute for database function available in your model.

answered Jun 26 '12 at 08:32

Ladislav Mrnka

360,892
59
660
670

1

Table-valued functions seem to import just fine for me. – devinbost Sep 10 '14 at 05:19
@bostIT: Yes, they were added in later EF version. – Ladislav Mrnka Sep 10 '14 at 10:02
1

Scaler funtions does not get imported as of now May 2018 – Chaitanya Gadkari May 03 '18 at 08:20

Add Function Import not available for function

1 Answers1

Linked