Update all column records in mvc5 using linq query

Question

I want to update all the records of a particular column in MVC5 using linq query

var PriceRecord = db.tblPurchasePrices.Where(z => z.ID == id).SingleOrDefault();
var PurchasePriceList = db.tblPurchasePrices.Where(z => z.SizeID == PriceRecord.SizeID && z.ProductID == PriceRecord.ProductID && z.CategoryID == PriceRecord.CategoryID).ToList();

        foreach (var item in PurchasePriceList)
        {
            item.IsActive = false;
            db.SaveChanges();
        }

i do not want to use foreach loop to update record one by one and save changes. i want all values in a particular column to update in one go.

Does this answer your question ? stackoverflow.com/questions/21592596/… — Shahriyar
– Shahriyar, Commented Mar 19, 2021 at 17:22
i dont not want to use foreach loop, want to update all records using linq query like db.tblPurchasePrices.Where(z => z.ID == id).ToList().value(v=> v.isActive = false); db.SaveChanges(); — Taha Ahmed
– Taha Ahmed, Commented Mar 20, 2021 at 8:34

Serge · Accepted Answer · 2021-03-19 21:43:41Z

0

Try this code, you can save all changes in one trip to DB:

 foreach (var item in PurchasePriceList)
        {
            item.IsActive = false;
          db.Entry(item).State = EntityState.Modified;
         }
 db.SaveChanges();

or another syntax:

foreach (var item in PurchasePriceList)
        {
            item.IsActive = false;
          db.Entry(item).Property(i=> i.IsActive).IsModified = true;
         }
 db.SaveChanges();

Another way to update bulk data that maybe faster (maybe not) is to create a stored procedure with PriceRecord parameters and execute like this :

db.Database.ExecuteSqlCommand("stored_procedure_name @params", params);

edited Mar 19, 2021 at 21:43

answered Mar 19, 2021 at 17:33

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

5 Comments

Gert Arnold Over a year ago

"i do not want to use foreach loop". They're looking for bulk update. Also, neither alternative is necessary.

Serge Over a year ago

I am sorry, but I am not saving records one by one as PO. I modified the needed records at first , after this in one trip saved all changes. This I call bulk modifying. I can' t imagine how it canbe done another way.

Gert Arnold Over a year ago

OK, that's a difference, but the other added statements are redundant or even worse. I still think they want bulk update ("i want all values in a particular column to update in one go").

Taha Ahmed Over a year ago

i dont not want to use foreach loop, want to update all records using linq query like db.tblPurchasePrices.Where(z => z.ID == id).ToList().value(v=> v.isActive = false); db.SaveChanges();

Serge Over a year ago

How do you think linq works? Do you think they have special select operators? Linq converts all the operators to ForEach or to For . Linq it is just the way to write the shorter code.

Collectives™ on Stack Overflow

Update all column records in mvc5 using linq query

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related