我刚刚开始学习实体框架代码。我正在尝试使用.Include语法来获取相关对象。我已经能够成功地将对象从一对多关系中检索到列表中,但无法使其从多对一关系中工作。所以我有一首歌,它有一个相关的管弦乐队和一个相关的歌手
对象定义
public class Song
{
[Key]
public int Id { get; set; }
public string Name { get; set; }
[ForeignKey("OrchestraId")]
public Orchestra Orchestra { get; set; }
public int OrchestraId { get; set; }
[ForeignKey("SingerId")]
public Singer Singer { get; set; }
public int SingerId { get; set; }
public int Genre { get; set; }
public string Year { get; set; }
public Song()
{
this.Orchestra = new Orchestra();
this.Singer = new Singer();
}
}
public class Singer
{
public int Id { get; set; }
public string Name { get; set; }
}
public class Orchestra
{
public int Id { get; set; }
public string Name { get; set; }
}我有一个上下文对象
public class POCContext : DbContext
{
public DbSet<Singer> Singers { get; set; }
public DbSet<Orchestra> Orchestras { get; set; }
public DbSet<Song> Songs { get; set; }
}我用来获得一首歌曲的代码如下
public Song GetSong(int songId)
{
Song song = new Song();
song = _context.Songs.Include(s => s.Orchestra)
.Include(s => s.Singer)
.Single(s => s.Id == songId);
return song;
}当我在return语句上设置断点并查看歌曲时,填充了歌曲对象,但没有填充歌手或管弦乐队对象。
我看了一下下面的相关问题here,但我还没能找出我做错了什么。任何帮助都是非常感谢的。
致敬卡尔
发布于 2018-08-07 11:47:27
Orchestra和Singer应该是虚拟的。
public virtual Orchestra Orchestra { get; set; }
public virtual Singer Singer { get; set; }下面是一个示例配置:
public class Song
{
[Key]
public Guid Id { get; set; }
public string Title { get; set; }
//navigation property
public virtual List<Singer> Singers { get; set; }
}
public class Singer
{
[Key]
public int Id { get; set; }
[ForeignKey("Song")]
[Required]
public string SongId { get; set; }
[Required]
public string Name { get; set; }
//navigation property
public virtual Song Song { get; set; }
}https://stackoverflow.com/questions/51718526
复制相似问题