.Net EntityFramework 表的联立存储联立查询

定义主表字段，主表包含字表类型SettingResultTable即可

    public class SettingTable
    {
        [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public SettingResultTable SettingResult { get; set; }
        public byte MessageId { get; set; }
    }

定义字表字段

    public class SettingResultTable
    {
        [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int Id { get; set; }
        public int AnRequestType { get; set; }
    }

调用save

    _dataContext.SettingTables.Add(settingTable);
    _dataContext.SaveChanges();

查询使用联合即可

var settingTables = _dataContext.SettingTables.Include(x=>x.SettingResult).ToList();