.net core 导航属性配置 - zLulus/My_Note GitHub Wiki

public class Activity: FullAuditedEntity<long>
{
    /// <summary>
    /// 评论列表
    /// </summary>
    public List<ActivityComment> ActivityComments { get; set; }
}

public class ActivityComment : FullAuditedEntity<long>
{
    /// <summary>
    /// 外键
    /// </summary>
    public long ActivityId { get; set; }
    /// <summary>
    /// 导航属性
    /// </summary>
    public Activity Activity { get; set; }
}

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    //导航属性
    modelBuilder.Entity<ActivityComment>()
                        .HasOne(p => p.Activity)
                        .WithMany(b => b.ActivityComments)
                        .HasForeignKey(p => p.ActivityId);
    modelBuilder.Entity<Activity>()
        .HasMany(x => x.ActivityComments)
        .WithOne(x => x.Activity)
        .HasForeignKey(x => x.ActivityId);
}

private readonly IRepository<Activity, long> _activityRepository;
public ActivityManage(IRepository<Activity, long> activityRepository)
{
    _activityRepository = activityRepository;
}

public async Task Test(EntityDto<long> input)
{
    //GetAllIncluding()参数为空，不进行导航属性查询
    var list =await _activityRepository.GetAllIncluding(x=>x.ActivityComments,x=>x.ActivityEvents,x=>x.ActivityInclusions).ToListAsync();
    var entity = _activityRepository.GetAllIncluding(x => x.ActivityComments, x => x.ActivityEvents, x => x.ActivityInclusions).Where(x => x.Id == input.Id).FirstOrDefault();
}