Best method to call a long stored proc with WCF

C

Cindy Lee

Say have a stored procedure that takes about 10min to 1 hour to run
and I need to call it with WCF (silverlight).

I'd basically want to fire off the query, have the wcf service fire
off the query in a thread or something. Then have the wcf return to
the silverlight program and say 'Ok the SP is running'

The silverlight app would then make some wcf calls that would count
the rows in table x, to see what the progress is. Or the SP could
update another table with the status. Could the WCF service just call
a thread return 'OK running', and still have the SP running on the
database? I don't want to keep the connection open for 10 min to 1
hour.

I'm a little shy about making a synchronis WCF service that will post
back to the silverlight wcf client. Would that be easy to do, it
sounds a lot more complicated.
 
C

Cindy Lee

Say have a stored procedure that takes about 10min to 1 hour to run
and I need to call it with WCF (silverlight).

I'd basically want to fire off the query, have the wcf service fire
off the query in a thread or something.  Then have the wcf return to
the silverlight program and say 'Ok the SP is running'

The silverlight app would then make some wcf calls that would count
the rows in table x, to see what the progress is.  Or the SP could
update another table with the status.  Could the WCF service just call
a thread return 'OK running', and still have the SP running on the
database?  I don't want to keep the connection open for 10 min to 1
hour.

I'm a little shy about making a synchronis WCF service that will post
back to the silverlight wcf client.  Would that be easy to do, it
sounds a lot more complicated.

Maybe I need to use a sql server agent and use sp_start_job to fire
it off.
 
C

Cindy Lee

Maybe I need to use a sql server agent and use sp_start_job  to fire
it off.- Hide quoted text -

- Show quoted text -

Thing is I'd rather not use sql server agent, and I think if I break
connection to the WCF Service it will stop the stored procedure from
running.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,787
Messages
2,569,630
Members
45,334
Latest member
66Zeinab9

Latest Threads

Top