Databases
StackOverflow2013
Postsdbo
PO"State" management for asp.net mvc multi partial view + ajax app
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO"State" management for asp.net mvc multi partial view + ajax app
    primarykey
    data
    text
    <p>I am trying to convert my asp.net mvc4 app, which had fairly heavy use of SessionState, into a stateless app. I understand that I can store this information in the DB, and intend to do so.</p> <p>My question, though, is about my particular architecture. My app has a main 'page' consisting of a number of partial view panels, which each have actions in them that can affect the other panels. What i've been doing up to now is storing the entire state of the viewModel (lots of inter-related EF list collections and 'record' objects) in the session, and its been working great. Except when the session just randomly dies.</p> <p>So, I need to get this data out of the session, and into the DB where I can rebuild the thing at need. My concern is that, if I store the info in the database, every single action done on screen might affect 3-5 different panels, each with their own State updates, thats a minimum of 10 round trips to the DB for every interaction!</p> <p>What are some strategies I can use to make this idea more scalable?</p> <h3>EXTRA INFO</h3> <p>The view in question here is a sort of POS shopping cart system. There are panels for selecting events, selecting/adding items to the cart, editing cart items, selecting contacts, editing contacts, displaying the cart items, displaying the cart 'subtotals', and finally, a panel with a [checkout] button.</p> <p>Selecting a new event will change the list of available items. Selecting an item to add to the cart will change the cart item list, subtotals, as well as the checkout panel. Same for editing a cart item.</p> <p>The main concern is how to recover from a lost session, as I've found the built-in asp.net session code too unreliable. My testers have encountered issues with sessions timing out, and then my app not having any kind of recovery process. When its installed on 1500 sites, each with an average of 10 users, its going to be a plague of lost session issues, and I need to combat that before it becomes a real problem.</p> <p>I agree that I'm not going stateless...wrong choice of words used in a rush. I'm just trying to move that state into a form that I can rely on past the session failure. My main idea presently is to continue using the session as the local cache for the viewModel data, but to have a fallback operation that can rebuild the viewModel from DB if the session one is lost somehow.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USreidLinden
    1. USreidLinden
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO"State" management for asp.net mvc multi partial view + ajax app
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO"State" management for asp.net mvc multi partial view + ajax app
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO"State" management for asp.net mvc multi partial view + ajax app
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCould you give a brief example of the complex parts of the viewModel? Would help us come up with better concrete examples to answer your question.
      singulars
      1. PO"State" management for asp.net mvc multi partial view + ajax app
      1. USLarsenal
    2. CODatabase "round trips" are relatively cheap (especially with connection pooling) when compared to Web-request "round trips". Moving from SessionState to a DB isn't really making it "stateless" (and the session can be backed by a DB anyway), it's just changing the data lifetime rules and how the state is persisted. Does this change *really reflect* the lifetime/scope of the data?
      singulars
      1. PO"State" management for asp.net mvc multi partial view + ajax app
      1. USuser2246674
    3. COaddressed both above comments in post. thanks.
      singulars
      1. PO"State" management for asp.net mvc multi partial view + ajax app
      1. USreidLinden
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload