JSON to INSERT SQL

Question

I've been looking everywhere, can't seem to find a solution. I have a very long string in a textfile. It's already in a Json format i.e.

[{"column":"data", "anothercolumn":"data"}, {"column":"data", "anothercolumn": "data"}]

I want to convert this to an INSERT MS SQL statement using C#. Is there any way to do this? I can't figure it out myself using DeserializeObject or DataSets and DataTables. Help is much appreciated.

have you looked at the following Json to C# Class Converter from there you could get the data into a Class and from there into DataTables etc.. or[ convert the json to CSV](konklone.io/json) — MethodMan
– MethodMan, Commented Jan 25, 2016 at 22:23
What is the problem exactly? If you have a known database structure, then deserializing the JSON string using a POCO object created by (for example) EF will work. — keenthinker
– keenthinker, Commented Jan 25, 2016 at 22:28

Heinzi · Accepted Answer · 2016-01-25 22:24:58Z

3

Deserialize the JSON string into an array of dictionaries.
Loop through the array.
Using the dictionary keys, create an SQL statement of the form: INSERT INTO myTable (key1, key2, ...) VALUES (@key1, @key2, ...).
Looping through the dictionary's key-value-pairs, add the values as parameters: AddWithValue("@" + key, value).
Execute the SQL statement.
Profit.

The implementation is left as an exercise.

answered Jan 25, 2016 at 22:24

Heinzi

173k61 gold badges386 silver badges554 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JSON to INSERT SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related