Updating an item property within IEnumerable but the property doesn’t stay set?

by

IEnumerable<T>s do not guarantee that updated values will persist across enumerations. For instance, a List will return the same set of objects on every iteration, so if you update a property, it will be saved across iterations. However, many other implementations of IEnumerables return a new set of objects each time, so any changes made will not persist.

If you need to store and update the results, pull the IEnumerable<T> down to a List<T> using .ToList() or project it into a new IEnumerable<T> using .Select() with the changes applied.

To specifically apply that to your code, it would look like this:

var transactions = (from t in db.Transactions
                    where t.SellingPrice != 0 
                    select t).ToList();

var taAgents = (from ta in db.TransactionAgents
                select ta).ToList();

foreach (var transaction in transactions)
{
    foreach(var agent in taAgents)
    {
        agent.AgentCommission = ((transaction.CommissionPercent / 100) * (agent.CommissionPercent / 100) * transaction.SellingPrice) - agent.BrokerageSplit;
    } 
}

dataGridView1.DataSource = taAgents;

More Related Contents:

  1. Get a list greater than specific value from lists usinq linq c#
  2. How to have nested query with LINQ
  3. LEFT OUTER JOIN in LINQ
  4. Check whether an array is a subset of another
  5. How do I concatenate two arrays in C#?
  6. How to perform Join between multiple tables in LINQ lambda
  7. Create a list from two object lists with linq
  8. LINQ to SQL – Left Outer Join with multiple join conditions
  9. “A lambda expression with a statement body cannot be converted to an expression tree”
  10. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  11. Proper Linq where clauses
  12. What is the use of Enumerable.Zip extension method in Linq?
  13. LINQ: Select an object and change some properties without creating a new object
  14. Select distinct using linq [duplicate]
  15. For vs. Linq – Performance vs. Future
  16. How to flatten nested objects with linq expression
  17. TransactionScope vs Transaction in LINQ to SQL
  18. LINQ, Where() vs FindAll()
  19. Swap two items in List
  20. How do I get the index of the highest value in an array using LINQ?
  21. Exception using CopyToDataTable with “new {..}” LINQ query
  22. How to group by on 2 child entities and get total of both this child entities?
  23. Is there an “Explain Query” for MongoDB Linq?
  24. Custom Method in LINQ to SQL query
  25. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  26. Using Linq Except not Working as I Thought
  27. What is the purpose of AsQueryable()?
  28. Calling a SQL User-defined function in a LINQ query
  29. How to search Hierarchical Data with Linq
  30. Convert DataTable to Generic List in C#

Leave a Comment