Updating a field in EntityCollection

Posts   
 
    
LLBLGen
User
Posts: 43
Joined: 10-Apr-2006
# Posted on: 06-Nov-2006 20:04:17   

How do i update a field or fields in an EntityCollection.

Something Like this

Update Transaction set Pay=5, Bill=10

second, is there a easy way to copy EntityCollection, say if i want to copy everything except PK. Something like this

Select pay, bill, ....into TempTransaction From Transaction?

for both of these i am using something like this...

foreach(TransactionEntity t in TransactionEntityCollection) { update fields... or copy values to new entity collection }

I am using WinForms, Adapter, (LLBL V2 Oct 23),.NET2.0, SQL 2005 Thanks

Walaa avatar
Walaa
Support Team
Posts: 14987
Joined: 21-Aug-2005
# Posted on: 07-Nov-2006 07:50:16   

You got it right.