Update in LINQ

[sds814]

Just wondering how developers are working around the issue that LINQ doesn't have an update command.

I've been having it to do it in 2 commands:

1) select the items that meet the criteria
2) do a foreach on the items selected and set that criteria to the specified value.

for example,

IEnumerable<IDropDownItem> LdItems;
                    LdItems =
                    from ddList in loCheckCriteria.LobjList
                    select ddList;

                    foreach (IDropDownItem LdItem in LdItems)
                    {
                       LdItem.IsSelected = true;
}

thanks for the help

 

[KDavie]

linq does provide the ability to update... here is an example....

var items = db.TableName.Single(i => i.id == 123);
items.ColumnName1 = "some value";
items.ColumnName2 = "some other value";
db.SubmitChanges();

Hope this helps.