Update Array of Objects with Entity Framework

Question

I am sending an array of object from a web page to C# via ajax. I am trying to update my table with the array of objects Please help.

This is the controller

public HttpResponseMessage Update([FromBody]List<Model> json)
{
    var result = db.Models.ToList();

    return response;
}

This is the Model class

    public int ID {get; set;}

    public string ModelNumber { get; set; }

    public string Category { get; set; }

    public string PartNumber { get; set; }

Here is a sample of the json array

var json = [{ID:1,ModelNumber: gw234, Category: A, Partnumber: rty466m},{ID:2,ModelNumber: kw274, Category: B, Partnumber: tbg55},{ID:3,ModelNumber: gr456, Category: A, Partnumber: htg555}]

Luca · Accepted Answer · 2017-02-01 18:49:00Z

2

Assuming array of objects are type Entity(Model), you could set the entity state to modified

json.ForEach(m=> db.Entry(m).State = EntityState.Modified);

db.SaveChnages();

For more information check this out https://msdn.microsoft.com/en-us/data/jj592676.aspx

edited Feb 1, 2017 at 18:49

Luca

1,6262 gold badges23 silver badges26 bronze badges

answered Feb 1, 2017 at 17:19

praveen

863 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Erik Philips Over a year ago

Simply stating try this is a very poor answer. Why does this answer work and where do I get more information about these methods I'm suppose to call?

Chamith Saranga · Accepted Answer · 2017-02-02 01:30:57Z

1

 using System.Data.Entity.Migrations;  

 public HttpResponseMessage Update([FromBody]List<Model> json)
    {
        var result = db.Models.ToList();

        // create object from dbContext
        var db = new MyDbContext();

        // add entities on dbContext,
        db.SomeRepo.AddOrUpdate(json); 
        // commit the change on db
        db.Save();  

        return response;
    }

AddOrUpdate method is in under using System.Data.Entity.Migrations; if entity has id ,it will execute update else add

cheers

answered Feb 2, 2017 at 1:30

Chamith Saranga

405 bronze badges

Comments

Shahzad Khan · Accepted Answer · 2017-07-13 09:28:27Z

-1

Please follow the below link.

Updating Related Data with the Entity Framework in an ASP.NET MVC Application

answered Jul 13, 2017 at 9:28

Shahzad Khan

5303 silver badges14 bronze badges

Collectives™ on Stack Overflow

Update Array of Objects with Entity Framework

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related