Need some help parsing and saving JSON to SQL Server
- or -
Post a project like this- Posted:
- Proposals: 11
- Remote
- #1361190
- Completed
Description
Kind of development: New program from scratch
Num. of modules: 1
Description of requirements/functionality: I have a text file with the 2 JSON results (attached) i need to save to a SQL Server database. Project request is for someone to create a "helper" module that I can use to parse each of the JSON sets and save the result to SQL Server. I want to be able to call the helper module from my main console app and pass it the JSON to be saved to SQL Server. Table structure has not been defined, so anything suitable to store JSON results is acceptable.
Specific technologies required: C# / SQL Server / JSON
OS requirements: Windows
Extra notes:
Eduard E.
92% (13)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Means you want helper which will call from your consol application and it will save JSON to SQL Server, because design not fixed. Right?
Waiting for your reply -
Hi Eduard!
I have a couple of questions about the task:
1) Which .NET / SQL server version should be used?
2) What do you want to have as the result of the job: console application (executable), dll library or a code snippet?
3) I presume, database interaction can be done via pure ADO.NET, correct?
4) Managed to review JSON example you shared and it is not quite clear about DB structure to be created.
On the one hand the JSON can be stored as NVARCHAR(MAX) string, which is not what you want, as far as I see. On the other hand, creating a clear and well-normalized schema may take much efforts.
So, do you have any requirements to the schema? Do you want everything to be normalized or some parts (e.g. "suggestions" and "descriptions" arrays from the first example; "ingredients" array from the second example) can be stored as strings?
Thanks,
Dmitry -
Hi Eduard,
Can you please elaborate what did you mean by module ? is it a .net application ?
Thank you.