Click here to Skip to main content
15,889,992 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
MVC newbie here.

Is sql server (sqlite, sqlexpress etc) overkill for data persistence?

I have many variables that I have persisted to the disk in XLS for access across sessions. When 2D arrays became part of the party, I went to binary serialization. good.

Then I came to a roadblock where the mvc controller does a return(redirect for action) for which no Veiwbag, TempData can survive. [Session] seems even like more of a kludge than the former two.

The problem is, I don't think I'm going to be deserializing the binary data within an html file. I know I can run script code but there are limitations to what can be done there (I surmise)

I know I can do database queries in script code within the html file but I need some flat quick data storage that can be written by .net but also accessed for within the running view html code.

Last night I thought, well I'm going to need a database.
Now I wonder If i'm barking up the wrong tree and overthinking it all.

What I have tried:

XML serialization.
Binary Serialization
Viewbag
TempData
A Good night's sleep. :-)
Posted
Updated 12-Feb-20 17:52pm

1 solution

I can't delete this but I want to tell all that come here I fixed it and found a way to make ViewBag workin this instance. It's not earth shattering, I was being a more-Ron.
 
Share this answer
 
Comments
Patrice T 13-Feb-20 5:05am    
Use Accept answer to close the question.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900