sql.cs

        private string GetData()
        {
            var conn = GetConnection();
            var articles = conn.Query<Article>("SELECT * FROM ART_DE");
 
            var o = new JObject();
            o["total_count"] = articles.Count();
            o["pos"] = 0;
            var data = new JArray();
            foreach (var a in articles)
            {
                data.Add(JToken.FromObject(a));
            }
            o["data"] = data;
 
            var result = o.ToString();
            var encoding = Encoding.GetEncoding(1252);
            byte[] encBytes = encoding.GetBytes(result);
            byte[] utf8Bytes = Encoding.Convert(encoding, Encoding.UTF8, encBytes);
 
            return Encoding.UTF8.GetString(utf8Bytes);
        }