lambda linq not join c#

我有一个查询，它向我返回userid在access表中的用户和users的名称，我想要的是将不在access中的用户的userid还给我。：

 var query = db.Users
      .Join(db.Access, c => c.UserId, o => o.UserId,
       (c, o) => new { c.UserId, c.Name });

在sql中，它应该是这样的：

SELECT  Users.Name
FROM     Access INNER JOIN
               Users ON Access.UserId <> Users.UserId

lambda expression与sql脚本等价于什么？

var res = db.Access.Except(query);

//Get Access user ids into an array
var AccessUserIds = db.Access.Select(a => new {a.UserId}).ToArray();
//Users who are not in Access user id array
var Results = db.Users.Where(u => !AccessUserIds.Contains(u.UserId));

var exclude = db.Access.Select(p => p.UserId);

var us = db.Users.Where(q => !exclude.Contains(q.UserId)).ToList();

ViewBag.UsersId = new SelectList(us, "UserId", "Name");