Hi, I'm experimenting with the DevForce and trying to query a table which is self refrencing to create a hierarchy. I renamed the entity navigation properties to Parent and Children.
I want a query to return a list of children for a particular parent but get a run time error:
Execution of query against the server was successful but execution of query against the local cache failed
Code Snippet:
DomainModelEntityManager _manager = DomainModelEntityManager.DefaultManager;
BindableList<Areas> _areas = new BindableList<Areas>();
private void LoadData() {
_areas.ReplaceRange(_manager.Areas.Where(c => c.Parent.Area.Contains("TestParent")));
}
Does the local cache need initialising first?
DevForceEF 4.2.2
VS2008 SP1
Windows XP
MSSQL Server 2005