Skip to content

Deep in the Code

  • Mr. CSV Transformer
  • QSL Query for Google Glass
  • Résumé

C#

Dynamically Setting the Connection String for Session State on SQL Server

2022.12.162012.05.30 by David Young
SQL Server logo

In ASP.NET, there are four ways to store Session State.  The way I prefer to store it is using SQL Server.  However, instead of storing it in the ASPstate database, which is the default way to store it on SQL Server, I choose to store it in the application database, which is a “custom SQL … Read more

Share this:

  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on Reddit (Opens in new window) Reddit
  • Share on Facebook (Opens in new window) Facebook
  • Share on X (Opens in new window) X
  • Share on Pinterest (Opens in new window) Pinterest
  • More
  • Print (Opens in new window) Print
  • Share on Tumblr (Opens in new window) Tumblr
  • Email a link to a friend (Opens in new window) Email

Like this:

Like Loading…
Categories ASP.NET, C#, MS SQL Server Tags ASP.NET, ASPstate, dynamic connection string, PartitionResolver, Session State Leave a comment
Newer posts
← Previous Page1 Page2

Search this Blog!

Nota bene: The first four or five results will be ads, not local search results.

My LinkedIn profile

Link to Profile

2026 Reading Challenge

2026 Reading Challenge
David has read 2 books toward his goal of 12 books.
hide
2 of 12 (16%)
view books

Archives

Stack Overflow

profile for David Young on Stack Exchange, a network of free, community-driven Q&A sites

Resources

  • Andy Hunt's blog
  • Coding Horror
  • Dave Thomas's blog
  • Joel on Software
  • musicForProgramming();
  • PROGRAMMING, ZBGURESHPXRE
  • Ruby on Rails Tutorial by Michael Hartl
  • Facebook
  • RSS Feed
  • GitHub
  • Instagram
  • X
  • Twitch

Content Safety

HERO

deepinthecode.com

Trustworthy

Approved by Sur.ly

2023
© 2026 Deep in the Code • Built with GeneratePress
%d