DevForce Community Forum : Parent-Child using DevForceEF http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Parent-Child using DevForceEF Mon, 13 Apr 2026 20:16:19 -700 Wed, 07 Jan 2009 04:29:57 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1050 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Parent-Child using DevForceEF : Hi, I'm experimenting with... http://www.ideablade.com/forum/forum_posts.asp?TID=1050&PID=3780#3780 Author: oldie
Subject: 1050
Posted: 07-Jan-2009 at 4:29am

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
]]> Wed, 07 Jan 2009 04:29:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1050&PID=3780#3780