实体框架中的多个联接(Multiple Join in Entity Framework)

实体框架中的多个联接(Multiple Join in Entity Framework)

我在TSQL中有以下查询

select * from users inner join linkUserPhoneNumber on users.UserId = linkUserPhoneNumber.UserId INNER JOIN PhoneNumber ON PhoneNumber.PhoneNumberId = linkUserPhoneNumber.PhoneNumberId where UserName = 'superuser' and password ='password'

我在Entity Framework中有以下查询

var query = (from u in myEntities.Users join link in myEntities.linkUserPhoneNumbers on u.UserId equals link.UserId join p in myEntities.PhoneNumbers on p.PhoneNumberId equals link.PhoneNumberId where u.UserName == Username && u.Password == Password select u).ToList();

当我尝试编译它时，我明白了

错误3名称'p'不在'equals'左侧的范围内。 考虑交换'equals'两侧的表达式。 错误4名称“链接”不在“等于”右侧的范围内。 考虑交换'equals'两侧的表达式。

I have the following query in TSQL

select * from users inner join linkUserPhoneNumber on users.UserId = linkUserPhoneNumber.UserId INNER JOIN PhoneNumber ON PhoneNumber.PhoneNumberId = linkUserPhoneNumber.PhoneNumberId where UserName = 'superuser' and password ='password'

I have the following query in Entity Framework

var query = (from u in myEntities.Users join link in myEntities.linkUserPhoneNumbers on u.UserId equals link.UserId join p in myEntities.PhoneNumbers on p.PhoneNumberId equals link.PhoneNumberId where u.UserName == Username && u.Password == Password select u).ToList();

When I try to compile it, I get

Error 3 The name 'p' is not in scope on the left side of 'equals'. Consider swapping the expressions on either side of 'equals'. Error 4 The name 'link' is not in scope on the right side of 'equals'. Consider swapping the expressions on either side of 'equals'.

最满意答案

究竟错误在说什么

p.PhoneNumberId equals link.PhoneNumberId

应该

link.PhoneNumberId equals p.PhoneNumberId

完整代码

var query = (from u in myEntities.Users join link in myEntities.linkUserPhoneNumbers on u.UserId equals link.UserId join p in myEntities.PhoneNumbers on link.PhoneNumberId equals p.PhoneNumberId where u.UserName == Username && u.Password == Password select u).ToList();

Exactly what the error is saying

p.PhoneNumberId equals link.PhoneNumberId

should be

link.PhoneNumberId equals p.PhoneNumberId

Full code

var query = (from u in myEntities.Users join link in myEntities.linkUserPhoneNumbers on u.UserId equals link.UserId join p in myEntities.PhoneNumbers on link.PhoneNumberId equals p.PhoneNumberId where u.UserName == Username && u.Password == Password select u).ToList();