如何选择特定的实体对象进行更新？

发布于 2024-10-19 13:42:33 字数 642 浏览 1 评论 0原文

我从数据库中的实体中提取所有对象

Dim dbConfig as New housingEntities
Dim update_query = (From p in dbConfig.Configs _
                    Select p)

然后，我想单独访问这些行并对它们执行更新...例如，如果我只需要第一行，我可以这样：

update_query.First.timeValue = txtFRRSD.Text
dbConfig.SubmitChanges()

现在，我不不知道如何编写此代码，但这是我想做的伪操作：

update_query.Item("FRRSD").timeValue = txtFRRSD.Text
update_query.Item("FRRCD").timeValue = txtFRRCD.Text
update_query.Item("SORSD").timeValue = txtSORSD.Text
update_query.Item("SORCD").timeValue = txtSORCD.Text
dbConfig.SubmitChanges()

有人知道一种方法可以做到这一点或类似的事情吗？

原文

I'm pulling all the objects from an entity in my database

Dim dbConfig as New housingEntities
Dim update_query = (From p in dbConfig.Configs _
                    Select p)

Then, I want to individually access the rows and perform updates to them...For example, if I just needed the first row I could go like this:

update_query.First.timeValue = txtFRRSD.Text
dbConfig.SubmitChanges()

Now, I don't know how to code this, but here is pseudo what I'd like to do:

update_query.Item("FRRSD").timeValue = txtFRRSD.Text
update_query.Item("FRRCD").timeValue = txtFRRCD.Text
update_query.Item("SORSD").timeValue = txtSORSD.Text
update_query.Item("SORCD").timeValue = txtSORCD.Text
dbConfig.SubmitChanges()

Does anyone know a way to do this or something like this?

分享到QQ

分享到微博

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

发布评论

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

歌枕肩 2024-10-26 13:42:34

下面是一个用 C# 编写的通用示例，说明了如何一次更新多个实体对象。

public void UpdateWidgetEntities(List<WidgetEntity> newWidgets)
{
   WidgetEntities widgetDB = new WidgetEntities();
   var dbWidgets = (from w in widgetDB.WidgetTable
                   where newWidgets.Contains(w.WidgetID)
                select w).ToList();

   foreach(var dbWidget in dbWidgets)
   {
      foreach(var widget in newWidgets)
      {
         if(dbWidget.WidgetID = widget.WidgetID)
            dbWidget.WidgetValue = widget.WidgetValue;
      }
   }
   widgetDB.SaveChanges();

}

Here is a generic example in C# of how I would update many entity objects at once.

public void UpdateWidgetEntities(List<WidgetEntity> newWidgets)
{
   WidgetEntities widgetDB = new WidgetEntities();
   var dbWidgets = (from w in widgetDB.WidgetTable
                   where newWidgets.Contains(w.WidgetID)
                select w).ToList();

   foreach(var dbWidget in dbWidgets)
   {
      foreach(var widget in newWidgets)
      {
         if(dbWidget.WidgetID = widget.WidgetID)
            dbWidget.WidgetValue = widget.WidgetValue;
      }
   }
   widgetDB.SaveChanges();

}

回复收藏 0 原文

~没有更多了~