Saving a list of entities to the db - MVC

Question

I think I almost have this working, but I cant figure out how to finish.

Model:

 public class Location
 {
    public int LocationId { get; set; }
    public string SiteCode { get; set; }
    public int PersonId { get; set; }
    public int IncidentId { get; set; }
  }

View Model

    public List<Location> LocationList { get; set; }

Controller:

    [HttpPost]
    public ActionResult AddRecord(RecordViewModel model)
    {
        if (ModelState.IsValid)
        {
            Location location;
            foreach (var loc in model.LocationList)
            {
                location = new Location
                {
                    PersonId = model.PersonId,
                    SiteCode = loc.SiteCode,
                    IncidentId = loc.IncidentId
                };
            }

            using (var db = new MyEntities())
            {
                db.Order.AddObject(incident);
                db.Location.AddObject(location);
                db.Comment.AddObject(comment);

                db.SaveChanges();
            }

The line db.Location.AddObject(location); is receiving empty. How do I get the location list from the foreach, to the db?

Is the action decorated with [HttpPost]? Also, what's TrespassEntities supposed to be? — Theodoros Chatzigiannakis
– Theodoros Chatzigiannakis, Commented Jun 20, 2013 at 17:01
Yes it Post. Name changed to MyEntities, it is the EF db connection. — BattlFrog
– BattlFrog, Commented Jun 20, 2013 at 17:04
You should create a repo project to handle database related stuff. — JsonStatham
– JsonStatham, Commented Feb 2, 2016 at 9:51

David L · Accepted Answer · 2013-06-20 17:15:19Z

You're so close!

// create a new list of your entity Location (may not be in namespace Data)
var locationList = new List<Data.Location>();
foreach (var loc in model.LocationList)
{
    var location = new Data.Location
    {
        PersonId = model.PersonId,
        SiteCode = loc.SiteCode,
        IncidentId = loc.IncidentId
    };
    locationList.Add(location);
}

using (var db = new MyEntities())
{
    db.Order.AddObject(incident);

    foreach (var item in LocationList)
    {
        db.Location.AddObject(location);
    }
    db.Comment.AddObject(comment);

    db.SaveChanges();
}

OR: since you already have the LocationList on your model, use that instead

using (var db = new MyEntities())
{
    db.Order.AddObject(incident);

    foreach (var loc in model.LocationList)
    {
        var location = new Data.Location
        {
            PersonId = model.PersonId,
            SiteCode = loc.SiteCode,
            IncidentId = loc.IncidentId
        };

        db.Location.AddObject(location);
    }
    db.Comment.AddObject(comment);

    db.SaveChanges();
}

Ellix4u · Accepted Answer · 2017-08-22 08:23:21Z

0

You can simply use addrange.

db.YourTable.AddRange(YourList)
db.SaveChanges();

db.Location.AddRange(LocationList)
db.SaveChanges();

answered Aug 22, 2017 at 8:23

Ellix4u

6166 silver badges9 bronze badges

Collectives™ on Stack Overflow

Saving a list of entities to the db - MVC

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related