Convert SQL select statement to Linq

Question

How can I convert the following SQL select statement to Linq?

SELECT u.Name FROM User u AS DDC
INNER JOIN Country c ON c.UserId = u.UserId
INNER JOIN (
     SELECT AddressId,
            Address, 
            PC, 
        FROM AddressTbl a
    WHERE a.CountryId = 1
) AS Addresses ON Addresses.AddressId= u.AddressId

WHERE 

u.UserIs = @UserId AND
Addresses.AddressId= @AddressId

Any good reading references?

This is a question that is relevant to you but will never be of interest to anyone else. It would be better to ask about the T-SQL structures that give you trouble. eg. the subquery join. — Peter, Jan 06 '12 at 12:32

score 2 · Accepted Answer · answered Jan 06 '12 at 13:07

2

from u in Users join 
     c in Country on  c.UserId equals u.UserId
     join a in Address on a.AddressId equals u.AddressId     
where a.CountryId == 1
select u.Name

answered Jan 06 '12 at 13:07

Jahan Zinedine

14,616
5
46
70

score 0 · Answer 2 · answered Jan 06 '12 at 13:04

0

You can try this out http://www.sqltolinq.com/

answered Jan 06 '12 at 13:04

user1120193

252
3
11

Convert SQL select statement to Linq

2 Answers2