ADO.NET Ef4- How can i map a entity to stored procedure without mapping to table.

Question

We are using ado.net entity framework 4.0 for our database layer and I am a newbie to ado.net entity framework. I have created entity via adding a entity in entity framework. I want to map that entity with stored procedure only not table of the database. Stored procedure will return same column as entity. How it is possible and how i can do that without mapping to table?

Answer 1

Here is a complete walkthrough http://msdn.microsoft.com/en-us/library/cc716679.aspx

Answer 2

Its not possible because an ObjectSet is an IQueryable and mapping an ObjectSet to stored procedure would not give u an IQueryable because stored procedures by their very nature cannot be composed. The best you can do is take the content inside the stored procedure and put into a view and map the view to an ObjectSet which is possible.

Answer 3

Then i am not understanding your question. you can map insert,update and delete operations of an entity to stored procedure. You can expose stored procedures as methods on the object context. In .net 4.0, an ObjectSet can only be bound to a table or a view.