Update related entities Entity Framework DbContext

Question

I'm using EF with a DbContext and several POCO entities

     public class Customer
    {
        public int ID { get; set; }

        public string CompanyName { get; set; }

        public string Address { get; set; }

        public string Email { get; set; }

        public string Phone { get; set; }

        public List<Project> Projects { get; set; }

        public List<ContactPerson> ContactPersons { get; set; }
}

    public class ContactPerson
        {
            public int ID { get; set; }

            public string Name { get; set; }

            public string Email { get; set; }

            public string Phone { get; set; }
}



public class Quotation
    {
        public int ID { get; set; }

        public string QuotationName { get; set; }

        public DateTime DateCreated { get; set; }

        public ContactPerson ContactPersonAssigned { get; set; }

        public string OurReference { get; set; }

        public string QuotationDataString { get; set; }
}

Now, I need to update a quotation

        using (var myDB = new MyDB())
        {   
            Quotation quotationDB = myDB.Quotations.Find(this.quotation.ID);
            quotationDB.QuotationName = textBox_name.Text;
            quotationDB.OurReference = textBox_quotedBy.Text;
            quotationDB.ContactPersonAssigned = null;
            quotationDB.ContactPersonAssigned = myDB.ContactPersons.Find(((ContactPerson)this.comboBox_YourReference.SelectedItem).ID);
            quotationDB.DateCreated = this.dateTimePicker_dateQuoted.Value;

 myDB.SaveChanges();
                }

All the fields in quotationDB will update, except for quotationDB.ContactPersonAssigned which will never be updated. Why? The actual object updates correctly, but no changes are save into the database.

score 1 · Accepted Answer · answered Sep 01 '11 at 14:16

1

you need to define navigation properties as virtual

 public virtual ContactPerson ContactPersonAssigned { get; set; }

answered Sep 01 '11 at 14:16

Jayantha Lal Sirisena

21,216
11
71
92

I tried this without results. Anyway, why should it be virtual? – Francesco Sep 01 '11 at 15:13
Fixed. I was doing another mistake aswell – Francesco Sep 02 '11 at 07:46
Great .Then update your post with the other mistake. It will be a help for others. – Jayantha Lal Sirisena Sep 02 '11 at 07:50

Update related entities Entity Framework DbContext

1 Answers1