根据另一个 LINQ 到实体查询的结果更新一个实体

Question

我有以下 LINQ-to-Entities 查询：

' Get all the residency assignments that match the term/year.
        Dim assignments = From p In dbContext.Residents _
                          Where p.semester = term _
                          Where p.year = year _
                          Select p

这将为我提供当前年份/学期的所有驻留分配。然后我有这个 LINQ-to-Entities 查询：

 Dim reset_occupancy = From p In dbContext.Rooms _
                              Select p

这将为我提供所有房间。我想迭代分配并根据分配的房间更新重置占用率中的占用率。我不是 100% 确定如何实现这一点。这是我想要完成的伪代码：

For each row in assignments
   reset_occupancy.Where(reset_occupancy.room=assignment.occupancy).current_occupancy =+1
Next 

Answer 1

如果有人有更好的答案，我仍然喜欢它......但对于其他尝试类似过程的人来说，我是如何解决它的：

        ' Now, retabulate current occupancy.
        For Each row In assignments
            Dim assignment As Integer = row.room
            Dim update_occupancy = (From p In dbContext.Rooms _
                                   Where p.id = assignment _
                                   Select p).FirstOrDefault

            update_occupancy.current_occupancy = update_occupancy.current_occupancy + 1
        Next
        dbContext.SaveChanges()