javascript - 获取外键表数据

Question

从 dbcontext this.dbcontext.JobDetails.GetAll() 获取数据时。在这里，我还需要来自当前 jobDetails 的外键表中的数据。

public class Like
{
    public int LikeId { get;  set; }
    public JobDetails JobDetails { get; set; }
    [ForeignKey("JobDetailFK")]
    public int JobDetailId { get; set; }
}
public class JobDetails
{
    [Key]
    public int JobDetailId { get; set; }
    public ICollection<Like> Likes { get; set; }
}

Answer 1

在 Entity Framework 6 中，您可以这样做:

using (DatabaseContext context = new DatabaseContext()) {
    return context.JobDetails.Include(x => x.Likes).ToList();
}