首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >实体框架外键和种子理解

问实体框架外键和种子理解
EN

Stack Overflow用户
提问于 2018-01-18 01:43:31
回答 1查看 514关注 0票数 1

我有三张桌子,

代码语言:javascript
复制
public class Parkings
    {
        [Key]
        public int ParkId { get; set; }
        [Required]
        public string StartDate { get; set; }
        [Required]
        public string EndDate { get; set; }

        public int ParkCityId { get; set; }

        public int ParkStreetId { get; set; }

        [ForeignKey("CityId")]
        public virtual Cities Cities { get; set; }
    }


    public class Cities
    {
        [Key]
        public int CityId { get; set; }
        [Required]
        public string CityDesc { get; set; }

        public virtual ICollection<Streets> Streets { get; set; }

        public virtual ICollection<Parkings> Parkings { get; set; }
    }

    public class Streets
    {
        [Key]
        public int StreetId { get; set; }

        public int CityId { get; set; }
        [Required]
        public string StreetDesc { get; set; }

        [ForeignKey("CityId")]
        public virtual Cities Cities { get; set; }

    }

这个想法是-城市有很多街道,街道有很多停车场。最后的目标是引入一个包含以下内容的Parking对象:

dbo.Parkings.ParkId、dbo.Parkings.ParkStartDate、dbo.Parkings.ParkEndDate、dbo.Cities.CityDesc、dbo.Streets.StreetDesc

(输入新停车位的表单将包含: StartDate、EndDate、CityDesc、StreetDesc)

在这个类中,我首先尝试在数据库中植入数据:

代码语言:javascript
复制
 public class DatabaseInitializer : DropCreateDatabaseIfModelChanges<DatabaseContext>
    {
        protected override void Seed(DatabaseContext context)
        {
            base.Seed(context);

            //
            context.Cities.Add(
        new Cities() { CityId = 1, CityDesc = "Tel Aviv" }
        );
            context.Cities.Add(
    new Cities() { CityId = 2, CityDesc = "Ramat Gan" }

    );

            context.Streets.Add(
                new Streets() { StreetId = 1, CityId = 1, StreetDesc = "Pinkas"}
                );

            context.Streets.Add(
              new Streets() { StreetId = 2, CityId = 2, StreetDesc = "Bialik" }
              );

            context.Parkings.Add(
              new Parkings() { ParkStreetId = 1, ParkCityId = 1, StartDate = "2018-01-17", EndDate = "2018-01-17" }
              );

            context.Parkings.Add(
          new Parkings() { ParkStreetId = 2, ParkCityId = 2, StartDate = "2018-01-17", EndDate = "2018-01-17" }
          );

            context.SaveChanges();
        }
    }

但是我得到了这个错误:

代码语言:javascript
复制
"exceptionMessage": "The ForeignKeyAttribute on property 'Cities' on type 'BeraleBack.Models.entites+Parkings' is not valid. The foreign key name 'CityId' was not found on the dependent type 'BeraleBack.Models.entites+Parkings'. The Name value should be a comma separated list of foreign key property names.",
  "exceptionType": "System.InvalidOperationException",

首先我想知道,根据我给出的信息,我的配置是否正确。其次,我应该如何播种它?

我完全是一个新手,没有遇到任何有用的教程..

非常感谢!

EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2018-01-18 02:17:36

请容忍我,因为我现在更多地使用DBFirst,但看起来您的实体框架找不到您的外键属性。

将Parkings与Streets进行比较

代码语言:javascript
复制
public class Streets
    {
        [Key]
        public int StreetId { get; set; }

        public int CityId { get; set; } //Property which foreign key is assoctiated with
        [Required]
        public string StreetDesc { get; set; }

        [ForeignKey("CityId")]
        public virtual Cities Cities { get; set; }

    }

但是您在Parkings实体中没有此属性

代码语言:javascript
复制
public class Parkings
    {
        [Key]
        public int ParkId { get; set; }
        [Required]
        public string StartDate { get; set; }
        [Required]
        public string EndDate { get; set; }  

        public int ParkStreetId { get; set; }

        public int CityId{ get; set; }

        [ForeignKey("CityId")]
        public virtual Cities Cities { get; set; }
    }
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/48307016

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档