sql joining two tables on one string match

Question

This is my linq query -

from u in db.CardTables
   join v in db.FunRegistereds
   on new { u.IsApproved, u.FKCardID } equals new {"YES", v.UserID }

Where from this query column in first table CardTables has one with string match and column FKCardID is integer type.

I am getting troubled with this first string match.

How do I match this u.IsApproved column with string "YES" while matching both the columns in this way ??

Sergey Berezovskiy · Accepted Answer · 2014-03-07 17:27:46Z

4

Join on FKCardID equals UserID and just filter u.IsApproved:

from u in db.CardTables
join v in db.FunRegistereds
   on u.FKCardID equals v.UserID
where u.IsApproved == "YES"
...

answered Mar 7, 2014 at 17:27

237k44 gold badges441 silver badges468 bronze badges

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

1 Comment

@p.s.w.g thanks, actually I was thinking about your solution :) But decided not to join on query parameter - and added filtering instead :)

p.s.w.g · Accepted Answer · 2014-03-07 18:36:38Z

3

You need to give names to the properties in the second anonymous type initializer:

from u in db.CardTables
join v in db.FunRegistereds
on new { u.IsApproved, u.FKCardID } equals 
   new { IsApproved = "YES", FKCardID = v.UserID }

answered Mar 7, 2014 at 17:28

p.s.w.g

150k31 gold badges307 silver badges339 bronze badges