How to use Entity Framework to map results of a stored procedure to entity with differently named parameters

by

From Entity Framework Code First book (page 155):

The SQLQuery method always attempts the column-to-property matching based on property name…
None that the column-to-property name matching does not take any mapping into account. For example, if you had mapped the DestinationId property to a column called Id in the Destination table, the SqlQuery method would not use this mapping.

So you cannot use mappings when calling stored procedure. One workaround is to modify your stored procedure to return result with aliases for each column that will match your object properties’ names.

Select UT_STR_AD as Address From SomeTable etc

More Related Contents:

  1. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  2. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  3. Disable lazy loading by default in Entity Framework 4
  4. EntityFramework code-first custom connection string and migrations
  5. How do I detach objects in Entity Framework Code First?
  6. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  7. How to include a child object’s child object in Entity Framework 5
  8. EF5 Code First Enums and Lookup Tables
  9. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  10. Entity Framework 4 / POCO – Where to start? [closed]
  11. Debug code-first Entity Framework migration codes
  12. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  13. Entity framework code-first null foreign key
  14. Unique keys in Entity Framework 4
  15. How do I singularize my tables in EF Code First?
  16. Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
  17. How to set default value for POCO’s in EF CF?
  18. Entity Framework 4 selective lazy loading properties
  19. How to create index in Entity Framework 6.2 with code first
  20. Upgrade EF 4 EDMX to EF 6
  21. DbSet.Find method ridiculously slow compared to .SingleOrDefault on ID
  22. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  23. What is the syntax for self referencing foreign keys in EF Code First?
  24. EF Migrations: Rollback last applied migration?
  25. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  26. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  27. Entity Framework Code First naming conventions – back to plural table names?
  28. LINQ To Entities + Include + Anonymous type issue
  29. Can anyone spot why I keep getting this error testing the EF 5 beta
  30. Entity framework code first delete with cascade

Leave a Comment