开发者

Updating tables with Linq expressions

开发者 https://www.devze.com 2023-01-01 18:13 出处:网络
Most of the examples I\'ve found deal with Linq to entities, which is not what I need. I have a standard DataTable 开发者_JAVA技巧which I need to modify before returning to the caller. I can iterate o

Most of the examples I've found deal with Linq to entities, which is not what I need. I have a standard DataTable 开发者_JAVA技巧which I need to modify before returning to the caller. I can iterate over the normal Table.Rows collection or do something like this with the new extension methods:

foreach (var x in table.AsEnumerable()) {
    if (x.Field<int>("SomeField") > SomeValue)
        x.SetField<string>("OtherField", "OtherValue");
}

But I'm still manually looping through the entire row collection. Not necessarily a big deal, but I'm wondering if there's a more elegant way to accomplish this with Linq somehow, in the sense that I need to create an expression that iterates over the results of a query and performs an arbitrary action, rather than just select elements from the container being enumerated.


I think what you're wondering is if there's some sort of extension method like

stuff.ForEach(x => x.Value = "new value"); 

Unfortunately, there is no such thing. When I began using LINQ to SQL, I wanted the same thing. But unfortunately, you must use a for loop.

0

精彩评论

暂无评论...
验证码 换一张
取 消