从父-子表中提取记录...我想从父控制器中的父表访问子表属性

Question

父表公开课活动{public int ActivityId｛get；set；｝

public string ActivtiyName { get; set; }
[JsonIgnore]
public List<ActivityFeature> ActivityFeature { get; set; }

}

子表

public partial class ActivityFeature
{
public int FeatureId { get; set; }

public string FeatureName { get; set; }
public bool IsChecked { get; set; }
//Navigation properties
public int ActivityId { get; set; }
public Activity Activity { get; set; }
}

控制器公共异步任务<ActionResult<IEnumerable>gt；GetActivity((｛

//_context.Activity.Include(e => e.ActivityFeature).ToList();
var Activty = _context.Activity
.Select(c => new
{
ActivityId = c.ActivityId,
ActivityFeatures = c.ActivityFeature
}).ToList();

return _context.Activity;
} 

Answer 1

试试这个

var activty = _context.Activity
.Include(i=> i.ActivityFeature)
.ToList();

或者如果你想要一个有id 的活动

var activty = _context.Activity
. Where (i=> i.ActivityId==id)
.Include(i=> i.ActivityFeature)
.FirstOrDefault();

或者只是子表

var activtyFeatures = _context.Activity
. Where (i=> i.ActivityId==id)
.Select(i=> i.i.ActivityFeature)
.FirstOrDefault();

或相同的结果

var activtyFeatures = _context.ActivityFeature
.Where(i=> i.ActivityId=id)
.ToList();