Mapping Complex Types to results form SqlQuery in Entity Framework

Question

I am calling a stored proc using SqlQuery, the result is supposed to be a graph of objects, i.e.

public class Person
 {
   public int Id{get;set;}
   public string FullName {get;set;}
   public Address HomeAddress {get;set;}
   public Vehicle PrivateVehicle {get;set;}
 }

But SqlQuery wont map the Address and Vehicle. It only maps the column names to the properties.

Is there a work around this? How else can I do the mapping?

I found this:

.. what you can't do is return graphs of objects, e.g. entities that contain properties of complex types.

This bug has been an irritant to me as well. Haven't found a workaround yet. — jnm2
– jnm2, Commented Mar 25, 2014 at 17:21

Jon Adams · Accepted Answer · 2015-01-09 04:10:58Z

5

Entity Framework (up through 6 anyway) doesn't support mapping raw SqlQueries to an object graph, only as a simple entity.

You can use standard LINQ with standard Entity Framework reference mapping between them, and use Includes or whatever else you need.

But if standard LINQ to EF won't work because your SqlQuery uses SQL functions or stored procedures or something, then you're out of luck.

PS: Posting your SQL query might help in the future so the answer can be more specific to your problem.

answered Jan 9, 2015 at 4:10

Jon Adams

25.3k18 gold badges85 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Mapping Complex Types to results form SqlQuery in Entity Framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related