title: How to map MySQL JSON column using Dapper
body: <p>I have a table in MySQL database which contains a JSON data type column. Is it possible to retrieve the JSON data stored in that column and map to my c# class using Dapper? Below is a sample JSON about how data is stored in column.</p>
  
  <pre><code>[
          {
              "ServerName": "",
              "Priority": 1,
              "FilesystemBasePath": "",
              "IsAvailable": 1,
              "ApplicationDocumentType": ""
          },
          {
              "ServerName": "",
              "Priority": 2,
              "FilesystemBasePath": "",
              "IsAvailable": 1,
              "ApplicationDocumentType": ""
          }
  ]
  </code></pre>
  
  <p>I want the data to be mapped to a <code>List&lt;MyObject&gt;</code> type in C#. </p>