Skip to content

Instantly share code, notes, and snippets.

@thnk2wn
Created Nov 18, 2013
Embed
What would you like to do?
// left join as a safety precaution
jobAdPosts = (from b in SqlContext.JobBoards
join jap in SqlContext.JobAdPosts on new { JobBoardId = b.Id, JobAdId = vm.JobAd.Id } equals new { jap.JobBoardId, jap.JobAdId } into j1
from jap in j1.DefaultIfEmpty()
where b.IsActive
orderby b.SortOrder ascending
select jap).ToList();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment