I have a gridview control on a page where I need to do a join query. I've written the LINQ query like so:
from v in view_result.Find(f => f.user_id == Session["username"].ToString())
join od in article.All() on v.article_id equals od.article_id
orderby v.view_date descending
select v;
I can't figure out how to write it in the other subsonic3 syntax
var b = article.All().Join(?)
The LINQ query throws an error when it executes:
Exception Details: System.NotSupportedException: The data source does not support server-side data paging.
On the databind() call. I have another grid on the same page that reders perfectly fine, so it's either the join that's throwing it off or multiple grids on the same page. Can someone help me see what I'm missing? I appreciate any help!
Jon