Just playing with a bit of LINQ against typed datasets.
The cdsEntities table was already filled in my DAL now I want to select a few rows from that DataTable into a new collection.
ParentID can be null and when I run the following query against the typed dataset it throws an exception.
StrongTypingException("The value for column \'ParentID\' in table \'cdsEntities\' is DBNull."
private void recurseTree(int? id, cdsTreeNode parent)
{
var entities = from cdsEntitiesDS.cdsEntitiesRow e in ds.cdsEntities
where e.ParentID == id
select e;
}
I see a few ways around it, including editing the designer code and/or not using nulls.
The problem with editing the designer code is that I think I would have to redo it if I regenerate the dataset, which would be a pain.
I was wondering if there is another cleaner method of handling it.