How can I load entities with complex types from a table-valued function?

Asked Feb 22 '17 at 14:58

Active Feb 22 '17 at 21:33

Viewed 169 times

I have a table-valued function that returns entities that contain complex types. I am trying to figure out the best way to load this data into my code-first application as entities.

I tried the Code First Functions project, but it doesn't support entities with complex types.

I also tried SqlQuery, e.g.,

context.MyEntities.SqlQuery("SELECT * FROM [TableValuedFunction]()")

but that also doesn't support complex types, apparently. I get an InvalidOperationException that says, "Only properties of primitive or enumeration types are supported."

My use case is pretty limited since this will be readonly data. I don't need things like change tracking or even an IQueryable instance. I can live with just a single entity that I display and then discard.

I think I can probably get around this "manually" by just executing the SQL, get the data back in a DataTable, and using that to create my entities. But that's obviously undesirable for many reasons, not least of which is that it's basically ditching Entity Framework entirely.

Is there any other way to create my entities in a more automated fashion?

Here is a simple example that uses the Code First Functions project, but fails.

edited Feb 22 '17 at 21:33

asked Feb 22 '17 at 14:58

Kris Harper

5,672
8
51
96

I think it has something to do with the key. Perhaps an 'int Id' as key is expected. – Feb 22 '17 at 21:29
@RuardvanElburg My entities have `int Id` as primary keys. – Kris Harper Feb 22 '17 at 21:33
I do not see an Id in Address, or is that just a typo? – Feb 22 '17 at 21:45
@RuardvanElburg Address is not an entity. It is a complex type. – Kris Harper Feb 22 '17 at 21:49
With `SqlQuery` you can only use straight POCOs. I think that it underneath the error from Code First Functions. – Gert Arnold Feb 23 '17 at 20:28

How can I load entities with complex types from a table-valued function?

0 Answers0