找不到关于它的完整的教程,所以我在这里尝试。我在VS 2017中工作,我有3张桌子。主要的一个是ParkDB:
[Table("Parking")]
public class ParkDB
{
[Key]
[Column("ParkID")]
public int Id { get; set; }
[Required]
public string ParkStartDate { get; set; }
[Required]
public string ParkEndDate { get; set; }
[Required]
[ForeignKey("CityID")]
public int ParkCityID { get; set; }
[Required]
[ForeignKey("StreetID")]
public int ParkStreetID { get; set; }
}CitiesDB:
[Table("Cities")]
public class CitiesDB
{
[Key]
public int CityID { get; set; }
[Required]
public string CityDesc { get; set; }
}街道表:
[Table("Streets")]
public class StreetsDB
{
[Key]
public int StreetID { get; set; }
[Required]
[ForeignKey("CityID")]
public int CityID { get; set; }
[Required]
public string StreetDesc { get; set; }
}我的目标是能够获得一个包含以下字段的对象:
ParkID,ParkStartDate,ParkEndDate -来自ParkDb,
CityDesc -来自CitiesDB,
StreetDesc -来自StreetDB,所有这些都组合在一个停车对象中。
我正在读这篇文章:LINK
但我完全不确定哪种方法对我有效。此外,任何有关如何进行实际调用/查询的文章的链接都将不胜感激。似乎找不到什么有用的东西。
谢谢!
发布于 2018-01-15 20:03:56
您要应用导航属性,但配置的数据批注无效。我像这样修改了实体;
[Table("Parking")]
public class ParkDB
{
[Key]
[Column("ParkID")]
public int Id { get; set; }
[Required]
public string ParkStartDate { get; set; }
[Required]
public string ParkEndDate { get; set; }
[Required]
public int ParkCityID { get; set; }
[ForeignKey("ParkCityID")]
public virtual CitiesDB City { get; set; }
}
[Table("Cities")]
public class CitiesDB
{
[Key]
public int CityID { get; set; }
[Required]
public string CityDesc { get; set; }
public virtual ICollection<StreetsDB> Streets { get; set; }
public virtual ICollection<ParkDB> Parks { get; set; }
}
[Table("Streets")]
public class StreetsDB
{
[Key]
public int StreetID { get; set; }
[Required]
public int CityID { get; set; }
[Required]
public string StreetDesc { get; set; }
[ForeignKey("CityID")]
public virtual CitiesDB City { get; set; }
}我配置了ForeignKey属性并从ParkDB实体中删除了ParkStreetID,因为您应该将它导航到City属性上。在这种情况下,CitiesDB实体是与其他实体相关联的中心实体。
最后,我提供了一些导航示例,以提供更好的理解;
ParkDBs.Select(x => x.City);//Get City by ParkDBs
CitiesDBs.SelectMany(x => x.Parks);//Get Parks by CitiesDB
CitiesDBs.SelectMany(x => x.Streets);//Get Streets by CitiesDB
StreetsDBs.Select(x => x.City);//Get City by StreetsDBs
StreetsDBs.SelectMany(x => x.City.Parks);//Get Parks of City which is assosicated with StreetsDB entityhttps://stackoverflow.com/questions/48262048
复制相似问题