sql join query to linq syntax

Question

how do i change this to linq to sql?

select * from ratesSchedule as rs
    inner join userdetails as ud on rs.sid = ud.sid
    and rs.tabletype = 'd'

i got this far

var results = from rs in db.ratesSchedule
              join ud in db.userdetails on rs.sid equals ud.sid

but i can't figure out how to add the "and rs.tabletype='d'"

Andomar · Accepted Answer · 2009-02-15 00:36:06Z

5

If you'd like to do it without where clause, try this:

var results = from rs in db.ratesSchedule
              join ud in db.userdetails on 
                  new { rs.sid, rs.tabletype } equals 
                  new { ud.sid, tabletype = "d" }

Personally I'd stick to SQL in this case, since LINQ isn't even easier to read. ;)

answered Feb 15, 2009 at 0:36

Andomar

239k55 gold badges387 silver badges412 bronze badges

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

2 Comments

jorsh1 Over a year ago

this was exactly what i was trying to do but with 'd' (a character type) and it wouldn't work. guess i should have tried "d". thanks!

casperOne Over a year ago

@Andomar: That's actually f'n brilliant. +1, and it's not even my answer.

casperOne · Accepted Answer · 2009-02-14 20:59:46Z

3

You should be able to just put it in the WHERE part of the statement, since you aren't joining on a condition other than a comparison to a constant field on the table:

var results = from rs in db.ratesSchedule
              join ud in db.userdetails on rs.sid equals ud.sid
              where rs.tabletype = 'd'

answered Feb 14, 2009 at 20:59

casperOne

74.7k19 gold badges189 silver badges262 bronze badges

1 Comment

jorsh1 Over a year ago

yes but i will be doing multiple joins so this solution will not work once i add that. sorry, i should have clarified

Collectives™ on Stack Overflow

sql join query to linq syntax

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related