How to map JSON to SQL schema?

Question

I have a complex JSON object that I want to save and manage / modify in a database. Are there any JSON link managers to convert to a SQL schema, or some kind of strategy for doing this manually?

This is an example of a JSON object. I need a circuit for:

{ "action": "index.html", "method": "post", "elements": [ { "type": "fieldset", "caption": "User information", "elements": [ { "name": "email", "caption": "Email address", "type": "text", "placeholder": "Eg [e-mail] ", "validate": { "email": true } }, { "name": "password", "caption": "Password", "type": "password", "id": "registration-password", "validate": { "required": true, "minlength": 5, "messages": { "required": "Please enter a password", "minlength": "At least {0} characters long" } } }, { "name": "password-repeat", "caption": "Repeat password", "type": "password", "validate": { "equalTo": "#registration-password", "messages": { "equalTo": "Please repeat your password" } } }, { "type": "radiobuttons", "caption": "Sex", "name": "sex", "class": "labellist", "options": { "f": "Female", "m": "Male" } } ] ] } 

I will probably use a key / value pair to carry them through code, but I think I need a great database strategy first. Any help or ideas would be very helpful.

Answer 1

Take a look at Parse JSON in C #

You must create entities for the end of your data, and then deserialize your json for these objects.