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

[Roman P. <rpa...@ak...>]

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:ji...@ci...] 
Sent: Wednesday, October 26, 2016 7:37 AM
To: fir...@li...
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