Edit Question - KnowledgeHub

Title Body

I have two linq (to EF4) queries, which return different results. The first query contains the correct results, but is not formatted/projected right. the second query is what i want but it missing some data. Schema alt text http://img220.imageshack.us/img220/9678/schema.png Query 1 var xxxx = (from cp in _connectedClientRepository .GetConnectedClients(new[] { "LogEntry", "LogEntry.GameFile" }) .AsExpandable() .Where(predicate) select cp) .ToList(); alt text http://img231.imageshack.us/img231/6541/image2ys.png Notice the property GameFile . It is not null. This is great :) Notice the linq query? I'm eager loading a LogEntry and then eager loading a GameFile (for each eager loaded LogEntry). This is what i'm after -> for each LogEntry that is eager loaded, please eager load the GameFile . But this projection result is wrong... Ok.. next... Query 2 var yyy = (from cp in _connectedClientRepository .GetConnectedClients(new[] { "LogEntry", "LogEntry.GameFile" }) .AsExpandable() .Where(predicate) select cp.LogEntry) .ToList(); NOTE : the image above has a typo in it ... please note the include associations typed code is correct (ie. LogEntry.GameFile ) while the image has it typo'd. Correct projection now -> all LogEntries results. But notice how the GameFile property is now n

Tags (comma-separated) Cancel