How to extract information from json and write it to ms sql?

Question

JSON

There is an mvc project, I need to extract certain information from the json file and write it to the sql database, then output it from the database to the view. I have no idea how to extract and write to the database from json file? Do you have examples with descriptions or can you give examples yourself?

Answer 1

Apparently take a library for json processing, like everything else...

Answer 2

www.newtonsoft.com/json

Answer 3

MS SQL 2016 parses json perfectly. You can read more on the hub .