On 6/15/07, Dan Cooperstock <[EMAIL PROTECTED]> wrote:
> I need a really serious lock for something I'm doing, so I want to start a
> transaction with Snapshot Table Stability. How do I do that with the .NET
> driver?
>
> I'm reading both Helen Borrie's Firebird book and the source code for
> FbTransaction.cs, and I'm starting to think that all I have to do is use the
> normal .NET API to start the transaction with the System.Data.IsolationLevel
> value Serializable, because the code converts that to Consistency, which I
> believe corresponds to Snapshot Table Stability.
>
> Is that correct?
Yes. Serializable is Table Stability in FB (well, serializable in pure
meaning locks tables, but thanks to MGA this isn't required in FB; so
it's not serializable in pure, but behaves exactly like that).
> In case you are wondering why I need that, I'm creating numbered receipts,
> where numbers may neither be skipped nor duplicated, and it's not suitable
> for using a Generator for various reasons. I just don't want anybody else to
> mess with the receipts while one user is generating them.
If the series doesn't have to be continuous (and you won't use
generators), you can use own generating in transactions.
--
Jiri {x2} Cincura
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
