I am using the 2010Q3 release for updating few records in oracle database for one of the applications. Table has a single column which is used as counter and defined as primary key. It doesn't use the sequence in oracle and is manually updated from the last value.
I am using the following code to update the value in the table but ORM returns me an error "Unsupported operation: Change of Identity not supported"
private DWModel _entities = new DWModel("DWConnection");
private long UpdateDocumentCounter()
var counter = _entities.DOCUMENT_COUNTERs.First();
counter.CURRENTID = counter.CURRENTID + 1;
The designer shows CURRENTID Identity property as true, and Identity mechanism as default. When I try to change it to any other value I get a runtime error ORA-00942: table or view does not exist Telerik.OpenAccess.RT.sql.SQLException
I can't change the behavior of the other application as its an external vendor app, so have to go with its design.
Any help really appreciated.