Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you don't need to be able to edit the files by hand you could try using the BinaryFormatter to serialize &amp; deserialize your data, should be a lot faster than the XmlSerializer.</p> <p>Here is an example of how to use it.</p> <pre><code>using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows; using System.Windows.Controls; using System.Windows.Data; using System.Windows.Documents; using System.Windows.Input; using System.Windows.Media; using System.Windows.Media.Imaging; using System.Windows.Navigation; using System.Windows.Shapes; namespace WpfApplication2 { [Serializable()] public class Child { public string Property1 { get; set; } } [Serializable()] public class TestClass { public int Property1 { get; set; } public string Property2 { get; set; } public DateTime Property3 { get; set; } public Child Child { get; set; } } /// &lt;summary&gt; /// Interaction logic for MainWindow.xaml /// &lt;/summary&gt; public partial class MainWindow : Window { public MainWindow() { InitializeComponent(); TestClass testClass = new TestClass() { Property1 = 1, Property2 = "test", Property3 = DateTime.Now, Child = new Child() { Property1 = "test", } }; System.Runtime.Serialization.Formatters.Binary.BinaryFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); System.IO.MemoryStream memoryStream = new System.IO.MemoryStream(); formatter.Serialize(memoryStream, testClass); memoryStream.Position = 0; TestClass deserialized = formatter.Deserialize(memoryStream) as TestClass; } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POIs it better to save data in an XML or a database?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAndy
    1. USAndy
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs it better to save data in an XML or a database?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI like this best. You can combine this with GZipStream to compress the output, which I bet would make it quite a lot smaller for a large game save.
      singulars
      1. PO
      1. USMatthew Watson
    2. COApparently we have tried this in the past, but encountered an issue on serializing an object containing other objects. Any words of wisdom/links to content referencing that? A quick google search didn't show anything incredibly useful
      singulars
      1. PO
      1. USmikedugan
    3. COShould work fine, I've updated the example to show an object containing another object.
      singulars
      1. PO
      1. USAndy
 

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