Two tables, Categories and Forum. One to many relationship. Building a dropdown from LINQ. Classes work ok but my syntax for the join, or something, is off.
Here it is, in it's current state, after many edits:
Code VBNET:DropDownList1.DataSource = From f In wrdc.Forums Join c In wrdc.Categories On f.CategoryID Equals c.ID Select f, c Where f.IsVisible = True And c.IsVisible = True
Doing a basic select works fine:
Code VBNET:DropDownList1.DataSource = From f In wrdc.Forums Select f Where f.IsVisible = True Order By f.Sequence
Both Categories and Forums have a sequence field for ordering. I need to get forum info sorted correctly by cateogry.sequence and then forum.sequence. Thanks in advance for any LINQ help.