Блог

Может кто-нибудь, пожалуйста, помочь преобразовать следующее в запрос LINQ To SQL?

 select * from projects pr
where pr.Active<>0 
AND CapturedDocumentType=2 
AND SubmissionReminderTypeID > 0 
AND pr.ProjectID In(SELECT Max(wpr.ProjectID) as ProjID 
                    FROM Projects wpr 
                    where wpr.Active<>0 
                    AND wpr.CapturedDocumentType=2 
                    AND wpr.SubmissionReminderTypeID > 0
                    group by wpr.EmployeeID)
  

попробуйте это

 var result = from pr in dc.Projects
             where 
                (from wpr in dc.Projects
                 where wpr.Active amp;amp; 
                       wpr.CapturedDocumentType == 2 amp;amp; 
                       wpr.SubmissionReminderTyepID > 0
                 group wpr by wpr.EmployeeID into gpr
                 select gpr.Max(x => x.ProjectID)).Contains(pr.ProjectID)
             select pr;