Devart Forums

After automatically generting the .edmx file from an Oracle 10g database, I manually add the following line:



into the store schema section and changed the conceptual schema and the c-s mapping accordingly.

The reading of ORA_ROWSCN is just fine. But when SaveChanges() was called, an exception occured: InternalExcpetion "{"Unknown column 'ORA_ROWSCN'"}".

Any suggestion? Thanks.

It is impossible to support all types of pseudo-columns, but ORA_ROWSCN support will be already available in the next build.

Thank you, Shalex, for your reply. Is there any chance to give the release date of the next build?

We can't provide you with the exact date now. But the next build will be available during 2 weeks for sure.

That's great. Thanks.

The problem was only partially solved by dotConnect 5.0.beta:

The SaveChanges() works fine but the new value of ORA_ROWSCN does not fetch back correctly -- the new value is set to be null.

The reason I found is: the new value of ORA_ROWSCN is availabe only after the change is committed. But in the generated sql statement by dotConnet, the ORA_ROWSCN is returned back before the commit. So we get back a null value.

Any comment? Thanks.

When you refreshing data, the cycle of update-refresh is executing for every record. Transaction is commited only after refreshing all the tabels. We cannot provide committing transaction before every returning of updatable columns.

That makes sense. So ORA_ROWSCN is not a REAL updatable column, even if we set the StoreGeneratedPattern="Computed" attribute.