Databases
StackOverflow2013
Postsdbo
PO"EF foreign key (or entity?) not cascading/updating
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO"EF foreign key (or entity?) not cascading/updating
    primarykey
    data
    text
    <p>I am using the WebAPI in MVC4. I have a simple form which submits data to the API via a PUT request. The data arrives and is serialized fine and everything looks wonderful, except that anywhere there is a foreign key is not getting updated. And yes, the foreign key exists.</p> <p>I have the following classes: </p> <pre><code>public class TriageRecord { [Key] public Int64 PKEY { get; set; } public DateTime DateAdded { get; set; } public DateTime DateUpdated { get; set; } public Int64? RecordSource_Id { get; set; } public Int64? AssignedVolunteer_Id { get; set; } public string FacebookID { get; set; } public Int64? VANID { get; set; } public Int64? NationBuilderID { get; set; } public DateTime? DateVanSubmitted { get; set; } public Int64? FollowUpLevel_Id { get; set; } public bool? Complete { get; set; } public string First { get; set; } public string Mid { get; set; } public string Last { get; set; } public string Email { get; set; } public string Address1 { get; set; } public string City { get; set; } public string State { get; set; } public string Zip5 { get; set; } public string HomePhone { get; set; } public string CellPhone { get; set; } public Int32? EmployeeStatus { get; set; } public string StoreNumber { get; set; } public virtual WorkArea WorkArea { get; set; } //put your focus here public virtual Department Department { get; set; } public virtual Shift Shift { get; set; } } </code></pre> <p>Here is the WorkArea class which I am updating via my form.</p> <pre><code>public class WorkArea { [Key] public Int64 Id { get; set; } [StringLength(200)] public string WorkAreaName { get; set; } } </code></pre> <p>Here is the JSON I am posting which arrives very nicely to my API Controller:</p> <pre><code> var saveRecord = function() { var record = { "PKEY": $("#PKEY").val(), "DateAdded": $("#DateAdded").val(), "DateUpdated": "@DateTime.Now.ToString()", "First": $("#First").val(), "Mid": $("#Mid").val(), "Last": $("#Last").val(), "RecordSource_Id": $("#RecordSource_Id").val(), "AssignedVolunteer_Id": $("#AssignedVolunteer_Id").val(), "FacebookID": $("#FacebookID").val(), "VANID": $("#VANID").val(), "NationBuilderID": $("#NationBuilderID").val(), "DateVanSubmitted": Date.now(), "FollowUpLevel_Id": $("#FollowUpLevel_Id").val(), "Complete": $("#Complete").val(), "Email": $("#Email").val(), "Address1": $("#Address1").val(), "City": $("#City").val(), "State": $("#State").val(), "Zip5": $("#Zip5").val(), "HomePhone": $("#HomePhone").val(), "CellPhone": $("#CellPhone").val(), "EmployeeStatus": $("#EmployeeStatus").val(), "StoreNumber": $("#StoreNumber").val(), "WorkArea": { "Id": 1, "WorkAreaName": "GM" }, "Department": $("#Department").val(), "Shift": $("#Shift").val() }; </code></pre> <p>It is serialized and it arrives to my controller where I can see when I set my breakpoint that the WorkArea (Models.WorkArea) is populated with Id = 1 &amp; WorkAreaName = "GM"</p> <p>So this is my controller:</p> <pre><code> public HttpResponseMessage PutTriageRecord(long id, TriageRecord triagerecord) { if (id == triagerecord.PKEY) //breakpoint here shows triagerecord contains workarea values { db.Entry(triagerecord).State = EntityState.Modified; try { db.SaveChanges(); //changes get saved for everything (ie, first name) but not workarea... } catch (DbUpdateConcurrencyException) { return Request.CreateResponse(HttpStatusCode.NotFound); } return Request.CreateResponse(HttpStatusCode.OK); } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } } </code></pre> <p>Everything is updated in my TriageRecord except for WorkArea... Why?</p> <p>Update: NOT WORKING. This is what I added to my controller... it just keeps creating a ton of entires in the WorkAreas table.</p> <pre><code> public HttpResponseMessage PutTriageRecord(long id, TriageRecord triagerecord) { if (id == triagerecord.PKEY) //breakpoint here shows triagerecord contains workarea values { db.Entry(triagerecord).State = EntityState.Modified; try { db.TriageRecords.Attach(triagerecord); //attach db.Entry(triagerecord.WorkArea).State = EntityState.Added; //add db.SaveChanges(); //WORKS! } catch (DbUpdateConcurrencyException) { return Request.CreateResponse(HttpStatusCode.NotFound); } return Request.CreateResponse(HttpStatusCode.OK); } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USRay Suelzer
    1. USRay Suelzer
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO"EF foreign key (or entity?) not cascading/updating
      1. This table or related slice is empty.
      1. VTUpMod
    1. COPlease focus the question. What does JSON or WebAPI have to do with Foreign Keys? I suspect the question is about a particular DAL/ORM ..
      singulars
      1. PO"EF foreign key (or entity?) not cascading/updating
      1. This table or related slice is empty.
    2. COI'm posting via a PUT in Json format to Web-API. It's likely someone else has had this problem before.
      singulars
      1. PO"EF foreign key (or entity?) not cascading/updating
      1. USRay Suelzer
    3. COJSON and PUT are immaterial once the data is received/decoded on the server. They are merely the means to the problem, but not the problem itself.
      singulars
      1. PO"EF foreign key (or entity?) not cascading/updating
      1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload