NewBie help.

[archana]

Hi all,

I want to develop windows application which will intiate long running
stored procedure.

So what i decided is to use web service for starting long running sp
and setting oneway attribute.

So if i close application after invoking web method asycnhronoysly and
then closing my windows application will it cause any error.

Please correct me if i am wrong.

And tell me alternative of doing this if this is not proper way.

Thanks in advance.

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

The stored procedure will complete regardless if the process that
started it goes away during the execution.

 

[Guest]

You procedure is processed into the DB not in your app, there is no
dependency between app and procedure execution.
BTW the [OneWay] attribure marks you method returning anything, even if
exception throw

I want to develop windows application which will intiate long running
stored procedure.
So what i decided is to use web service for starting long running sp
and setting oneway attribute.
So if i close application after invoking web method asycnhronoysly and
then closing my windows application will it cause any error.
Please correct me if i am wrong.

And tell me alternative of doing this if this is not proper way.

--
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Hi all,

I want to develop windows application which will intiate long running
stored procedure.

What is the problem here? You could use a "wait screen" with a progressbar.

Additionally you can execute the SP in a worker thread and send an event to
the UI thread when done.

So what i decided is to use web service for starting long running sp
and setting oneway attribute.

A possible solution. I would send back some kind of notification to the user
( email? ) than the SP ran sucessfuly.
In addition you could take a look at MSMQ ( MS message queuing )

 

[archana]

Hi all,

thanks for your reply.

So my question is am i right. Means i can invoke long running process
from windows application and rely on web service that it will continue
its execution even if i close my application?

I don't want any interaction with windows application once client has
initiated process.
I want to run SP irrespective of whether client is currently active or
not.

Please correct me if i am wrong

Thanks in advance.

 

[archana]

Hi ignacio,

thanks for your reply

As you suggested me to use wait screen, but the problem is my sp is
long running may be it is taking a day or 2 days. So what i want is
allow user to close application once he has started SP through web
service. I don't want any kind of return value to client.

client can get progress of exeuctin of SP through another method so in
this method i am not expecting anything to be returned to client.

If still you are not clear please let me know about this problem i will
try to explain it with example then.

If you can help me in clearing my confusion then it will be really
benefical for me.

As i am new to web service i don't have much of idea about how web
request start once client has invoke that web request asynchronously.

What i am expecting is as HTTP is stateless once client initiated any
long running web method it will start irrespective of client.

Please correct me if i am wrong.

Thanks.