How to use leftouter join in entity framework query

Question

enter image description here How to use leftouter join in entity framework query

I have two table one is item and other is stock available I want to get all items and also get its quantity from stock available table which depend upon the particular department

Likurg · Accepted Answer · 2012-04-26 11:54:43Z

2

For example LINQ Query

var query = (from p in dc.GetTable<Person>()
join pa in dc.GetTable<PersonAddress>() on p.Id equals pa.PersonId into tempAddresses
from addresses in tempAddresses.DefaultIfEmpty()
select new { p.FirstName, p.LastName, addresses.State });

SQL Translation

SELECT [t0].[FirstName], [t0].[LastName], [t1].[State] AS [State]
 FROM [dbo].[Person] AS [t0]
 LEFT OUTER JOIN [dbo].[PersonAddress] AS [t1] ON [t0].[Id] = [t1].[PersonID]

answered Apr 26, 2012 at 11:54

Likurg

2,76019 silver badges22 bronze badges

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

2 Comments

Nadeem Over a year ago

please tell me the query in linq to entitity this is in linq to sql

Likurg Over a year ago

Read this stackoverflow.com/questions/9500103/…

Collectives™ on Stack Overflow

How to use leftouter join in entity framework query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related