Yes it's handle and ther'es even unit test to check
example
select
c.Category_Id, c.Category_Name,
null as Product_Id, null as Product_Name,
null as Item_Id, null as Item_UnitCost, null as Item_Status
from Categories c
Category_Id Category_Name Product_Id ....
FISH Fish NULL NULL NULL NULL NULL
DOGS Dogs NULL NULL NULL NULL NULL
REPTILES Reptiles NULL NULL NULL NULL NULL
CATS Cats NULL NULL NULL NULL NULL
BIRDS Birds NULL NULL NULL NULL NULL
DINO Dinos NULL NULL NULL NULL NULL
is right mapping to below with no problem
public class Category
{
...
public IList<Product> GenericProducts {}
...
}
public class Product
{
...
public IList<Item> GenericItems {}
...
}
--
Cheers,
Gilles
