How to update an existing item in SQL database using linq?

Question

i would like to update an existing item in a sql database using linq.
i have tried with this.

    public void UpdateFoodDrinkTobacco(int id, string preservationTechniqueCodes, bool isHomogenised)
        {
            var item = (from item in _db.FoodDrinkAndTobacco 
                        where item.id equals id 
                        select item.isHomogenised);
            item = isHomogenised;


            _db.SubmitChanges();
        }

but this is not working for me.
Hope some of you have a suggestion on how to do this.

Do you have any exception?

Valentin
– Valentin

2015-12-21 13:03:31 +00:00
Commented Dec 21, 2015 at 13:03 — Valentin
– Valentin, Commented Dec 21, 2015 at 13:03

Code_Viking · Accepted Answer · 2015-12-21 13:13:04Z

1

You could do somthing like this.

public void UpdateFoodDrinkTobacco(int id, string preservationTechniqueCodes, bool isHomogenised)
    {
        var item = _db.FoodDrinkTobaccos.Where(i => i.id == id).Select(i => i);
        if (item == null) return;

        item.preservationTechniqueCodes = preservationTechniqueCodes;
        item.isHomogenised = isHomogenised;

        _db.SubmitChanges();
    }

like this you can change all of the parameters. And i think i looks a little better when you use lambda expressions instead of the other way you did it. Hope this works.

edited Dec 21, 2015 at 13:13

answered Dec 21, 2015 at 13:03

Code_Viking

6282 gold badges8 silver badges26 bronze badges

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

1 Comment

Keith Hall Over a year ago

item will never be null because you have used Single and not SingleOrDefault, therefore if it doesn't find it then it will throw an exception.

Collectives™ on Stack Overflow

How to update an existing item in SQL database using linq?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related