My web application is in ASP.NET 4.0 C#, in which i have also use of WCF services and maintain session with create random userID. Application is about Video Management System. When I am request to start streaming to VSS(Video Streaming Server), at that time I will insert all streaming details for requested camera and user into SQL server table. And on disconnect the video streaming of that particular camera, i will remove that entry from table of that user only. Other users entry will be remaining as it is if others see the Live Streaming.
While any how some networks disconnected or browser crash this entry will not be clear. So i would like to know that how can I know that one client is disconnected and i need to clear its data mapping with that userID only using check that session of that user is alive or not, if not need to clear data from Sql table.
Please help me to solve this issue.