我正在使用asp.net core 6 MVC(visual studio 2022(进行CRUD操作。为此,我完成了县创建、更新、删除、读取操作。但现在我正在尝试州与县数据库的级联下拉。当我写";公共虚拟CountryMaster CountryMaster";以及";公共虚拟ICollection StateMasters";在state和country的模型中,它给了我sqlException的错误:列名"CountryMasterCountryId"无效。这是CountryMaster模型''
{
[Key]
public int CountryId { get; set; }
[Display(Name = "Country Name")]
[Required(ErrorMessage ="Please Enter Country")]
public string CountryName { get; set; } = null!;
[Display(Name ="When Entered")]
public DateTime WhenEntered { get; set; } = DateTime.UtcNow;
[Display(Name ="When Modified")]
public DateTime WhenModified { get; set; }= DateTime.UtcNow;
public virtual ICollection<StateMaster> StateMasters { get; set; }
} '''
这是StateMasters模型''
{
[Key]
public int StateId { get; set; }
[Required(ErrorMessage ="Please Enter State Name")]
public string StateName { get; set; } = null!;
[Display(Name = "Country Name")]
public int CountryId { get; set; }
[Display(Name = "When Entered")]
public DateTime WhenEntered { get; set; } = DateTime.UtcNow;
[Display(Name = "When Modified")]
public DateTime WhenModified { get; set; } = DateTime.UtcNow;
public virtual CountryMaster CountryMaster { get; set; }
}
"我做什么?在.net core 6 MVC中,Icollection不同吗?
添加到模型中的属性在数据库中不存在。尝试更新您的数据库:
从"工具"菜单中,选择"NuGet Package Manager">Package Manager控制台。
在Package Manager控制台(PMC(中,输入以下命令:
1:更改迁移名称
Add-Migration xxxx
2:将数据库更新为上一个命令创建的的最新迁移
Update-Database