• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

Multi user problem asp.net


I have created a prototype asp.net application that uses framework v2 in c#.  I have used session variables and apply standard insert statements to update a sql server database as needed - however, when more than one user is logged into the website, only the records created by a single user make it to the database.  

SessionState mode is set to inproc, the default.  I am using basic forms authentication with a sql server table of usernames/passwords.  What are the possible causes?

1 Solution
It sounds like this is most likely totally unrelated to session issues.

Probable causes:

1. Your users' sessions are all calling some shared code for the DB update, and the shared code isn't thread safe. E.g. Your code might not open and close connections properly or commit transactions properly if multiple threads are simultaneously accessing the code.

2. Your app is encountering DB concurrency errors where multiple users are trying to update the same data simultaneously. If this is the case, an Exception should occur somewhere. If you aren't seeing any logs of such an occurrence, your event handling code may be "hiding" the exception if you aren't dealing with them properly.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now