C
C#•2y ago
Lewis C

❔ Send API response to a SQL Server Table

I have a basic console app that does a post request on a API and prints the returning json to the console. I’d like to “import” this into an existing table on a MS SQL Server database. Is this possible. I’ve tried some examples out there but they don’t work for my example. Any help is appreciated
6 Replies
Becquerel
Becquerel•2y ago
yes, this is possible - you'll first have to take the JSON and 'deserialize' it into an in-memory object then send that in-memory object to your database with a db provider such as ADO.NET (low-level), Dapper (medium-level), or Entity Framework (high-level)
Becquerel
Becquerel•2y ago
you can use https://json2csharp.com/ to generate a class definition for your json
Convert JSON to C# Classes Online - Json2CSharp Toolkit
Convert any JSON object to C# classes online. Json2CSharp is a free toolkit that will help you generate C# classes on the fly.
Becquerel
Becquerel•2y ago
then System.Text.Json.JsonSerializer.Deserialize<YourGeneratedType>(yourJsonString) Dapper is fairly simple to use and lets you execute raw SQL, if you're comfortable with it
Lewis C
Lewis C•2y ago
It’s currently stored as a string so in the (yourJsonString) is just put the name of the string
Becquerel
Becquerel•2y ago
that's correct
Accord
Accord•2y ago
Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.
Want results from more Discord servers?
Add your server
More Posts
❔ Login Sql errorThis error displays when i click on my button "entrar" to login with my account can anyone tell me w❔ Restoring project with DB Schema only with EF and NET FrameworkI am restoring a Database from a .bak file whenever I try to query something from DB, there is a lacissue with key input in if statementhaving issues detecting when the i key is pressed it runs the code when i dont press it?✅ What is the use of these different versions of the same DLL?I request you to please tell me there uses like I am 10.having issues carrying variables to methodsi cant quite figure it out❔ xamarin listview doesnt updatehi so i have a weird problem in my code behind i have 2 methods ```cs private void SearchLis❔ Touch number pad in Windows 11Hi, I'm trying to find out, how to get this number pad. Problem is, I'm creating cash system, which ❔ my delegate event is not raising the eventi defined a event in my CustomerViewModel to pass the data to my main viewModel and raise a new evenError with app send emailThe goal is to make a send emails app from c# , later on to also send with attachments but im stuck ❔ Can someone help me with my snake game?Hi everyone reading this. I’m pretty new to C#, so please go easy on me. I have a snake-game (wpf)