Use "and" in the linq join predicate

Question

I want to Use two field in my join predicate in linq.How can i add the other field ?

    var Result = from Period in context.PeriodCosts
                 join Name in context.Name on Period.ID equals Name.PeriodID 
                /*"Problem is here ==> */and   
                 Period.CCID equals Name.CCID"
                 select Name;

MarcinJuraszek · Accepted Answer · 2014-01-13 06:03:27Z

5

Use anonymous type:

var Result = from Period in context.PeriodCosts
             join Name in context.Name
                 on new { ID = Period.ID, CCID = Period.CCID }
                 equals new { ID = Name.PeriodID, CCID = Name.CCID }
             Period.CCID equals Name.CCID"
             select Name;

answered Jan 13, 2014 at 6:03

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

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

Comments

Naveen · Accepted Answer · 2014-01-13 06:04:11Z

1

Try the below

 var Result = from Period in context.PeriodCosts
             join Name in context.Name on 
             new{Period.ID, Period.CCID} equals new { Name.PeriodID, Name.CCID}               
             select Name;

answered Jan 13, 2014 at 6:04

Naveen

1,5021 gold badge15 silver badges24 bronze badges

Collectives™ on Stack Overflow

Use "and" in the linq join predicate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related