Base solution for your next web application

Ends in:

01 DAYS

01 HRS

01 MIN

01 SEC

Closed

Transaction rollback issue oracle Devart #7069

0

velu created 5 years ago

Hi,

We are using .netCore and angular 6 Combined solution.

We have connected to oracle database using Devart Drivers, UnitOfWork.IsTransactional = false , Not supported yet.

in this case SaveChangesAsync records are not rolled back.

How can we rollback after unit of work is failed.

Thanks

3 Answer(s)

0

maliming created 5 years ago
Support Team

I remember that there is no transaction and can't roll back the operation. This is also a rule of the database

Does Devart Drivers not support transactions?
1

velu created 5 years ago

Hi,

We have diagnosed and resolved this issue.

The actual problem is that the default behavior of Unitofwork is Readuncommited.

This isolation level is not supported by Oracle (Devart Drivers)* .

Instead of UOW.IsTransactional = false we have changed the isolation level of UOW to ReadCommitted.

This is supported by oracle and working as expected.

Thanks
0

ismcagdas created 5 years ago
Support Team

Thanks @velu

Have an answer to this question? Log in and write your answer.