Last post Jun 01, 2015 09:32 PM by Li Wang
May 29, 2015 10:13 AM|ManyTitles|LINK
Hi All, I'm trying to get data from a stored proc which returns data from several columns from joined tables and I'm using Entity Framework 5.
I notice that when I go into the Add Function Import popup I can select Entities after selecting my stored proc which will allow me to select only a single table.
The problem is I'm trying to get results from a join which means I need to select more than one table.
I have scoured the web but I can't find a tutorial that shows how to do this. Please point me to a tutorial if you know of one or explain how this can be done if you can. Thanks in advance.
Jun 01, 2015 09:32 PM|Li Wang|LINK
Thank you for your post.
According to your description, you need to map returned columns to a complex type.
Steps below are for your reference.
1.Create a function import that returns a complex type.
2.Map the columns that are returned by the function import to the specified complex type.
Link below is for your reference.
For more information about Complex Types, link below is for your reference.
Hoping my reply could be helpful to you.