[Firebird-net-provider] Locking Table for Read and Write

2015-07-22 Thread LtColRDSChauhan
Hello, 1. I want to lock a table : to read a record and follow up tx = con.BeginTransaction( new FbTransactionOptions() { TransactionBehavior = FbTransactionBehavior.Consistency | FbTransactionBehavior.NoWait,

Re: [Firebird-net-provider] Read allowed despite locking table in transaction

2015-07-22 Thread Jiří Činčura
Don’t do that. Database engine (any) people do a great effort to reach maximum throughput and you want to limit it to basically 1. If you need someething like that, your design has serious flaw. -- Mgr. Jiří Činčura Independent IT Specialist From: LtColRDSChauhan [mailto:rdsc1...@gmail.com]