CODEWITHSUNDEEP
.netjoinsubsonicsubsonic3subsonic-active-record
Earlz
Earlz

Reputation: 63825

Doing joins with SubSonic/ActiveRecord easily?

I am using SubSonic with the ActiveRecord template. I like it pretty well so far but can not figure out how to do a join query. I have read this link but the generated class templates it creates does not have anything of type IColumn

Is there something I am missing here? Also, I am using SubSonic 3.0

Upvotes: 0

Views: 199

Answers (1)

Jeremy Seekamp
Jeremy Seekamp

Reputation: 2796

You can use simple Linq queries to do joins with Subsonic.

For example:

var products = from p in Product.All()
               join od in OrderDetail.All() on p.ProductID equals od.ProductID
               select p;

Upvotes: 2

Related Questions