Adding stored procedures complex types in Entity Framework

by

OK – here’s the step-by-step way of doing this:

(1) add your stored procedure to the EDMX file (when you first create it, or later on by using Update model from database and picking that stored procedure)

(2) once you have the stored procedure in your model – use the Model Browser to add a Function Import :

enter image description here

(3) the next dialog that pops up is vitally important – you need to (1) define that the stored procedure returns a collection of complex types, then you need to (2) get the column info from that stored procedure to know what columns it will return, then (3) you tell Visual Studio to generate a new complex type based on that column info:

enter image description here

(4) once you’ve done that – you should now see the stored procedure in your conceptual model section in the Model Browser, and the newly generated complex type should show up there, too:

enter image description here

More Related Contents:

  1. open SaveFileDialog [closed]
  2. How to execute a stored procedure within C# program
  3. Call a stored procedure with parameter in c#
  4. Calling stored procedure with return value
  5. Entity Framework 4 – AddObject vs Attach
  6. Entity Framework Join 3 Tables
  7. EF Including Other Entities (Generic Repository pattern)
  8. Entity Framework 4 Delete Object from entity collection
  9. Entity Framework/Linq EXpression converting from string to int
  10. Why does the Contains() operator degrade Entity Framework’s performance so dramatically?
  11. How to access a specific item in a Listbox with DataTemplate?
  12. The result of a query cannot be enumerated more than once
  13. Using DateTime in a SqlParameter for Stored Procedure, format error
  14. Entity Framework/Linq to SQL: Skip & Take
  15. The object cannot be deleted because it was not found in the ObjectStateManager
  16. Entity Framework – Add Navigation Property Manually
  17. Entity Framework – Invalid Column Name ‘*_ID”
  18. Stored procedure return into DataSet in C# .Net
  19. Entity Framework Include() is not working
  20. Better way to query a page of data and get total count in entity framework 4.1?
  21. What is passing parameters to SQL and why do I need it?
  22. EF4 Code First: how to add a relationship without adding a navigation property
  23. Entity Framework 4: How to find the primary key?
  24. How to Refresh DbContext
  25. How to pass a null variable to a SQL Stored Procedure from C#.net code
  26. Add the where clause dynamically in Entity Framework
  27. How to call Stored Procedures with EntityFramework?
  28. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  29. Passing parameter to stored procedure in C#
  30. Entity Framework Code First naming conventions – back to plural table names?

Leave a Comment