I have 2 classes: User and Booklink
public class User
{
public int UserID { get; set; }
public string Email { get; set; }
public string Login { get; set; }
public string Surname { get; set; }
public string Name { get; set; }
public int Points { get; set; }
public string Password { get; set; }
public IEnumerable<BookLink> BookLinks { get; set; }
}
public class BookLink
{
public int LinkID { get; set; }
public int BookID { get; set; }
public int UserID { get; set; }
public DateTime EventDate { get; set; }
public Book Book { get; set; }
public User User { get; set; }
}
I used new EF4.0 feature - POCO.
The problem: when I load user entity BookLinks property is NULL (there are some child records in Booklinks table). But other fields(properties) was loaded fine and all of them (except Booklinks) have their values from database.
I receive objects from generic repository like this:
UsersRepository usersRepository = new UsersRepository();
User user = usersRepository.FindByID(1);
FindByID method is implemented like this
private ObjectSet<T> _entitySet;
return _entitySet.AsQueryable().Where(predicate).SingeOrDefault();
And navigation property Booklinks in user instance is NULL
I cant understand why I see this behaivour. How I can load child records automatically?
Here is screenshot from EF designer http://tinyurl.com/2ct45d5 (if it will help...)