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. Jiri, I put archive with source code into google drive https://drive.google.com/file/d/0B8UZY3a6pO3iTkRHZ1NIQVlrS3M/view?usp=sharing . Can you review my code, may be I just lost some specific configuration part or something similar. -- Roman Patutin -----Original Message----- From: Jiří Činčura [mailto:j...@cincura.net] Sent: Wednesday, October 26, 2016 7:37 AM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] EntitiyFramework and Update When the two transactions update same record *at the same time*, there's nothing you can do it. One will fail. You can minimize that keeping the transactions as short as possible. Comparing TX handling with MySQL is wrong; I guess you used MyISAM tables, where TXs are virtually non-existent. Try any other real DB and you'll get the same problem. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ The Command Line: Reinvented for Modern Developers Did the resurgence of CLI tooling catch you by surprise? Reconnect with the command line and become more productive. Learn the new .NET and ASP.NET CLI. Get your free copy! http://sdm.link/telerik _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
