Hi Steve,
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() is called.
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.
Regards,
Boyan
Telerik by Progress
Check out the
latest announcement about Telerik Data Access vNext as a
powerful framework able to solve core development problems.