AW: [Firebird-net-provider] Normal or retained commit/rollback of transactions

[Jojakim S. <JS...@de...>]

I propose the standard behavior should be like the MS providers.
But what do you think about the normal/retaining problem?

I looked at the documentation of the SqlTransaction class for MSSQLServer.
They implemented savepoints within transactions by introducing a
non-IDbTransaction method Save(string savepoint) and overloaded Commit and
Rollback with version that accept these savepoints. However standard
behavior is BeginTransaction(), Commit() or Rollback().

What about building a similar solution: BeginTransaction(), Commit(bool
retaining) or Rollback(bool retaining). Standard Commit() / Rollback() call
these methods with retaining=false. The only thing, I'm not sure about is,
whether it should be necessary to call BeginTransaction() after a
Commit/Rollback(retaining=true). I tend to prefer not to call
BeginTransaction() again.

I included the changes from yesterday as diff -u now.

Greetings, Joja

> -----Ursprüngliche Nachricht-----
> Von: fir...@li...
> [mailto:fir...@li...]Im Auftrag von
> Carlos Guzmán Álvarez
> Gesendet am: Donnerstag, 21. November 2002 18:35
> An: Firebird .Net Provider; Jojakim Stahl
> Betreff: Re: [Firebird-net-provider] Normal or retained commit/rollback
> of transactions
>
> Hello:
>
>  >>Thanks very much ;), i´m seeing now how other providers manage this
>  >>issue, can you send the patches with diff -u please.
>
> I´m testing this and microsoft providers throw exception if you make
> anything like this:
>
> 	...
> 	myTrans.Rollback();	<-- this make connection to be
> capable 							of
> begin a new transaction
> 	myTrans.Commit();	<-- This throw InvalidOperationException
> 	...
>
> or
> 	...
> 	myTrans.Commit();	<-- this make connection to be
> capable 							of
> begin a new transaction
> 	myTrans.Rollback();	<-- This throw InvalidOperationException
> 	...
>
>
>
> I can made the changes needed for work if there are no opinions against
> it :)
>
>
>
>
> Best regards
> Carlos Guzmán Álvarez
> Vigo-Spain
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>