Linq update in for each loop odd behaviour

Posted on 2010-08-20
Last Modified: 2012-05-10
In the attached code snippet I have a for each loop on a linq result set.

Each loop updates a LocalPrice field and then calls CalculateRowTotals which is a routine in the partial class of the order details linq entity.

CalculateRowTotal simply updates the totals in the row based on the new LocalPrice.

For some reason CalculateRowTotals does not write the totals back to the database... the LocalPrice is changed without issue... whats going on?
'Do we have a current order
        Dim ordHead = (From p In db.bb_order_headers
                 Where p.AccountNo_FK = c.AccountNo And p.OrderStatus = "N").SingleOrDefault

        If Not (ordHead Is Nothing) Then
            Dim ordDetails = From p In db.bb_order_details
                     Where p.OrderHeaderId_FK = ordHead.OrderHeaderId
                     Select p
            For Each rec As bb_order_detail In ordDetails
                'For some reason 
                rec.LocalPriceDB = c.GetLocalCurrencyPrice(rec.Price)
        End If

Open in new window

Question by:WingYip
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
LVL 19

Expert Comment

by:Adam Menkes
ID: 33489890
might need to be
rec.somefield = rec.CalculateRowTotals()

Author Comment

ID: 33489916
No that wouldnt work - CalculateTotal changes a number of other fields in the row - it does not return anything - its defined in the bb_order_details partial class and therefore has access to all other values in that row instance.

Thanks anway

LVL 19

Accepted Solution

Adam Menkes earned 500 total points
ID: 33489941
Are the changes you are making on the same objectContext?

will submit changes on the context defined by db. You might be making changes on a different context other than db
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now


Author Comment

ID: 33490964
In the code, you can see that before 'rec.LocalPriceDB' is set before 'rec.CalculateRowTotals()' is called.  The db.SubmitChanges() after the loop seems to update 'rec.LocalPriceDB' without issue.  Why would 'rec.LocalPriceDB' work and CalculateRowTotals not work when they are referecing the same object.

CalculateRowTotalsis called several times elsewhere in the app and has no probllems. However thsi is the only time a for each is used to loop through records.

LVL 19

Expert Comment

by:Adam Menkes
ID: 33491481
Did you set it breakpoint and step through it to see if it is fact updating the order details record or just variables stored at that moment in time?
LVL 16

Expert Comment

ID: 33544736
Could it be that even though your order_headers table has a primary key set your CalculateRowTotals class is missing one? According to this article LINQ ignores the update in that case (even if it has a pk you may try deleting it and re-adding it?): 

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : All lightning effects with instructions : http://www.mediaf…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question