Databases
StackOverflow2013
Postsdbo
POConverting JSON to C# classes in ASP.Net MVC
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConverting JSON to C# classes in ASP.Net MVC
    primarykey
    data
    text
    <p>I'm trying to write an API - the expected output (for a 3rd party) as shown on their website is the JSON below:</p> <pre><code>{ "api_version" : 4 , "hotel_ids" : [97497], "hotels" : [ { "hotel_id": 97497, "room_types": { "Fenway Room": { "url": "someurlhere", "price": 178.50, "room_code": "SINGLE" } } } ] } </code></pre> <p>I'm using the online tool: <a href="http://json2csharp.com/" rel="nofollow">http://json2csharp.com/</a></p> <p>It gives me the following classes:</p> <pre><code>public class FenwayRoom { public string url { get; set; } public double price { get; set; } public string room_code { get; set; } } public class RoomTypes { public FenwayRoom __invalid_name__Fenway Room { get; set; } } public class Hotel { public int hotel_id { get; set; } public RoomTypes room_types { get; set; } } public class RootObject { public int api_version { get; set; } public List&lt;int&gt; hotel_ids { get; set; } public List&lt;Hotel&gt; hotels { get; set; } } </code></pre> <p>You can see in RoomTypes:</p> <p><code>FenwayRoom __invalid_name__Fenway Room { get; set; }</code></p> <p>I'm wondering if their spec for the JSON is wrong, or is there a way for me to create the classes to return the JSON they are expecting?</p> <p>In the example, I believe the room type "Fenway Room" is a variable - so I don't think it can also be a class name. But it may just be that I don't know how to create a class like this.</p> <p>I just can't figure out the "Fenway Room" - which I think needs to have something like: "Room Name":"Fenway Room" - but maybe there is another way of defining the classes so that it doesn't need a label "Room Name".</p> <p>I'd appreciate any help in confirming if it is possible to create classes to match against their JSON.</p> <p>Thanks, Mark</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMark
    1. USMark
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. 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. POConverting JSON to C# classes in ASP.Net MVC
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POConverting JSON to C# classes in ASP.Net MVC
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POConverting JSON to C# classes in ASP.Net MVC
      1. This table or related slice is empty.
      1. VTUpMod
    1. CODid you try `JavaScriptSerializer` ? It has a generic method to convert Here is a link to check out http://msdn.microsoft.com/en-us/library/bb355316.aspx
      singulars
      1. POConverting JSON to C# classes in ASP.Net MVC
      1. USAlex Denysenko
    2. COThe problem seems to be "Fenway Room" having a space in it - therefore that tool can't auto-generate a mapping for it since spaces aren't allowed in identifiers. So you may have to use some custom serialisation technique that doesn't rely on direct identifier mapping. Of course if the supplier can modify their feed to remove the space, all the better
      singulars
      1. POConverting JSON to C# classes in ASP.Net MVC
      1. USStephen Byrne
    3. COHi Alex - no, what is that? I have to create the object to return in my MVC C# code - and the object has to return example code that is pasted first above. I just can't figure out the "Fenway Room" - which I think needs to have something like: "Room Name":"Fenway Room" - but maybe there is another way of defining the classes so that it doesn't need a label "Room Name". Thanks, Mark
      singulars
      1. POConverting JSON to C# classes in ASP.Net MVC
      1. USMark
 

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