How do I map a stored procedure to a custom type in entity framework?

Question

Hello

I have a stored procedure which returns a couple of fields from a table that has many fields

I need to get this into a custom type in my model

I have added my entity and changed the function import to return objects of the new type but now I get a problem where the columns are not mapped

Can anyone help?

Cheers

Paul

Answer 1

This MSDN article is as detailed as it can get.

Answer 2

Hi everyone

I have found the following link which has a tutorial on exactly what I want to do but I still cant get it to work

http://thedatafarm.com/blog/data-access/implement-select-stored-procedures-that-return-miscellaneous-data-in-ctp2-of-ef-designer/

Its prob because I am putting the code in the wrong places! Unfortunatly the author didnt put the final finished on the site and the formatting for the example code is not great

Could someone have a test of this please? If someone can get the tutorial working then its def something I am doing wrong

Paul