我有三张桌子,
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)
在这个类中,我首先尝试在数据库中植入数据:
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();
}
}但是我得到了这个错误:
"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",首先我想知道,根据我给出的信息,我的配置是否正确。其次,我应该如何播种它?
我完全是一个新手,没有遇到任何有用的教程..
非常感谢!
发布于 2018-01-18 02:17:36
请容忍我,因为我现在更多地使用DBFirst,但看起来您的实体框架找不到您的外键属性。
将Parkings与Streets进行比较
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实体中没有此属性
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; }
}https://stackoverflow.com/questions/48307016
复制相似问题