Hello,
i am using the current Version 6.70.
When using the following setting:
OracleEntityProviderConfig.Instance.DmlOptions.InsertNullBehaviour = InsertNullBehaviour.Omit;
it is not possible to insert an empty Entity, e.g.
MYEntity e = new MYEntity();
context.Add(e);
context.SaveChanges(); <- Error at this point
MYEntity is completely empty, i want to have an empty row in my database with null-values only (except the primary key).
I guess the insert does something like "Insert into myentity () values()" ?!
Greetings,
Species8372
DmlOptions.InsertNullBehaviour.Omit - Bug
As we understood, the value for the primary key column is generated in your database (sequence + trigger). If so, set StoreGeneratedPattern=Identity for your primary column in the store part of the model.
If not, please specify the following information:
- the exact text of the error
- turn on the dbMonitor tool and check the actual query
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
Refer to http://www.devart.com/blogs/dotconnect/ ... l#OtherDML: try specifying devart:DefaultValue="MY_SEQUENCE.NEXTVAL" (if there is a corresponding sequence for your primary key in the database) and using InsertNullBehaviour.InsertDefaultOrOmit.
If not, please specify the following information:
- the exact text of the error
- turn on the dbMonitor tool and check the actual query
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html
Refer to http://www.devart.com/blogs/dotconnect/ ... l#OtherDML: try specifying devart:DefaultValue="MY_SEQUENCE.NEXTVAL" (if there is a corresponding sequence for your primary key in the database) and using InsertNullBehaviour.InsertDefaultOrOmit.