gpt4 book ai didi

c# - 将 List 添加到 EF
转载 作者:行者123 更新时间:2023-11-30 12:48:33 24 4
gpt4 key购买 nike

我正在玩 EF,试图找到方向。现在我正在为网站编写二十一点游戏。问题是,每当我从数据库中提取 GameState 时,playerHanddealerHandtheDeckdealerHidden 属性为空。

public class GameState
{
[Key]
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public int gameSession { get; set; }
public int playerScore { get; set; }
public int dealerScore { get; set; }
public Deck theDeck { get; set; }
public List<Cards> playerHand { get; set; }
public List<Cards> dealerHand { get; set; }
public Cards dealerHidden { get; set; }
public bool gameOver { get; set; }
}

public class Cards
{
[Key]
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int cardId { get; set; }
public string cardName { get; set; }
public int cardValue { get; set; }
}

public class GameStateContext : DbContext
{
public GameStateContext() : base("MyContext")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
modelBuilder.Entity<GameState>().HasRequired(e => e.theDeck);
modelBuilder.Entity<GameState>().HasRequired(e => e.dealerHand).WithMany().WillCascadeOnDelete(false);
modelBuilder.Entity<GameState>().HasRequired(e => e.playerHand).WithMany().WillCascadeOnDelete(false);
modelBuilder.Entity<GameState>().HasOptional(e => e.dealerHidden);
modelBuilder.Entity<Deck>().HasRequired(e => e.cards).WithMany().WillCascadeOnDelete(false);
base.OnModelCreating(modelBuilder);
}

public DbSet<GameState> GameStates { get; set; }
public DbSet<Deck> Decks { get; set; }
public DbSet<Card> Cards { get; set; }
}

卡片和套牌 table 已填充。我哪里错了?

最佳答案

我认为您要么需要通过将它们设为虚拟属性来使您的导航属性(即 playerHand、dealerHand、theDeck 和 dealerHidden 可延迟加载),要么您需要在查询 GameState 时预先加载它们。

myDBContext.GameStates.Include("playerHand").Include("dealerHand").Include("theDeck").Include("dealerHidden").where(...);

下面是关于 Entity Framework 如何处理相关对象的一个​​体面的解释:

http://msdn.microsoft.com/en-us/data/jj574232.aspx

关于c# - 将 List<object> 添加到 EF,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/13893315/

24 4 0