How can I add stored function to Entity Framework [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 10 years ago.

Improve this question

I'm trying to add a sql (stored) function to Entity Framework, but unsuccessfully. I tried with right clicking on a table in .edmx and "Function Import", but the function is not shown there, although I added it (updated model from the database).

Does anyone have solution for this?

Helio's suggestion to convert to stored procedures is probably the best solution in many situations. Another approach is to hand-code a CreateQuery call as suggested by Evil Pigeon on this SO post. — Tim
– Tim, Commented Sep 18, 2014 at 22:35

Helio · Accepted Answer · 2011-04-05 11:00:59Z

3

You should be able to simply convert a stored function into a stored procedure in SQL. Although Entity Framework defines stored procedures as functions or lists stored functions under Stored Procedures, stored functions are not compatible with Entity Framework. You can "Update Model from Database..." and add Stored Procedures then right click and add "Function Import..."

answered Apr 5, 2011 at 11:00

Helio

6111 gold badge4 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I add stored function to Entity Framework [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related