Telerik Data Access
will execute the stored procedure in a transaction but it will not commit it automatically - it will expect explicit call to .SaveChanges()
to do so. This is done to allow the user to combine the stored procedure call with other actions and commit them all as a single transaction.
This is why, when the stored procedure is invoked, you receive the record, but the that record is not actually persisted until .SaveChanges()
This is the expected behavior and I do not think you can get around it. Could I kindly ask you tell us more about the issue you are experiencing?
Please refer to this documentation article
for further information on how to handle transactions with Telerik Data Access
I hope this is helpful. Do get back to us with any further questions.
Telerik by Progress
Check out the latest announcement
about Telerik Data Access vNext as a powerful framework
able to solve core development problems.