[Mono-list] Mono.ADO.Net
Carlos O'Donell Jr.
carlos@baldric.uwo.ca
Thu, 13 Dec 2001 12:06:13 -0500
> >
> yes, and it is a nice idea worth supporting it in gnome-db. I'm only
> worried about the data loss that (I guess) users will encounter.
A very valid worry :)
> > It's not necessarily a "nightmare" as you put it, because you can easily
> > implement concurency techniques to avoid modifying any data that was changed
> > after you aquired your DataSet snapshot.
> >
> yes, that's why I said it might be a nightmare, because users will be
> losing their modifications too often (in a multi-user, ever-changing
> database). As you say, it can be really easy to just discard
> modifications for rows/fields that have already been changed by someone
> else, but this won't help too much that user.
And this is all under the assumption that database items are pre-fetchable/cacheable
Which might not the case if you have triggers tied into those items.
Which means that the changes _need_ to be processed in the order they
were received. Which sounds like it might make things even worse if you
just discard changes.
With that said. Isn't it just another tool? And you get to make a per-application
choice.
Cheers,
Carlos Jr.