Solved

Linq update in for each loop odd behaviour

Posted on 2010-08-20
6
578 Views
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?
thanks
Wing
'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)

                rec.CalculateRowTotals()

            Next

            db.SubmitChanges()

        End If

Open in new window

0
Comment
Question by:WingYip
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:amenkes
ID: 33489890
rec.CalculateRowTotals()
might need to be
rec.somefield = rec.CalculateRowTotals()
0
 
LVL 1

Author Comment

by:WingYip
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

Wing
0
 
LVL 19

Accepted Solution

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

db.SubmitChanges()
will submit changes on the context defined by db. You might be making changes on a different context other than db
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 1

Author Comment

by:WingYip
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.

Wing
0
 
LVL 19

Expert Comment

by:amenkes
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?
0
 
LVL 16

Expert Comment

by:13598
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?):
http://naturalprogression.wordpress.com/2010/02/12/db-submitchanges-does-not-update-data/ 
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
Delivering innovative fully-managed cloud services for mission-critical applications requires expertise in multiple areas plus vision and commitment. Meet a few of the people behind the quality services of Concerto.

932 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now