Asp.Net  Store Application Data temporarily before sending to Database.

Posted on 2012-09-14
Last Modified: 2012-09-14
Hi Experts,
I have 4 Web forms in my Application
Ex: Patients Object
4 form display info like patientsInfo,Insurance Details,Billing Details etc which are editable.

My requirement is to collect information from each page ,save temporarily in the application
and in the final page save all the cached data to the Database.

This way we wanted to  avoid doing a save to database in each page & instead do it all at once in the final step to reduce Database hits.

Do i need to use any state management techniques like caching or session state , save the object in session state and finally collect all the data and save it to database.
Are  there any better techniques. to  this .Please advice.

Question by:B_Pati
    LVL 83

    Expert Comment

    You can store this data in session state but it will be lost if the user remains inactive for session to timeout or if user logs out etc. If the requirement is to save this data temporarily across sessions, then you would need to use database.
    LVL 1

    Author Comment

    Hi Crusier,
    Thanks for the reply ,  We don't want to hit database regularly for each page,  what are the other options you recomend to save data temporarily.
    Will any of Linq to Entities or Linq to data Set help me achieve this task.
    LVL 83

    Accepted Solution

    Options are

    1) Store in session - will be lost on logout, session timeout etc
    2) DB - permanent
    3) File system - permanent
    4) In memory database - semi permanent - only lost when system restarted.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
    ASP.Net to Oracle Connectivity Recently I had to develop an ASP.NET application connecting to an Oracle database.As I am doing it first time ,I had to solve several problems. This article will help to such developers  to develop an ASP.NET client…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now