CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    2

    Lightbulb Notification Service

    I need to create a notification service for my app. The app uses sql server 2008 and the client is WPF using the PRISM framework.

    When some specific changes occur in the DB, like a user making changes to a particular table, I want to notify all active users of the app in the intranet of this change via a flag or something in the app, not email.

    I am looking for suggestions on how to go about this

  2. #2
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: Notification Service

    I would create a windows service that polls the database for changes. Then I would use a WCF service to communicate with the client apps. WCF offers dual binding so you can send notification event to the clients (rather than having the clients poll WCF).


    Btw, in Sql 2005 MS offered notification services but didn't support it in 2008. I was pretty excited about it at first, but found it to be lunky at best. Maybe that's why they dropped support for it in 2008?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured