在ASP.NET MVC中使用实体框架实现一对多关系数据库播种

// Seed.cs
public class Seed
{
    public int ID { get; set; }
    public string Name { get; set; }
    // 其他字段...
}

// PlantingRecord.cs
public class PlantingRecord
{
    public int ID { get; set; }
    public int SeedID { get; set; }
    public DateTime PlantingDate { get; set; }
    // 其他字段...

    // 导航属性，表示与种子的关联
    public virtual Seed Seed { get; set; }
}

public class ApplicationDbContext : DbContext
{
    public DbSet<Seed> Seeds { get; set; }
    public DbSet<PlantingRecord> PlantingRecords { get; set; }

    // 构造函数
    public ApplicationDbContext() : base("DefaultConnection") { }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        // 定义种子和播种记录之间的一对多关系
        modelBuilder.Entity<Seed>()
            .HasMany(s => s.PlantingRecords)
            .WithRequired(pr => pr.Seed)
            .HasForeignKey(pr => pr.SeedID);

        base.OnModelCreating(modelBuilder);
    }
}

<connectionStrings>
    <add name="DefaultConnection" connectionString="YourConnectionStringHere" providerName="System.Data.SqlClient" />
</connectionStrings>

// 示例：在控制器中获取种子和对应的播种记录
public class SeedController : Controller
{
    private ApplicationDbContext db = new ApplicationDbContext();

    public ActionResult Index()
    {
        var seeds = db.Seeds.Include(s => s.PlantingRecords).ToList();
        return View(seeds);
    }

    // 其他操作方法...
}