none
How to notify C# code from Azure database

    Question

  • Hi,

    I am creating a WCF service (CALLER) for Azure. The service(CALLER) calls async methods of another third party service(EXTN). The third party service calls the callback methods of another WCF service (LISTENER) hosted by me on Azure. CALLER enter the service details in the database with status = PENDING.

    In the callback service (LISTENER) I am updating the status of the request as COMPLETED/FAILED in the database.

    I want to notify my C# code after the value is database changed by LISTENER.

    Is it possible????

    Tuesday, August 03, 2010 8:40 AM

Answers

  • Hi,

    Since it's the LISTENER that modifies your database could you let it notify "your C# code" (BTW, what's it? Is it the CALLER?)?


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. Windows Azure Platform China Blog: http://blogs.msdn.com/azchina/default.aspx
    Wednesday, August 04, 2010 3:06 AM
    Moderator

All replies

  • I don't believe this is currently possible since it would require CLR code in the DB to execute a call to the LISTENER and embedding CLR code is not currently exposed in SQL Azure or Azure Storage.
    Tuesday, August 03, 2010 12:59 PM
    Moderator
  • Hi,

    Since it's the LISTENER that modifies your database could you let it notify "your C# code" (BTW, what's it? Is it the CALLER?)?


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. Windows Azure Platform China Blog: http://blogs.msdn.com/azchina/default.aspx
    Wednesday, August 04, 2010 3:06 AM
    Moderator
  • Yes. My C# code is the CALLER.
    Wednesday, August 04, 2010 10:43 AM
  • Yes. My C# code is the CALLER.

    If so could you let the LISTENER notify your CALLER by web service call, queue storage, etc?
    Please remember to mark the replies as answers if they help and unmark them if they provide no help. Windows Azure Platform China Blog: http://blogs.msdn.com/azchina/default.aspx
    Thursday, August 05, 2010 6:59 AM
    Moderator