c#从mysql中提取json格式的数据

using System;
using MySql.Data.MySqlClient;
using Newtonsoft.Json;

namespace MySQLJsonExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "server=localhost;user=root;database=mydatabase;password=mypassword";
            
            MySqlConnection connection = new MySqlConnection(connectionString);
            connection.Open();
            
            string query = "SELECT json_data FROM mytable";
            
            MySqlCommand command = new MySqlCommand(query, connection);
            MySqlDataReader reader = command.ExecuteReader();
            
            while (reader.Read())
            {
                string jsonData = reader.GetString("json_data");
                MyObject myObject = JsonConvert.DeserializeObject<MyObject>(jsonData);
                
                // 处理提取的JSON数据
                Console.WriteLine(myObject.Property1);
                Console.WriteLine(myObject.Property2);
            }
            
            reader.Close();
            connection.Close();
        }
    }
    
    class MyObject
    {
        public string Property1 { get; set; }
        public string Property2 { get; set; }
    }
}