BLToolkit 更新为非 IQueryable

发布于 2024-12-03 21:45:14 字数 572 浏览 0 评论 0原文

到目前为止，如果我想更新表，我正在使用类似的东西。

var myData = from t1 in db.Table1
where ...
select new { do some math here };

然后我会调用

myData.Update( db.Table2, x => new Table2
{
    update columns here
}

这效果很好，但现在我需要将 myData 查询转换为 List() ，以便稍后我可以在另一个更新调用中使用相同的数据。 IQueryable 的问题是，当我稍后在代码中使用此“myData”第二次调用更新时，它包含两次更新之间受影响的数据，并且我希望数据与调用第一次更新之前的数据相同。

所以我需要

var myData = (from t1 in db.Table1
where ...
select new { do some math here }).ToList();

使用与之前相同的调用来更新表。

原文

So far I was using something like this if I wanted to update table.

var myData = from t1 in db.Table1
where ...
select new { do some math here };

and then I would call

myData.Update( db.Table2, x => new Table2
{
    update columns here
}

That works great, but now I need to convert the myData query into List() so I can use that same data later in another update call.
The problem with IQueryable is that when I call the Update for the second time later in code with this "myData", it includes data which were affected between the two updates, and I want the data as they were before the first update was called.

So I need this

var myData = (from t1 in db.Table1
where ...
select new { do some math here }).ToList();

to update table using the same call as before.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

梦里泪两行 2024-12-10 21:45:14

var myData =
    from t1 in db.Table1
    where ...
    select new { do some math here };

var myDataList = myData.ToList();

myData.Update( db.Table2, x => new Table2
{
   update columns here
}

这是您要找的吗？

var myData =
    from t1 in db.Table1
    where ...
    select new { do some math here };

var myDataList = myData.ToList();

myData.Update( db.Table2, x => new Table2
{
   update columns here
}

Is this what you are looking for?

回复收藏 0 原文

~没有更多了~