left join in linq in C#

Question

0.00/5 (No votes)

See more:

C#

select * 
from lst1 left join lst2 on lst1.ID=lst2.ID

i want linq statement equivalent to this?

Posted 18-Sep-12 18:34pm

faezeh66

Updated 18-Sep-12 18:50pm

v3

Add a Solution

Comments

Mehdi Gholam 19-Sep-12 0:41am

And the question is?

faezeh66 19-Sep-12 0:48am

this is a sql statement i want linq statement of this?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sandeep Mewara · Accepted Answer · 2012-09-18T19:41:00

You should have tried! Please do share your effort made from next time.

It would be something like:

SQL

from lst1 in TXs
       join lst2 in TYs on lst1.ID equals lst2.ID into yG
       from y1 in yG.DefaultIfEmpty()
       select new { X = lst1, Y =y1 }

Learn from here:
MSDN: How to: Perform Left Outer Joins (C# Programming Guide)[^]
Converting SQL to LINQ, Part 1: The Basics (Bill Horst)[^]