Click here to Skip to main content
15,886,873 members
Articles / Web Development

Silverlight 4 with (HTTP) Duplex and SQL Notifications

Rate me:
Please Sign up or sign in to vote.
4.92/5 (7 votes)
17 Jan 2011CPOL4 min read 45.9K   2K   27  
Get updates to your browser immediately when a change has occurred within the database.
  • code.zip
    • Code
      • SLDuplexDependency.sln
      • SLDuplexDependency.Web
      • 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
        • obj
          • Debug
            • TempPE
        • Properties
        • Service References
        • ServiceReferences.ClientConfig
        • SLDuplexDependency.csproj
        • SLDuplexDependency.csproj.user
      • wcfDuplex
      • WcfService1
  • database.zip
    • dependencyDB.mdf
    • dependencyDB_log.ldf
using System;
using System.Collections.Generic;
using System.Linq;
using System.ServiceModel;
using System.Web;
using SLDuplexDependency.Web.Classes;

namespace SLDuplexDependency.Web.DBNotificationService
{
	/// <summary>
	/// This is an implementation of IDBNotificationService interface
	/// </summary>
	[ServiceBehavior(ConcurrencyMode = ConcurrencyMode.Multiple, InstanceContextMode = InstanceContextMode.Single)]
	public class DBNotificationService : IDBNotificationService 
	{
		/// <summary>
		/// The object used to lock code down when it is editing static data
		/// </summary>
		private Object syncRoot = new Object();		

		/// <summary>
		/// This method should be executed to subscribe to notifications from server.
		/// </summary>
		public void SubscribeToNotifications()
		{
			IDBNotificationCallbackContract ch = OperationContext.Current.GetCallbackChannel<IDBNotificationCallbackContract>();
			string sessionId = OperationContext.Current.Channel.SessionId;

			//Any message from a client we haven't seen before causes the new client to be added to our list			
			lock (syncRoot)
			{
				if (!SilverlightClientsList.IsClientConnected(sessionId))
				{
					SilverlightClientsList.AddCallbackChannel(sessionId, ch);
					OperationContext.Current.Channel.Closing += new EventHandler(Channel_Closing);
					OperationContext.Current.Channel.Faulted += new EventHandler(Channel_Faulted);
				}
			}
		}

		/// <summary>
		/// Handles the Closing event of the Channel control.
		/// </summary>
		/// <param name="sender">The source of the event.</param>
		/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
		private void Channel_Closing(object sender, EventArgs e)
		{
			IContextChannel channel = (IContextChannel)sender;
			ClientDisconnect(channel.SessionId);
		}

		/// <summary>
		/// Handles the Faulted event of the Channel control.
		/// </summary>
		/// <param name="sender">The source of the event.</param>
		/// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
		private void Channel_Faulted(object sender, EventArgs e)
		{
			IContextChannel channel = (IContextChannel)sender;
			ClientDisconnect(channel.SessionId);
		}

		/// <summary>
        /// Disconnect the client.
		/// </summary>
		/// <param name="sessionId">The session id.</param>
		private void ClientDisconnect(string sessionId)
		{
			lock (syncRoot)
			{
				if (SilverlightClientsList.IsClientConnected(sessionId))
					SilverlightClientsList.DeleteClient(sessionId);
			}
		}

		/// <summary>
		/// This method should be executed to unsubscribe to notifications from server.
		/// </summary>
		public void UnsubscribeToNotifications()
		{
			ClientDisconnect(OperationContext.Current.Channel.SessionId);
		}		
	}
}

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
Architect
Ireland Ireland
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions