mvc3 use entity to update many database records

Question

I am trying to use entity to update many records up to 30 if the conditions inside the statement match but i am having an issue finding the correct method to use at the end what I have is this

public ActionResult Edit(profile profile)
{
  //change all records where getid== x.registrationID
  var getprofile =
    (from x in db.Articles where getid == x.RegistrationID select x).Any();

  getprofile.firstname = profile.firstname;
  getprofile.lastname = profile.lastname;
}

The error i get is on getprofile.firstname and getprofile.lastname saying the bool does not contain a definition for firstname or lastname. If i put in FirstorDefault() everything works fine but of course it only changes the 1st record...

How can I change many records?

Nick Butler · Accepted Answer · 2013-01-14 20:49:07Z

2

You can use ToList() to get a collection of Articles:

List<Article> getprofiles = ( from x in db.Articles ... ).ToList();

foreach( Article getprofile in getprofiles )
{
  getprofile.firstname = profile.firstname;
  getprofile.lastname = profile.lastname;
}

db.SaveChanges();

This queries the database, gets the matching Article rows and puts them in a collection - a List<Article>

You can then modify the objects in the collection and finally call db.SaveChanges() to update the database.

answered Jan 14, 2013 at 20:49

Nick Butler

24.5k4 gold badges51 silver badges72 bronze badges

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

1 Comment

phil soady Over a year ago

+1, .any() returns bool so you cant edit the result. it tells you there were matching records yes or no. Get a list of matching records, edit the list and save result.

tam tam · Accepted Answer · 2013-01-14 21:11:50Z

0

 var objRD = objBS.Articles.Where(c => c.RegistratinID.Equals(getID));

        if (objRD.Count() > 0)
        {
            foreach (ReportingData objR in objRD)
            {
                objR.firstname = profile.firstname;
                objR.lastname = profile.lastname;

            }
        }
        objBS.SaveChanges();

edited Jan 14, 2013 at 21:11

answered Jan 14, 2013 at 21:01

tam tam

1,9002 gold badges26 silver badges51 bronze badges

Collectives™ on Stack Overflow

mvc3 use entity to update many database records

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related