I am using SubSonic with the A开发者_C百科ctiveRecord 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
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;
精彩评论