Manually store ASP.NET session object in database

• Thomas Lowry

  Valued Member

  Points: 68

  More actions

  November 10, 2007 at 6:28 am

  #180166

  I have an ASP.NET application where I need to allow users to save GIS map buffers for future use. These buffers are non-serializable objects, so I can't store them as XML. I can put them in the Session as objects, but now I need to manually put the in a custom SQL Server 2005 database. Would I put them in a varbinary(max) column, and if so, does anyone have an example of manually storing an ASP.NET session object in a database using ADO.NET? Thanks.

  Thomas

• Antares686

  SSC Guru

  Points: 125444

  More actions

  November 10, 2007 at 7:14 am

  #750049

  This might help

  http://www.faqfront.com/document/sql-server-session-state

  but when I last did this for testing I just searched on google for

  "asp session state sql"

  and

  "asp session state sql custom database"

  and you can of course narrow to just microsoft items by adding "site:microsoft..com"