namespace CampusUnionPlatform.JsonHelper
    {
        public class JsonHelper
        {
            public static string ToJson(Object obj, Type type)
            {

                MemoryStream ms = new MemoryStream();

                DataContractJsonSerializer seralizer = new DataContractJsonSerializer(type);


                seralizer.WriteObject(ms, obj);
                ms.Seek(0, SeekOrigin.Begin);

                StreamReader sr = new StreamReader(ms);
                string jsonstr = sr.ReadToEnd();

                //jsonstr = jsonstr.Replace("\"", "\\\"");

                sr.Close();
                ms.Close();
                return jsonstr;
            }
            public static Object FromJson(String jsonstr, Type type)
            {

                MemoryStream ms = new MemoryStream(Encoding.Unicode.GetBytes(jsonstr));

                DataContractJsonSerializer seralizer = new DataContractJsonSerializer(type);

                ms.Seek(0, SeekOrigin.Begin);

                Object res = seralizer.ReadObject(ms);


                ms.Close();
                return res;
            }

        }
    }

     String sql = "";

        MySqlConnection con= BF_MySqlConnecter.Connecter();
        con.Open();
        MySql.Data.MySqlClient.MySqlCommand com = new MySql.Data.MySqlClient.MySqlCommand(sql,con);
        MySql.Data.MySqlClient.MySqlDataReader reader = com.ExecuteReader();

        BF_Friend friendlist = new BF_Friend();
        friendlist.friends = new List<string>();
        while (reader.Read())
        {
            string jfrilist = reader.GetString(1);

            var ms = new MemoryStream(Encoding.Unicode.GetBytes(jfrilist));
            DataContractJsonSerializer deseralizer = new DataContractJsonSerializer(typeof(BF_Friendlist));
            BF_Friendlist model = (BF_Friendlist)deseralizer.ReadObject(ms);
            friendlist.idbutterfly_users= reader.GetString(0);
            friendlist.friends = model.friends;
            break;
        }


    public class BF_MySqlConnecter
        {
            public static MySqlConnection Connecter()
            {
                Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
                MySqlConnection con = new MySqlConnection("server=127.0.0.1;database=butterflycommunity;uid=root;pwd=0718;charset='utf8';SslMode=None");
                return con;
            }
        }