topic Re: Is IWorkspace.ExecuteSQL synchronous or asynchronous? in ArcObjects SDK Questions

Is IWorkspace.ExecuteSQL synchronous or asynchronous?

MarkMindlin — Tue, 22 Sep 2015 00:31:20 GMT

Desktop 10.3

I cannot find in documentation an answer for that.

And secondly, can I change that method to be synchronous/asynchronous?

Any documentation link or idea?

Was this method asynchronous in previous versions?

Re: Is IWorkspace.ExecuteSQL synchronous or asynchronous?

FreddieGibson — Tue, 22 Sep 2015 03:46:13 GMT

The method should be synchronous because it blocks the UI thread when you call it. Have you tried wrapping it within an asynchronous method? Examples of how to do this are available on the following pages:

Calling Synchronous Methods Asynchronously

https://msdn.microsoft.com/en-us/library/2e08f6yc(v=vs.110).aspx

Create an Asynchronous Method

http://www.csharp-examples.net/create-asynchronous-method/

Re: Is IWorkspace.ExecuteSQL synchronous or asynchronous?

MarkMindlin — Tue, 22 Sep 2015 23:39:51 GMT

Thanks Freddie,

Thank you for response.

Good suggestion.

Was this method asynchronous in previous versions? (before 10.3)

Re: Is IWorkspace.ExecuteSQL synchronous or asynchronous?

FreddieGibson — Tue, 22 Sep 2015 23:51:36 GMT

I don't believe this method was ever asynchronous.

Re: Is IWorkspace.ExecuteSQL synchronous or asynchronous?

MarkMindlin — Wed, 23 Sep 2015 00:53:20 GMT

Thank you Freddie,

Probably do you have an idea why execution of a procedure with this method blocks the table to which the procedure writes (meaning - I cannot read the table when procedure is executing)?