error ORA-01779 while updating

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
urbanr
Posts: 9
Joined: Tue 23 Apr 2019 11:52

error ORA-01779 while updating

Post by urbanr » Sat 19 Oct 2019 01:29

Hello,
When SaveChanges() is called getting ORA - 01779 cannot modify a column which maps to a non key-preserved table
error, any idea what's Is causing this?

Shalex
Site Admin
Posts: 8988
Joined: Thu 14 Aug 2008 12:44

Re: error ORA-01779 while updating

Post by Shalex » Sat 19 Oct 2019 16:39

Please enable dbMonitor and check the generated SQL statement. It should help to localize the problem. The cases when "ORA-01779: cannot modify a column which maps to a non key-preserved table" occurs:
* https://stackoverflow.com/questions/170 ... rved-table
* https://asktom.oracle.com/pls/asktom/f? ... 0346825287

Send us a small test project with the corresponding DDL/DML script so that we can reproduce and investigate the issue.

urbanr
Posts: 9
Joined: Tue 23 Apr 2019 11:52

Re: error ORA-01779 while updating

Post by urbanr » Thu 31 Oct 2019 00:54

thanks for tip and link, they helped find the reason
as well very handy dbmonitor.

Post Reply