Devart Forums

Hi,

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.

Regards,

Matthieu

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