How to use C# connect to mysql and get json data?
<p>As mentioned above:</p>

<p>I'm using <code>C#</code> to connect to a <code>MySQL</code> database and I want to read <code>JSON</code> data type.
I use the method <code>MySqlCommand.ExecuteReader</code>:</p>

<pre><code>using (MySqlConnection sconn = new MySqlConnection(sqlConnectString))  
{      
    sconn.Open(); 
    String sql_Command = @"SELECT `id` FROM  orders.jsontest;"; 

    using (MySqlCommand scmd = new MySqlCommand(sql_Command, sconn))
    {
        **MySqlDataReader sdr = scmd.ExecuteReader();**  // fatal error
        DataTable datatable = new DataTable();

        // ...
    }
}
</code></pre>

<p>Can it be that I cannot use <code>ExecuteReader</code> here?</p>