Ok, so I'm not using Sql Client.
I have an .edmx file in my project and in it are the tables, the views and the stored procedures. I know how to call them from my project. But I have some functions in the Server Explorer. How to call them via code?
5
-
You want to call a stored procedure using EF? Which version of EF are you using?Darin Dimitrov– Darin Dimitrov2012-06-13 11:29:43 +00:00Commented Jun 13, 2012 at 11:29
-
@DarinDimitrov No. I want to call a function.petko_stankoski– petko_stankoski2012-06-13 11:30:06 +00:00Commented Jun 13, 2012 at 11:30
-
A function? Never heard of such notion in a SQL database.Darin Dimitrov– Darin Dimitrov2012-06-13 11:30:35 +00:00Commented Jun 13, 2012 at 11:30
-
@DarinDimitrov Can you see this? msdn.microsoft.com/en-us/library/dd456857.aspxpetko_stankoski– petko_stankoski2012-06-13 11:31:22 +00:00Commented Jun 13, 2012 at 11:31
-
@DarinDimitrov And here: google.com/…petko_stankoski– petko_stankoski2012-06-13 11:32:49 +00:00Commented Jun 13, 2012 at 11:32
Add a comment
|
2 Answers
You just need to add those function to EDMX in Wizard (update model from database) and after that you have to manually create static function accepting parameters with same names and marked with EdmFunction attribute (examples in this question). Now you have mapped function which can be used inside Linq-to-entities queries. EF provider will correctly translate your CLR call to SQL function call in SQL query.
EF 4.0 doesn't support table valued functions (this support is added in EF 4.5 / .NET 4.5). Also this mapping works only with EDMX - not with code first.
2 Comments
petko_stankoski
But I can only add views, tables and stored procedures to my .edmx file.
Ladislav Mrnka
Functions which can be imported will be under stored procedures.
What I did was writing a stored procedure with the same code as the stored procedure and import it in the .edmx file.