[C#]
class ProductsByCategory
{
public int ID { get; set; }
public int? ParentID { get; set; }
public string Name { get; set; }
}
protected void LinqDataSource1_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
NorthwindClassesDataContext dc = new NorthwindClassesDataContext();
e.Result = (from c in dc.Categories
select new ProductsByCategory
{ ID = c.CategoryID, ParentID = null, Name = c.CategoryName })
.Union(from p in dc.Products
select new ProductsByCategory
{ ID = p.ProductID, ParentID = p.CategoryID, Name = p.ProductName });
}
[VB]
Friend Class ProductsByCategory
Public Property ID() As Integer
Public Property ParentID() As Integer?
Public Property Name() As String
End Class
Protected Sub LinqDataSource1_Selecting
(ByVal sender As Object, ByVal e As LinqDataSourceSelectEventArgs)
Dim dc As New NorthwindClassesDataContext()
e.Result = (
From c In dc.Categories
Select New ProductsByCategory
With {.ID = c.CategoryID, .ParentID = Nothing, .Name = c.CategoryName})
.Union
(From p In dc.Products
Select New ProductsByCategory
With {.ID = p.ProductID, .ParentID = p.CategoryID, .Name = p.ProductName})
End Sub