Print Page | Close Window

WinRT, Code First - 'Include' clause does not work.

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2012
Forum Discription: For .NET 4.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=4249
Printed Date: 04-Apr-2025 at 1:51pm


Topic: WinRT, Code First - 'Include' clause does not work.
Posted By: zbig
Subject: WinRT, Code First - 'Include' clause does not work.
Date 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.

uploads/1552/AppTest.zip - AppTest.zip


Replies:
Posted By: kimj
Date 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 - http://drc.ideablade.com/devforce-2012/bin/view/Documentation/code-first-entity-classes .
 


Print Page | Close Window