Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The default deserializer for the client uses .NET's binary serializer, so when you save or read a JSON string, it's just a string. GetJson will always just return a string. However, there are a couple of options:</p> <p>You could convert JSON records to Dictionary instances:</p> <pre><code>var appJson = "{ \"UsersOnline\" : 1, \"NewestMember\" : \"zblock\" }"; var result = client.ExecuteStore(StoreMode.Set, "userCount", appJson); var item = client.GetJson&lt;Dictionary&lt;string, object&gt;&gt;("userCount"); Console.WriteLine("There are {0} users online. The newest member is {1}.", item["UsersOnline"], item["NewestMember"]); </code></pre> <p>Or you could use a dynamic ExpandoObject instance:</p> <pre><code>var appJson = "{ \"UsersOnline\" : 1, \"NewestMember\" : \"zblock\" }"; var result = client.ExecuteStore(StoreMode.Set, "userCount", appJson); dynamic item = client.GetJson&lt;ExpandoObject&gt;("userCount"); Console.WriteLine("There are {0} users online. The newest member is {1}.", item.UsersOnline, item.NewestMember); </code></pre> <p>In either case you're losing static type checking, which seems like it's OK for your purposes. In both cases you get access to the JSON properties without having to parse the JSON into a POCO though...</p> <p>Edit: I wrote a couple of extension methods that may be useful and blogged about them at <a href="http://blog.couchbase.com/moving-no-schema-stack-c-and-dynamic-types" rel="nofollow">http://blog.couchbase.com/moving-no-schema-stack-c-and-dynamic-types</a></p>
    singulars
    1. This table or related slice is empty.
    1. POCouchbase - deserialize json into dynamic type
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJohn Zablocki
    1. USJohn Zablocki
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POCouchbase - deserialize json into dynamic type
      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
    1. COHi John, thanks for the answer - where is the item variable coming from in the above examples? Also how are the records being converted to dictionaries? It's morning so I might just need my coffee before I can understand this, cheers
      singulars
      1. PO
      1. USmanagedheap84
    2. COOops! I forgot to copy & paste the most important lines - the actual Get. Sorry about that. I've updated the code to include the item assignment.
      singulars
      1. PO
      1. USJohn Zablocki
    3. COExpandoObject was exactly what I was looking for - Ended up creating a 5 line POCO in the .cs file, but these are some good alternatives, cheers!
      singulars
      1. PO
      1. USmanagedheap84
 

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