Server (in database) derived values

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
matthieu de graaf
Posts: 18
Joined: Wed 14 May 2008 12:13

Server (in database) derived values

Post by matthieu de graaf » Wed 14 May 2008 12:24


I want to derive the values of a number of columns in the database, by means of a database trigger; e.g. my primary key will be filled by the value of an oracle sequence.
Is there a way to convey these values back to the dataset without refreshing the contents of the dataset explicitely?
Theoretically oradirect can do this by taking advantage of the returning clause of the insert or update statement.



Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Wed 14 May 2008 12:59

Yes, it can be done.
Please see the following topics in OraDirect .NET documentation:
- OracleDataTable.RefreshingFields;
- OracleDataTable.RefreshMode;
- OracleCommandBuilder.RefreshingFields;
- OracleCommandBuilder.RefreshMode;

Post Reply