Error with auto generated value

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
tchovis
Posts: 12
Joined: Fri 03 Apr 2009 12:56

Error with auto generated value

Post by tchovis » Wed 10 Feb 2010 11:23

I'm using linq to oracle and when i got one entity that has a pk that has two field and one of then is auto generated, when i try to insert this entity in the database calling the submitchanges it sends a insert then after that it sends a select with the auto generated value equal 0 and raise a exeption, there is any work around for this issue?

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

Post by AndreyR » Wed 10 Feb 2010 16:07

I have just saved a test object with the composite key defined like in your post successfully.
Please make sure that you have set the Auto Generated Value to true and the AutoSync to OnInsert for the autogenerated property.

tchovis
Posts: 12
Joined: Fri 03 Apr 2009 12:56

Post by tchovis » Wed 10 Feb 2010 17:49

i did what you asked and and i still got the problem i rollback for the 5.25.44 and got all woking again

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

Post by AndreyR » Thu 11 Feb 2010 09:18

Could you please send me (support * devart * com) a small test project reproducing the issue?
Please include the script of the table you encounter the problem with.

Post Reply