Covert SQL LEFT OUTER JOIN to LINQ Query

Question

0.00/5 (No votes)

See more:

How to convert the following SQL query to linq? ORM using Nhibernate, Mapclass is having same name of Tables

SQL

SELECT Users.*,UserRole.UserRoleLinkId  FROM Users LEFT OUTER JOIN UserRole ON Users.UserId=UserRole.UserRoleId and UserRole.UserId=10 where RecordType='R'

help plz..

Posted 30-Dec-13 19:55pm

Sadique KT

Updated 12-May-16 3:05am

v2

Add a Solution

Comments

Member 11540691 3-Aug-15 8:57am

how to write this query in linq using left outer join
please help me

select a.EventID,a.PrizeId,b.PrizeName,b.PrizeValue,c.FightID,c.Winnerid,c.WinnerName
from tblUserprize a
join tblPrizeDetails b on a.PrizeId=b.PrizeId
left outer join tblWinnersList c on a.EventID=c.EventID and a.PrizeId=c.PrizeId and c.FightID = 1534
where a.EventID = 1320

2 solutions

Solution 1

Use tools like LINQPad[^] for conversion

Posted 30-Dec-13 20:00pm

thatraja

Comments

Maciej Los 31-Dec-13 2:07am

+5!
Have a look at my answer ;)

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2013-12-30T20:07:00

Solution 2

Have a look here: How to: Perform Left Outer Joins (C# Programming Guide)[^]

Posted 30-Dec-13 20:07pm

Maciej Los

Comments

thatraja 31-Dec-13 2:11am

There that bunch is looks very good. 5!

Maciej Los 31-Dec-13 2:12am

Thank you, Raja ;)
And Best Wishes For New Year!

thatraja 31-Dec-13 2:15am

Same to you! Please send me half if you win any lottery

Maciej Los 31-Dec-13 2:29am

Half only? ;)

By The Way: Polish ZLOTY isn't strong currency. Please, find out: XE.xom[^]

thatraja 31-Dec-13 2:41am

That's enough for me. Please do ASAP, it's urgentz! :)

Maciej Los 31-Dec-13 2:49am

;)

Covert SQL LEFT OUTER JOIN to LINQ Query

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Covert SQL LEFT OUTER JOIN to LINQ Query

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us