using System;

using Dapper;

using System.Data;

using MySql.Data.MySqlClient;

using System.Collections.Generic;

using System.Linq;

using System.Text.Json;

//using MySqlConnector;

​

public enum Permissions{

Create,Update,Delete

}

​

public class Program

{

    public static void Main()

    {

        string ConnectionString = "User Id=root;Host=vtnltd.com;Character Set=utf8;password=mmttmhh;port=3306;database=WebMVC;";

        IDbConnection Connection = new MySqlConnection(ConnectionString);

        string sql = @"SELECT Permission FROM rolepermissions WHERE RoleName In @roles";

        var roles = new List<string>(new string[]{"2","5dd52908-34ff-44f8-99b9-0038afefdb81"});

        var ListPermissions = Connection.QueryAsync<string>(sql, new { roles }).Result;

        //ListPermissions.ToList().ForEach(x=> JsonSerializer.Deserialize<IEnumerable<Permissions>>(x));

         var permisstions = ListPermissions.SelectMany(Json => JsonSerializer.Deserialize<IEnumerable<Permissions>>(Json))

            .ToList()

            .Distinct()

            ;

        FiddleHelper.WriteTable(permisstions);

         //permisstions.ToList().ForEach(x=>FiddleHelper.WriteTable(x));

    }

}