Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I see a couple of problems with what you have. The first is the structure of the classes you have to deserialize the json data into. Manually writing up classes for this is really tedious and error-prone, and so I generally like to use <a href="http://json2csharp.com/" rel="noreferrer">this site</a> to plug in the json and get out the classes I need and rename as appropriate. I'd then go and find the <a href="https://github.com/reddit/reddit/wiki/API%3A-info.json" rel="noreferrer">api docs</a> for the data to fill in any gaps in the classes that the data simply just didn't have.</p> <p>After that, you only need to deserialize a single instance of the root object class that you now have, rather than a List of them, so something like:</p> <pre><code>RootObject topics = JsonConvert.DeserializeObject&lt;RootObject&gt;(json); </code></pre> <p>One other note is that when you're deserializing your data, in your code, you're currently declaring a new local variable called <code>topics</code> which hides your member variable that is also called <code>topics</code> in that particular scope and so if you ever inspect that member variable, you would see that it won't have any data in it. You don't want to be declaring a new variable there, you just want to use the existing member variable, so instead of the previous line, you would just want to do:</p> <pre><code>topics = JsonConvert.DeserializeObject&lt;RootObject&gt;(json); </code></pre> <p>Or even <code>this.topics</code> if you want to be really explicit and clear about where that variable is coming from.</p>
    singulars
    1. This table or related slice is empty.
    1. POConverting json to custom object array
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USGarrett Kiel
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POConverting json to custom object array
      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. VTAcceptedByOriginator
    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. COThanks for the reply. I have updated my program to abide by what you said and things are better, but I am still having some issues(my own fault). These issues stem from the redditObject class, which I have left called RootObject. When I try to pull a value out of the data2 class, it says I need to create a new instance of that class. However, i'm not exactly sure where to go about doing this. Suggestions? I'll keep at it. Also, I have updated the original post with the new code.
      singulars
      1. PO
      1. USWilcoholic
    2. COIs there a reason why your RootObject looks the way it does? When I run the json through the converter, I always get: `public class RootObject { public string kind { get; set; } public Data data { get; set; } }` Then, to get the title of the first item, you would do `topic.data.children[0].title`
      singulars
      1. PO
      1. USGarrett Kiel
    3. COAlso, it seems to me like you're not exactly clear on how the structure of the data works. The `RootObject` contains an instance of a `Data` class, which in turn contains an array of `Children`, each of which represents a single topic from all.json. So, you're still receiving a list of topics, as opposed to a single topic, but they're nested within a couple other data structures.
      singulars
      1. PO
      1. USGarrett Kiel
 

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