From: Raj on 30 Mar 2010 05:57
Any ideas about using single transaction across pages of an application?
From: Andy O'Neill on 30 Mar 2010 06:05
"Raj" <Raj(a)discussions.microsoft.com> wrote in message
> Any ideas about using single transaction across pages of an application?
> Thank you
Do them as logic transactions rather than database transactions.
IE hold your data in memory in a collection of some sort - a list or two
lists or a dataset.
Then write them to the database in one go.
Holding a database transaction open across pages is a big NO on database