public async Task <IActionResult> GetOne(int id)
        {
            await Db.Connection.OpenAsync();

            var query  = new MessageQuery(Db);
            var result = await query.FindOneAsync(id);

            if (result is null)
            {
                return(new NotFoundResult());
            }
            var json = await Task.Run(() => JsonConvert.SerializeObject(result));

            return(new OkObjectResult(json));
        }
        public async Task <IActionResult> GetOne(int id)
        {
            using (var db = new AppDb())
            {
                await db.Connection.OpenAsync();

                var query  = new MessageQuery(db);
                var result = await query.FindOneAsync(id);

                if (result == null)
                {
                    return(new NotFoundResult());
                }
                return(new OkObjectResult(result));
            }
        }
        public async Task <IActionResult> PutOne(int id, [FromBody] Message body)
        {
            using (var db = new AppDb())
            {
                await db.Connection.OpenAsync();

                var query  = new MessageQuery(db);
                var result = await query.FindOneAsync(id);

                if (result == null)
                {
                    return(new NotFoundResult());
                }
                result.text   = body.text;
                result.userid = body.userid;
                await result.UpdateAsync();

                return(new OkObjectResult(result));
            }
        }