var list = (from u in db.Users join c in db.Customers on u.CustomerId equals c.CustomerId where u.Username == username
   select new {u.UserId, u.CustomerId, u.ClientId, u.RoleId, u.Username, u.Email, u.Password, u.Salt, u.Hint1, u.Hint2, u.Hint3, u.Locked, u.Active,c.ProfilePic}).First();

编写所需的表名，并初始化select以获得字段的结果。

试试这个吧，

var dealer = from d in Dealer
             join dc in DealerContact on d.DealerID equals dc.DealerID
             select d;

基本上LINQ连接操作符对SQL没有好处。例如，下面的查询

var r = from dealer in db.Dealers
   from contact in db.DealerContact
   where dealer.DealerID == contact.DealerID
   select dealerContact;

将导致内部连接在SQL

join对IEnumerable<>有用，因为它更有效:

from contact in db.DealerContact  

条款将对每个经销商重新执行 但对于IQueryable<>则不是这样。另外，连接也不太灵活。

使用Linq Join操作符:

var q =  from d in Dealer
         join dc in DealerConact on d.DealerID equals dc.DealerID
         select dc;

从d1在dealercontract中加入d2在dealercontract中d1.dealearid = d2.dealerid select new {dealercontract.*}

实际上，在linq中，通常最好不要加入。当有导航属性时，一个非常简洁的方式来写你的linq语句是:

from dealer in db.Dealers
from contact in dealer.DealerContacts
select new { whatever you need from dealer or contact }

它转换为where子句:

SELECT <columns>
FROM Dealer, DealerContact
WHERE Dealer.DealerID = DealerContact.DealerID