Re: [Firebird-net-provider] EntitiyFramework and Update

FB.NET doesn't wait on locks, it returns immediately with exception. All other known for me are waiting on locks. That's the behavior you observe. You need to override creation of transaction. You should use FbTransaction with TBP in which you specify waiting option and timeout. On 26 October

Re: [Firebird-net-provider] EntitiyFramework and Update

There's really nothing EF related. You can try it with multiple console windows with multiple transactions together. It's fundamental way how transactions work. -- Mgr. Jiří Činčura Independent IT Specialist -- The

Re: [Firebird-net-provider] EntitiyFramework and Update

I added one more db connection into app. This time it was PostgreSql and Postgres worked with same behavior as MySql. I don't know is Postgres real db or not, but it allows to change different fields in one record for concurrent queries. May be I just can't correctly describe the problem.

Re: [Firebird-net-provider] EntitiyFramework and Update

I suspect the default transaction option might not be the same in firebird and other databases. Try setting the IsolationLevel to SERIALIZABLE on the transaction. On Wed, Oct 26, 2016 at 10:19 AM, Jiří Činčura wrote: > There's really nothing EF related. You can try it with