C# can you place a timercallback inside of a webservice
I am开发者_运维技巧 trying to think of the best way to do retry logic while using a webservice to upload XML to a DataSource. I was curious is it possible (or is there a better way) to use a timercallback inside of a webservice?
Thanks, Andrew
Based on the information you provided, I think the simplest solution will be to create another table, or update the existing table with an extra field, where you can mark if the record is succesfully send to the webservice and received.
Than instead of using the insert trigger, i would create a SQL job, which you can schedule to check for records that need to be sent by the webservice. You can reference to your stored procedure and use a transaction (if you are not already using it) and if the transaction succeeds update the record in your database for succesfull completion.
精彩评论