I have a back end data store that is receiving frequent updates from another process. (Currently SQL Express 2005 but I don't want to tie myself to that.)
I have one table of groups and another that is children of that group, some of the children are periodically moved from one group to another and sometimes new children are added.
When I do a:
MyContext.Refresh(RefreshMode.StoreWins, group.children);
The child collection does not reflect any of the added children. Is there a way to get these child collections to fully refresh?