EF Code First Query and assign without savechanges

new ProductReadModel
{
    Nr = (nr++).ToString(),
    Abbreviation = "Ewb",
    Name = "Some product开发者_运维技巧",
    BodyMaterial = context.BodyMaterialReadModels.FirstOrDefault(b => b.Abbreviation == "EDTA")
}

During database initialization I try to fill my tables with the EF code first seeder. In one of my seeders I add all the bodymaterials. In this one I try to relate these bodymaterials to products. When I debug I see my bodymaterial collections counts 14 items. However after going through this code the BodyMaterial property is null.

Any suggestions?

---

You are executing database query against empty database. Try this instead:

BodyMaterial = context.BodyMaterialReadModels.Local.FirstOrDefault(...);

or use your BodyMaterialCollection directly. The set exposed on the context is entry point to the database not to your not persisted entities (except Local property).