I fear you don't really understand what you talk about.
Quote:
I want to receive the json array and store that data in SQL using C#
is there any open source to do that job
This is exactly what does your SQL server.
Your app send the json data with a query to the SQL server.
And the SQL server "receive the json array and store that data in SQL" database.
There is no need of intermediate app.