+4  A: 

Hi Crafty, I looked at your example project. Try updating the AssociationMapping node in the Mapping section of your EDMX file to include a condition to allow for nulls.

e.g.

<AssociationSetMapping>
  ...
  <Condition ColumnName="" IsNull="false"/>
</AssociationSetMapping>

Cheers,

Rob

theGecko
Thanks.. i'll give it a go and let you know.
CraftyFella
brilliant... that totally works.. It now looks like this:<Condition ColumnName="ChildID" IsNull="false"/>
CraftyFella