Hi, I'm currently using the ado.net firebird client 2.5 and I have some problems with the configuration of the transactions. I only found some outdated documentation from version 1.7 on the web, so I was hoping that someone could point me toward some up to date documentation or tell me how to solve my problem.
What I want to achieve, is to create a transaction with the method FbConnection.BeginTransaction(FbTransactionOptions) that - can write data to one or more tables - locks the tables it want to writes at the start of the transaction to avoid deadlocks - waits if the tables it want to use are already locked by another transaction I thought that I should use the following call to create the FbTransactionOptions object: new FbTransactionOptions() { TransactionBehavior = FbTransactionBehavior.Concurrency | FbTransactionBehavior.Wait | FbTransactionBehavior.LockWrite | FbTransactionBehavior.Protected }; But this calls throws an exception with the message "invalid parameter in transaction parameter block". I tried several other combinations that looked like they should make sense to me, but I got the same error every time. Moreover, at this point, I am not too sure of how to specify which table I want to lock. From what I read in my book about Firebird, it is possible to do it, but I'm not sure if the data provider allows it and then how to do it. Thank you very much, Marc Bettex ------------------------------------------------------------------------------ The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider