Databases
StackOverflow2013
Postsdbo
POBest way to store data locally in .NET (C#)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBest way to store data locally in .NET (C#)
    primarykey
    data
    text
    <p>I'm writing an application that takes user data and stores it locally for use later. The application will be started and stopped fairly often, and I'd like to make it save/load the data on application start/end.</p> <p>It'd be fairly straightforward if I used flat files, as the data doesn't really need to be secured (it'll only be stored on this PC). The options I believe are thus:</p> <ul> <li>Flat files</li> <li>XML</li> <li>SQL DB</li> </ul> <p>Flat files require a bit more effort to maintain (no built in classes like with XML), however I haven't used XML before, and SQL seems like overkill for this relatively easy task.</p> <p>Are there any other avenues worth exploring? If not, which of these is the best solution?</p> <hr> <p>Edit: To add a little more data to the problem, basically the only thing I'd like to store is a Dictionary that looks like this</p> <pre><code>Dictionary&lt;string, List&lt;Account&gt;&gt; </code></pre> <p>where Account is another custom type.</p> <p>Would I serialize the dict as the xmlroot, and then the Account type as attributes?</p> <hr> <p>Update 2:</p> <p>So it's possible to serialize a dictionary. What makes it complicated is that the value for this dict is a generic itself, which is a list of complex data structures of type Account. Each Account is fairly simple, it's just a bunch of properties.</p> <p>It is my understanding that the goal here is to try and end up with this:</p> <pre><code>&lt;Username1&gt; &lt;Account1&gt; &lt;Data1&gt;data1&lt;/Data1&gt; &lt;Data2&gt;data2&lt;/Data2&gt; &lt;/Account1&gt; &lt;/Username1&gt; &lt;Username2&gt; &lt;Account1&gt; &lt;Data1&gt;data1&lt;/Data1&gt; &lt;Data2&gt;data2&lt;/Data2&gt; &lt;/Account1&gt; &lt;Account2&gt; &lt;Data1&gt;data1&lt;/Data1&gt; &lt;Data2&gt;data2&lt;/Data2&gt; &lt;/Account2&gt; &lt;/Username2&gt; </code></pre> <p>As you can see the heirachy is </p> <ul> <li>Username (string of dict) > </li> <li>Account (each account in the List) > </li> <li>Account data (ie class properties). </li> </ul> <p>Obtaining this layout from a <code>Dictionary&lt;Username, List&lt;Account&gt;&gt;</code> is the tricky bit, and the essence of this question.</p> <p>There are plenty of 'how to' responses here on serialisation, which is my fault since I didn't make it clearer early on, but now I'm looking for a definite solution.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USGeorge
    1. USGeorge
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POBest way to store data locally in .NET (C#)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POBest way to store data locally in .NET (C#)
      1. USmcauthorn
      1. VTFavorite
    3. VO
      singulars
      1. POBest way to store data locally in .NET (C#)
      1. USkloucks
      1. VTFavorite
    1. COgive more ditails about the kind of application, and the data stored, also the excpected sizr
      singulars
      1. POBest way to store data locally in .NET (C#)
      1. USAK_
    2. COFor serializing a dictionary: http://stackoverflow.com/questions/1111724
      singulars
      1. POBest way to store data locally in .NET (C#)
      1. USCheeso
 

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