Cancel SQL execution when browser cancels OData request

Asked Oct 21 '16 at 05:14

Active Oct 21 '16 at 05:18

Viewed 177 times

I am using OData v3 with ASP.net 4.6 MVC 5, Oracle 11g.

I execute an OData c3 query via Ajax to my App server. Then, I execute this in javascript on the front end, before the previous request has finished.

xhr.abort();

It causes a cancellation of an OData request to the server. It does not cause the related SQL to stop running.

I learned about CancellationTokens in ASP.NET, but it seems they are already being used. I am looking for the simplest way to accomplish cancellation of the related SQL when the abort method is called on the related Ajax call.

asked Oct 21 '16 at 05:14

Worthy7

1,455
15
28

http://stackoverflow.com/questions/4772597/detecting-async-client-disconnect-in-asp-net-mvc – Eldho Oct 21 '16 at 07:16
Ok no mention of doing this with OData, where I don't see active control of the query. – Worthy7 Oct 21 '16 at 09:15
It seems this cannot be done. – Worthy7 Mar 29 '18 at 04:36

Cancel SQL execution when browser cancels OData request

0 Answers0