DevForce Community Forum : WinRT, Code First - 'Include' clause does not work. http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2012 : WinRT, Code First - 'Include' clause does not work. Fri, 10 Apr 2026 22:31:41 -700 Mon, 29 Jul 2013 12:24:07 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4249 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ WinRT, Code First - 'Include' clause does not work. : It looks like DevForce has a problem... http://www.ideablade.com/forum/forum_posts.asp?TID=4249&PID=16662#16662 Author: kimj
Subject: 4249
Posted: 29-Jul-2013 at 12:24pm

It looks like DevForce has a problem with the private setter on the User.UserRoles navigation property.  It's probably eating the error and should not.  You won't be able to use a private accessor, but in theory internal should be allowed, although that too doesn't seem to be working and is something we need to look at.
 
To work around the issue, you can define the property like this:
 
  public RelatedEntityList<UserRole> UserRoles { get { return null; } }
 
or this:
 
  public RelatedEntityList<UserRole> UserRoles { get; set; }
 
More on defining navigation properties in Code First here - http://drc.ideablade.com/devforce-2012/bin/view/Documentation/code-first-entity-classes.
 
]]> Mon, 29 Jul 2013 12:24:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4249&PID=16662#16662 WinRT, Code First - 'Include' clause does not work. : Hi, I am using EF Code First... http://www.ideablade.com/forum/forum_posts.asp?TID=4249&PID=16657#16657 Author: zbig
Subject: 4249
Posted: 27-Jul-2013 at 1:49pm

Hi,

I am using EF Code First with fluent mapping. When I'm executing query which contains 'Include' clause, related entities are not retrieved.

Please find attached a trivial application (package libraries removed to be able to attach the solution).The solution includes only three entities: User, Role, UserRole (many to many relational table).

I think, I made everything what is necessary to get related entities (according to the documentation), but after executing query (MainPage.xaml.cs):


var usersQuery = appTestEntityManager
               .Users
               .Include(u => u.UserRoles);

var result = await appTestEntityManager.ExecuteQueryAsync(usersQuery);


the 'result' variable does not contains related 'UserRoles'.

Database is properly created and filled out by sample data during executing query. Everything seems to be ok ... I have no idea what is wrong.

Thanks in advance for any advice.

AppTest.zip]]> Sat, 27 Jul 2013 13:49:31 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4249&PID=16657#16657