I have a query which is failing, as it needs to be using LEFT JOIN, as opposed to the default INNER JOIN used by the 'join' syntax:
var users = (from u in this._context.Users
join p in this._context.Profiles on u.ProfileID equals p.ID
join vw in this._context.vw_Contacts on u.ContactID equals vw.ID
orderby u.Code
select new { ID = u.ID, profileId = p.ID, u.ContactID, u.Code, u.UserName, vw.FileAs, p.Name, u.LastLogout, u.Inactive, u.Disabled }).ToList();
How would i re-write this so that is utilises a LEFT join?