Left Join in Subsonic3
- by muek
Hi there,
I'm new in subsonic3, and I'm getting some errors when I try to use LeftJoin
var q =
from c in categories
join p in products on c equals p.Category into ps
from p in ps.DefaultIfEmpty()
select new { Category = c, ProductName = p == null ? "(No products)" : p.ProductName };
The error is
"System.Collections.Generic.Enumerable '...' cannot be used for parameter of type System.Linq.IQueryable
Does anyone had this error before? Did you fix it?
Thanks
