This code block shows how to left join in c# using linq
List<File> files = (from f in db.Files join cf in db.ContentFiles on f.Id equals cf.FileId into leftj from lj in leftj.DefaultIfEmpty() where f.CreateDate < dt1 && f.CreateDate > dt2 && lj ==null select f).ToList();
Comments