How to convert SQL inner join to lambda linq query

Question

I am new in LINQ queries and I need help to convert my sample SQL query to LINQ lambda query

select * from GRecommendations 
inner join GSections
on GRecommendations.GSectionId = GSections.Id
where GSections.GaId = 646

We're not here to convert code for you. If you tried and you got stuck somewhere you're more than welcome to tell where specifically you need help. One obvious advice: don't join in LINQ, use navigation properties. — Gert Arnold
– Gert Arnold, Commented Sep 27, 2017 at 13:11

Tom Hines · Accepted Answer · 2017-09-27 14:52:49Z

2

There are two different methods you can use when GRecommendations is a collection.

var arrResult = //UNTESTED
   GRecommendations
   .Join(GSections.Where(sec => sec.GaId.Equals(646)),
   rec => rec.GeSectionId,
   sec => sec.Id,
   (REC, SEC) => new { /*put here what you want selected*/ }
   );  //

or

var arrResult = 
(
   from rec in GRecommendations
   join rec in GSections.Where(s => s.GaId.Equals(646)) on rec.GSectionId equals sec.GaId
   select new {/*rec.something*/, /*sec.something*/}
);

answered Sep 27, 2017 at 14:52

Tom Hines

1113 bronze badges

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

Collectives™ on Stack Overflow

How to convert SQL inner join to lambda linq query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related