Multiple Join in Entity Framework

Question

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'.

I think you copy pasted, so I can see an 'eqals' that maybe is 'equals' — Amedio
– Amedio, Commented Jul 18, 2012 at 9:03

BryanH · Accepted Answer · 2013-01-04 15:44:37Z

9

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();

edited Jan 4, 2013 at 15:44

BryanH

6,1133 gold badges37 silver badges47 bronze badges

answered Jul 18, 2012 at 9:10

JConstantine

3,9411 gold badge36 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Welsh King Over a year ago

thanks, that was simple enough. I guess ive been doing TSQL for so long I did'nt notice. Thanks again

Collectives™ on Stack Overflow

Multiple Join in Entity Framework

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related