How to write a Linq to SQL join query with parameter which returns columns from both table?

Question

I can't figure out how to write this query in Linq:

select ic.icCategory, d.domHosting, d.domCode  
  from Domains d join Image_Categories ic 
    on ( d.domCode = ic.icDomainCode )
      where d.domCode = 'code'

Can anyone help?

Thanks

Pleun · Accepted Answer · 2011-12-15 07:45:59Z

2

if you have proper foreign key constraints in your database, there is no need to do all the plumbing on the join yourself. linq-sql creates these also in your classes! That is the beauty of an orm, otherwise you are just writing sql in a different syntax.

You can do

Var x = from i in db.Image_categoriees
    Where i.domain.domcode == 'code'
    Select new { i.icCategory, i.domain.domcode, i.domain.domhosting}

answered Dec 15, 2011 at 7:45

Pleun

8,9102 gold badges33 silver badges51 bronze badges

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

1 Comment

Pleun Over a year ago

Thx. I encourage you to switch to the more OO side, i think it is easier to read and maintain...

Kiley Naro · Accepted Answer · 2011-12-14 19:29:46Z

1

Try something like this:

var result =
    from d in dbContext.Domains
    join ic in dbContext.Image_Categories on d.domCode equals ic.icDomainCode
    where d.domCode == 'code'
    select new { ic.icCategory, d.domHosting, d.domCode }

There is some more information about the Query Expression Syntax Join Operators and some examples here:

http://msdn.microsoft.com/en-us/library/bb896266.aspx

edited Dec 14, 2011 at 19:29

answered Dec 14, 2011 at 19:24

Kiley Naro

1,7791 gold badge14 silver badges20 bronze badges

Comments

Mike Mooney · Accepted Answer · 2011-12-14 19:23:17Z

0

from Domains d join Image_Categories ic  on d.domCode equals ic.icDomainCode
where d.domCode = 'code'
select ic.icCategory, d.domHosting, d.domCode

answered Dec 14, 2011 at 19:23

Mike Mooney

12k3 gold badges39 silver badges43 bronze badges

2 Comments

Kiley Naro Over a year ago

-1 This code won't compile. If you make the necessary corrections I will rescind the downvote.

Mike Mooney Over a year ago

Keep your stupid downvote. It's close enough to clarify the proper functionality. If really think that justifies a downvote, so be it.

Collectives™ on Stack Overflow

How to write a Linq to SQL join query with parameter which returns columns from both table?

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related