CodeProject: ASP.NET session state store provider for MySql. Free source code and programming help

Announcements

	Windows 7 Comp Win a laptop!
	Monthly Competition

Articles

Desktop Development

Web Development

Enterprise Systems

Content Management Server

Microsoft BizTalk Server

SQL Reporting Services

Platforms, Frameworks & Libraries

Windows Communication Foundation

Windows Presentation Foundation

Windows Workflow Foundation

Cryptography & Security

Threads, Processes & IPC

WinHelp / HTMLHelp

Uncategorised Quick Answers

Graphics / Design

Expression

Usability

Development Lifecycle

Debug Tips

Design and Architecture

Uncategorised Technical Blogs

Services

Code-signing Certificates

Job Board

CodeProject VS2008 Addin

Feature Zones

Product Showcase

Code Signing Resources

WhitePapers / Webcasts

ASP.NET Web Hosting

Advanced Search
Add to IE Search

Discuss

Report

3 votes for this article.

Popularity: 1.11 Rating: 2.33 out of 5

Options

Disable

Put Snap Shots on Google

Options

Disable

Put Snap Shots on Google

Options

Disable

Get Snap Shots Free

Download MySqlSessionStateStore_v01.zip - 4.6 KB

Introduction

This article describes how to set-up an ASP.NET project in order to use MySql as its session state store provider.

Using the code

Looking on the web I was not able to find a suitable solution that uses MySql as its session state store. It may certainly be possible that there is already a better solution available (if so, please do not hesitate to contact me). However, I was able to find a sample session state store provider using MS Access. That's it! Port it to MySql ... and that's what I did.

But, let's do it step by step. The list below gives you an idea on what I did in order to get it to work:

Downloaded the sample session state store provider for MS Access from MSDN.
Downloaded the .NET Connector (using version 5.0.7) from MySql.
Ported the sample code provided by Microsoft for use with MySql (the zipped source code can be found here).
Adjusted the Web.config accordingly:

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

<connectionStrings>
<add name="MySqlSessionServices" connectionString="Database=<name of database>; Data Source=<host>; User Id=<login>; Password=<password>"/>
</connectionStrings>
<system.web>
<sessionState cookieless="false" regenerateExpiredSessionId="true" mode="Custom" customProvider="MySqlSessionProvider">
<providers>
<add name="MySqlSessionProvider" type="Samples.AspNet.Session.MySqlSessionStateStore" connectionStringName="MySqlSessionServices" writeExceptionsToEventLog="false"/>
</providers>
</sessionState>
</system.web>

</configuration>

You can check it out at www.kimpel.com ... it works like a charm .

Please do not hesitate to contact me if you have any questions and/or comments.

History

2007-09-20: initial version

2007-10-17: updated link to sources

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Harry Kimpel

Member

Occupation:	Web Developer
Location:	Germany

Other popular ASP.NET articles:

Multiple File Upload With Progress Bar Using Flash and ASP.NET
How to use Flash to upload multiple files in a medium-trust hosting environment
CAPTCHA Image
Using CAPTCHA images to prevent automated form submission.
10 ASP.NET Performance and Scalability Secrets
10 easy ways to make ASP.NET and AJAX websites faster, more scalable and support more traffic at lower cost
Exploring Session in ASP.Net
This article describe about session in ASP.Net 2.0 . Different Types of Session , There Configuration . Also describe Session on Web Farm , Load balancer , web garden etc.
Paging of Large Resultsets in ASP.NET
An article about optimization and performance testing of MS SQL Server 2000 stored procedures used for paging of large resultsets in ASP.NET

Article Top

You must Sign In to use this message board.

FAQ
Noise Tolerance Layout Per page

Msgs 1 to 3 of 3 (Total in Forum: 3) (Refresh)

FirstPrevNext

Great! [modified]

devjunkie

1:19 11 Jan '09

Great article!
Thanks a lot!

Thanks to Johannes as well for solving some issues too! Big Grin

I found yet another issue since i wanted a timeout of 60 minutes.
Line 680:

cmd.Parameters.Add("?Expires", MySqlDbType.Datetime).Value
              = DateTime.Now.AddMinutes(pConfig.Timeout.Minutes);

i needed to change this to

cmd.Parameters.Add("?Expires", MySqlDbType.Datetime).Value
              = DateTime.Now.AddMinutes(Convert.ToInt32(pConfig.Timeout.TotalMinutes));

otherwise my timeout was set to the creationtime of the session.

// Peter

modified on Sunday, January 11, 2009 6:53 AM

Bug... [modified]

Johannes75

0:44 1 May '08

Hi!

Thanks for a great script. Exactly what I needed Smile

However, I had an annoying bug, took me forever to find.....

Row 534 in your script:

cmd.Parameters.Add ("?Expires", MySqlDbType.Datetime).Value =
              DateTime.Now.AddMinutes (pConfig.Timeout.Minutes);

I had to change pConfig.Timeout.Minutes to pConfig.Timeout.TotalMinutes because my timeout is set to whole days which means that pConfig.Timeout.Minutes = 0.
And because of that, in row 453
item = CreateNewStoreData(context,pConfig.Timeout.TotalMinutes);
The double pConfig.Timeout.TotalMinutes needed to be cast to an int because pConfig.Timeout.Minutes is an int.

[Later added]
And I also found on row 577, in the SQL command

"DELETE * FROM 
sessions..."

. It should be "DELETE FROM sessions..."
without the '*'.
[/Later added]
/Johannes

modified on Thursday, May 1, 2008 7:00 AM

Will this work for ASP.NET 1.1?

ajdiaz

7:03 3 Jan '08

Will this work for ASP.NET 1.1? Or is this strictly for ASP.NET 2.0?
Sign In·View Thread·PermaLink

Last Visit: 2:58 8 Nov '09 Last Update: 2:58 8 Nov '09

General News Question Answer Joke Rant Admin

PermaLink | Privacy | Terms of Use
Last Updated: 18 Oct 2007
Editor: