Silverlight 4 with (HTTP) Duplex and SQL Notifications

Bert O Neill

Rate me:

4.92/5 (7 votes)

17 Jan 2011CPOL4 min read

45.8K

Get updates to your browser immediately when a change has occurred within the database.

code.zip
- Code
  - SLDuplexDependency.sln
  - SLDuplexDependency.Web
    - bin
      - SLDuplexDependency.Web.dll
      - System.ServiceModel.PollingDuplex.dll
    - Classes
      - Guard.cs
      - SilverlightClientsList.cs
      - TrainServiceRunner.cs
    - ClientBin
      - SLDuplexDependency.xap
    - DBNotificationService
      - DBNotificationService.svc
      - DBNotificationService.svc.cs
      - IDBNotificationCallbackContract.cs
      - IDBNotificationService.cs
    - Duplex.svc
    - Duplex.svc.cs
    - Duplex
      - BrowserDuplex.svc
      - BrowserDuplex.svc.cs
      - DBTriggerAuditData.cs
      - IBrowserDuplex.cs
    - IDuplex.cs
    - Model
      - Employee.cs
      - Teams.dbml
      - Teams.dbml.layout
      - Teams.designer.cs
    - obj
      - Debug
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - Silverlight.js
    - SLDuplexDependency.Web.csproj
    - SLDuplexDependency.Web.csproj.user
    - SLDuplexDependency.Web.Publish.xml
    - SLDuplexDependencyTestPage.aspx
    - SLDuplexDependencyTestPage.html
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - SLDuplexDependency
    - App.xaml
    - App.xaml.cs
    - Bin
      - Debug
        
        AppManifest.xaml
        
        ar
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        bg
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        ca
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        cs
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        da
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        de
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        el
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        es
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        et
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        eu
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        fi
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        fr
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        he
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        hr
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        hu
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        id
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        it
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        ja
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        ko
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        lt
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        lv
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        ms
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        nl
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        no
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        pl
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        pt
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        pt-BR
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        ro
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        ru
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        sk
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        sl
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        SLDuplexDependency.dll
        
        SLDuplexDependency.xap
        
        SLDuplexDependencyTestPage.html
        
        sr-Cyrl-CS
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        sr-Latn-CS
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        sv
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.ComponentModel.DataAnnotations.dll
        
        System.ComponentModel.DataAnnotations.xml
        
        System.Runtime.Serialization.Json.dll
        
        System.Runtime.Serialization.Json.xml
        
        System.ServiceModel.Extensions.dll
        
        System.ServiceModel.Extensions.xml
        
        System.ServiceModel.PollingDuplex.dll
        
        System.ServiceModel.PollingDuplex.xml
        
        System.Windows.Controls.Data.dll
        
        System.Windows.Controls.Data.Input.dll
        
        System.Windows.Controls.Data.Input.xml
        
        System.Windows.Controls.Data.xml
        
        System.Windows.Data.dll
        
        System.Windows.Data.xml
        
        th
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        tr
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        uk
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        vi
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        zh-Hans
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
        
        zh-Hant
        
        System.ComponentModel.DataAnnotations.resources.dll
        
        System.Runtime.Serialization.Json.resources.dll
        
        System.ServiceModel.Extensions.resources.dll
        
        System.ServiceModel.PollingDuplex.resources.dll
        
        System.Windows.Controls.Data.Input.resources.dll
        
        System.Windows.Controls.Data.resources.dll
        
        System.Windows.Data.resources.dll
    - MainPage.xaml
    - MainPage.xaml.cs
    - Model
      - Author.cs
    - obj
      - Debug
        
        TempPE
    - Properties
      - AppManifest.xml
      - AssemblyInfo.cs
    - Service References
      - BrowserMaintenanceService
        
        configuration.svcinfo
        
        configuration91.svcinfo
        
        DBNotificationService.disco
        
        DBNotificationService.wsdl
        
        DBNotificationService1.xsd
        
        DBNotificationService2.xsd
        
        Reference.cs
        
        Reference.svcmap
      - SqlServiceReference
        
        configuration.svcinfo
        
        configuration91.svcinfo
        
        Reference.cs
        
        Reference.svcmap
        
        SLDuplexDependency.SqlServiceReference.Employee.datasource
        
        SqlNotifications.disco
        
        SqlNotifications.wsdl
        
        SqlNotifications.xsd
        
        SqlNotifications1.xsd
        
        SqlNotifications2.xsd
    - ServiceReferences.ClientConfig
    - SLDuplexDependency.csproj
    - SLDuplexDependency.csproj.user
  - wcfDuplex
    - App_Data
    - bin
      - System.ServiceModel.PollingDuplex.dll
      - wcfDuplex.dll
    - Classes
      - TrainServiceRunner.cs
    - clientaccesspolicy.xml
    - crossdomain.xml
    - Duplex.svc
    - Duplex.svc.cs
    - IDuplex.cs
    - Model
      - Author.cs
    - obj
      - Debug
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - Service References
    - wcfDuplex.csproj
    - wcfDuplex.csproj.user
    - Web.config
    - Web.Debug.config
    - Web.Release.config
  - WcfService1
    - App_Data
    - bin
      - System.ServiceModel.PollingDuplex.dll
      - WcfSqlNotifications.dll
    - clientaccesspolicy.xml
    - crossdomain.xml
    - ISqlNotifications.cs
    - Model
      - Employees.cs
    - obj
      - Debug
        
        Package
        
        TempPE
    - Properties
      - AssemblyInfo.cs
    - Service References
      - DuplexServiceReference
        
        BrowserDuplex.disco
        
        BrowserDuplex.wsdl
        
        BrowserDuplex.xsd
        
        BrowserDuplex1.xsd
        
        BrowserDuplex2.xsd
        
        configuration.svcinfo
        
        configuration91.svcinfo
        
        Reference.cs
        
        Reference.svcmap
        
        WcfSqlNotifications.DuplexServiceReference.Employee.datasource
    - SqlEventsService.csproj
    - SqlEventsService.csproj.user
    - SqlEventsService.Publish.xml
    - SqlNotifications.svc
    - SqlNotifications.svc.cs
    - Web.config
    - Web.Debug.config
    - Web.Release.config
database.zip
- dependencyDB.mdf
- dependencyDB_log.ldf

<?xml version="1.0"?>

<!-- For more information on using web.config transformation visit http://go.microsoft.com/fwlink/?LinkId=125889 -->

<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">

</configuration>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Bert O Neill

Architect

Ireland

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Silverlight 4 with (HTTP) Duplex and SQL Notifications

License

Comments and Discussions