Entity Framework – Detach and keep related object graph

Try using a NoTracking query instead. That way the objects arenever attached, so you don’t need to ‘detach’ which is when the graph is shredded:

i.e.

using (var creativeWorkshopEntities = new CreativeWorkshopEntities())        
{            
    creativeWorkshopEntities.Job.MergeOption = MergeOption.NoTracking;
    var q = from c in creativeWorkshopEntities.Job.Include("Files")
            where c.Id == jobId                    
            select c;            
    var job = q.First();            
    return job;
} 

Hope this helps

Alex

(Program Manager Entity Framework Team)