ef linq to sql left join 连表查询

业务需求，根据Messages中的userid查询用户名，但是主要注意，其中的userid可能为空或不存在

            var list = from Message in DbContext.Messages
                       join house in DbContext.House on Message.HouseID equals House.HouseID
                       join Users in DbContext.Users
                       on Message.UserID equals Users.UserID
                       into newUTM
                       from y in newUTM.DefaultIfEmpty()
                       orderby Message.AddTime descending 
                       select new
                       {
                           Message,
                           house,
                           Users=y,
                           isHave = y!=null
                           
                       };