Print Page | Close Window

Update multiple records

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2696
Printed Date: 04-May-2025 at 1:21am


Topic: Update multiple records
Posted By: new user
Subject: Update multiple records
Date Posted: 18-May-2011 at 8:35am
Hello friends,

My requirement is to update multiple records in Employee entity using IdeaBlade. I have tried following code snippet. But it is updating only one record in Employee entity. Can anyone help me please. Its urgent.

 foreach (Employee emp in SelectedEmployees)//where 'SelectedEmployees' is a observablecollection of type 'Employee'
                    {
                       var empQuery = mgr.Employees.AsScalarAsync().First(i => i.EmpID == emp.EmpID);
                       empQuery.Completed += (o, i) =>
                        {
                            Employee newEmp =  i.Result;
                            newEmp.EmpName = "new name";
                            newEmp.EntityAspect.AddToManager();
                            manager.SaveChangesAsync();
                       };
                  }
                        


Replies:
Posted By: sbelini
Date Posted: 18-May-2011 at 10:08am
Hi,
 
If you already have an ObservableCollection of Employees, why are you requerying one at time again?
Also, you don't need to call SaveChagesAsync to each Employee.
 
Try this instead:
 
foreach (Employee emp in SelectedEmployees)//where 'SelectedEmployees' is a observablecollection of type 'Employee'
{
  emp.EmpName = "new name";
}
manager.SaveChangesAsync();
Silvio.
 

Posted By: new user
Date Posted: 18-May-2011 at 11:54pm
Hello Sbelini,

Thanks alot..it is worked for me...:)

Thanks once again...


Print Page | Close Window