How to create complex type in Entity Framework 4.0

Question

While creating function imports in Model Browser, Get Column Information does not returns any columns, probably the reason is this

My stored procedure returns data from a temp table and at the end of procedure i drop that table.

I am not sure, Please confirm, if this is the case, No column information, So create complex type is also not possible for this case.

Please suggest me how to create complex type manually for the procedures whose column information does not resolved by function imports screen.

Thanks

Ladislav Mrnka · Answer 1 · 2011-07-14T08:18:49.933

9

OMG, have you heard about Google?

How to create and modify complex types - first link!

EF is not able to infer complex types from stored procedures using some more complex techniques like dynamic SQL, temp tables, different result sets per control flow in stored procedure, multiple result sets, etc.

edited Jul 14 '11 at 08:18

answered Jul 14 '11 at 08:04

Ladislav Mrnka

360,892
59
660
670

+1 for mentioning EF does not auto-infer for stored procs using temp tables and dynamic SQL. – arviman Sep 22 '11 at 22:49

score 1 · Accepted Answer · edited Dec 16 '11 at 07:41

1

There is no automated way to do this, you have to do it manually. Just do a right click on the complex type and start adding what you want to add.

edited Dec 16 '11 at 07:41

Fischermaen

12,238
2
39
56

answered Dec 16 '11 at 06:56

score 1 · Answer 3 · answered Dec 16 '11 at 07:37

1

I always JSON the object and save as string, then unJSON back. Even for ExpandoObject, works well.

Specially these days I save the data to Azure table, more easy to scale and affordable

answered Dec 16 '11 at 07:37

Eric Yin

8,737
19
77
118

How to create complex type in Entity Framework 4.0

3 Answers3