public async Task <Post> AddAsync(Post post)
        {
            post.Created   = DateTime.Now;
            post.CreatedBy = _context.GetUser();

            using (var connection = new SqlConnection(ConnectionString))
            {
                connection.Open();
                var result = await connection.ExecuteAsync("dbo.AddPost @Title, @Content, @Created, @UserId",
                                                           new { post.Title, post.Content, post.Created, post.UserId });

                return(post);
            }
        }