Devart Forums

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

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.

Recently I was wondering the same question and it took me a while to figure it out. Man, we need better document Here is one way to do it:

1) refer to the following 2 assembly:
CoreLab.Data
CoreLab.Oracle
(which can be found at C:\Program Files\Devart\OraDirect.NET2\ if you installed the drivers in the default location).

2) create a monitoring objecct before you create the object context object:

CoreLab.Oracle.OracleMonitor oracleMonitor1 = new CoreLab.Oracle.OracleMonitor();

oracleMonitor1.IsActive = true;

3) Run the DBMonitor before you run your program.

That's it. You will catch all sql texts sent to the Oracle database.

I tried Shalex's suggestion by using






For query it works fine. But after I made some changes to the returned objects and called SaveChanges(), it throwed an optimisitics concurrency exception. With DBMonitor, I found the reason is: Guids are sent to Oracle in the "-" seperated format while in the database it is saved as no "-" strings. So it can not find the object just returned during updating.

Any thought? Thanks.

If the column value is only set during insertion, you could add manually StoreGeneratedPattern="Identity" to the column defintion in the storage schema.

If the column value is set during insertion and update, you could add manually StoreGeneratedPattern="Computed" to the column defintion in the storage schema.

This works fine with me.

That's great. Thanks.

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

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.