Missing columns in generated UPDATE

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
Posts: 1
Joined: Tue 18 Jan 2011 12:52
Location: Belgium

Missing columns in generated UPDATE

Post by vanstan » Tue 18 Jan 2011 12:59

We are usign dotConnect for Oracle as our provider for Entity Framework to access an Oracle database.
We are using Self-tracking entities.

When saving changes to the DB not all changed columns are included in the generated UPDATE statement. More specifically, columns which originally had a NULL-value are not included in the UPDATE.

Any tips concering the cause of this problem are appreciated.

Posts: 39
Joined: Tue 20 Jul 2010 15:13

Post by wgkwvl » Wed 19 Jan 2011 16:21

the problem only occurs after applying :
http://social.msdn.microsoft.com/Forums ... a598bad25e

we fixed it by applying :
http://social.msdn.microsoft.com/Forums ... 1fcb38dee4

Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 19 Jan 2011 16:38

vangstan, wgkwvl, I have sent a sample project to the e-mail addresses you have provided in your profiles.
Could you please modify the sample or create a new one that reproduces the issue and send it back to me?

Post Reply