Entity Framework: ObjectContext.ExecuteStoreQuery produces detached objects

Question

I need to run some custom SQL to return a list of objects from a table. I'm using ExecuteStoreQuery for that.

var q = context.ExecuteStoreQuery<ProductionUnit>(MySelectString, new SqlParameter("@ProductionUnitId", value));

This does result in q containing an ObjectResult collection, but the actual ProductionUnit elements are Detached and their EntityKey is null. This creates a number of issues when trying to work on some of these objects or their relationships. My SQL query returns a result set containing all the columns of the respective ProductionUnits table (and nothing more).

Anything else I need to do in order to have these objects tracked or is this behavior by design?

Answer 1

Solved it myself - you need to use the ExecuteStoreQuery overload which allows you to specify the EntitySet name for your returned entities.