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); } }