Include not mapped variable
I have two tables User and Visits - which contains user ID and all his
visits on site. This is what I have done so far. Is it possible to Count
user's visits using EF without foreach loop?
List<User> users = repo.Include(x => x.History).ToList();
foreach(User u in users)
{
u.NumOfVisits = u.History.Count();
}
public class User
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set;}
[NotMapped]
public int NumOfVisits { get; set; }
[ForeignKey("UserId")]
public IEnumerable<Borrow> History { get; set; }
}
No comments:
Post a Comment