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? 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. Thanks. Dan Cooperstock 416-423-9064 [EMAIL PROTECTED] ------------------------------------------------------------------------- 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
