Tool : Visual Studio 2017
Language: C#(WinForm)
The public data portal applies for and uses the COVID-19 outbreak status inquiry data (Xml) by city.
Currently, when you run a program with Visual Studio, it queries all the data immediately.
I'd like to add a city-specific search function here. However, we cannot search only with the request variables supported by the public data portal, so we are planning to add the search function by putting the Corona data into the DB using MySQL.
Although the Corona data is in Xml format, I wonder how to put it in DB because it seems to be an inquiry service using a key, not an Xml file.
Should I use C# to put public data (Xml) in MySQL? Or can I insert public data directly from MySQL?
c# mysql
xml is a document and mysql is rdbms.
This is rdbms, so schema is required.
In other words, you need to create a table with the field name of the element in xml, parse it, and save it.
That way, you can check with the select statement.
In fact, for questions such as questions (which are likely to only use queries), Document DB is better.
It's better to convert xml to json and search for something like mongodb.
© 2024 OneMinuteCode. All rights reserved.