Author: Coool | Posted on: 11/6/2009 5:45:44 AM | Views : 431

Hi all,
I have made very simple demo application to run it under middle trust environment. But I have a requirement to use sql session state. As, default sql session state provider read configuration file, it fails in middle trust environment. So, I have quickly created simple custom state provider (I used reference for microsoft website.).
It runs fine when the session is created but then after it hangs when I refresh my page when the same session data is loaded from database.


I hope someone can help me for this.
Thanks in Advanced




Here is the complete code for sql server (tables and stored procedures).
-------------------------------------------------------------------------------------------




GO /****** Object: Table [dbo].[tblSessions] Script Date: 11/06/2009 18:09:59 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET AN ...

Go to the complete details ...