Archive for September, 2011

ASP.NET Session State

Posted: September 21, 2011 in ASP.NET
Tags: ,

Default value is – 20 minutes and it can be increased to maximum of 24 hours or 1440 minutes.

You can change default value @ web.config level or IIS web site level.


IIS 6.0 Resource Kit – contains a utility called SelfSSL.exe for instantly creating and installing a self-signed testing certificate into IIS.  The tool is intended for IIS 6.0, but it works on IIS 5.1 also and it is simple to use.

  • Download IIS 6.0 Resource Kit Tools
  • Install the resource kit (requires Windows Server 2003, Windows XP)
    From the Windows Start Menu, go to the “\Programs\IIS Resources\SelfSSL” folder and select “SelfSSL”.
  • Instructions will be listed in a command prompt. Type “selfssl” to run the program.
  • Type “y” to confirm overriding/installing the certificate on the given site.
  • Test that it worked by visiting https://localhost/.


Step by step instructions to setup –

Download resource kit from

Book related to resource kit –

On setting the lazy loading attribute to true (Lazy loading property is on edmx file’s context object) helps to provide lazy loading of related entities data instead of loading them on the same time when the main entity is accessed.

Through .NET CLR Support in SQL Server –

Through .NET CLR Support in SQL Server + Deploy using Visual Studio’s SQL Server Project –

Through .NET CLR Support in SQL Server (msdn link) –

Using OLE Fn (SQL Server 2000) –

Default pattern matching support in SQL Server –