Question

这是我的代码:

var items = tableInDatabase.All("WHERE [Order] > " + order);
foreach (var i in items.ToArray())
{
    i.Order = 7;
}
tableInDatabase.Save(items.ToArray());

However, when the breakpoint comes to the last line (after the foreach loop), every element of items has an order the same as before (not 7). Why is this happening? While still in the loop, i has an order of 7.

我使用大规模, 这是官方网页上的例子:

var table = new Products();
var drinks = table.All("WHERE CategoryID = 8");
foreach(var item in drinks.ToArray()){
    item.CategoryID = 12;
}
table.Save(drinks.ToArray());

我也试过:

foreach (var i in items.ToArray())
{
    tableInDatabase.Update(i, i.Id);
}

什么都没有

返回类型 od 表InDatabase 是类表InDatabase。这是定义 :

public TableInDatabase() : base(connectionString, "System.Data.SqlClient", "TableInDatabase", "Id") { }

Answer 1

使用此代码 :

var items = tableInDatabase.All("WHERE [Order] > " + order);
var array = items.ToArray();
foreach (var i in array)
{
    i.Order = 7;
}
tableInDatabase.Save(array);

Answer 2

To Array () create a new option as said by Romil, "https://github.com/robconery/massive" rel= "nofollow" >Massive ,你也许可以按Adam的话做,但这个选项可以产生两个变量。你可以尝试以下两个变量。

var items = tableInDatabase.All("WHERE [Order] > " + order).ToArray();
foreach (var i in items)
{
    i.Order = 7;
}
tableInDatabase.Save(items);

这在大规模例子中是一个已知的问题,据报导这里

友情链接