views:

4

answers:

0

How to modidy entity in query? I have code like this:

var res = from p in dc.Folders
          group p by p.FolderId into gr
          let DDate = gr.Where(a =>a.status ==5).Max(g=>g.MDate)
          from c in gr
          select c;

Folder class has extra member not mapped to db called DDDate, just for example. How I can set this member in query? If I drop let keyword and calculate&assign DDate in separate forearch cycle, it will be too slow.