public void InsertTweet(Tweet tweet) { using (var connection = new SqlConnection(_connectionString)) { connection.Execute("INSERT INTO dbo.Tweet VALUES (@Id, @Text, @RetweetCount, @Image, @Time)", tweet); } }
public void DeleteTweet(Tweet tweet) { using (var connection = new SqlConnection(_connectionString)) { connection.Execute("DELETE FROM dbo.Tweet WHERE Id=@Id", new { tweet.Id }); } }
public void PinTweet(Tweet tweet) { _tweetDbService.InsertTweet(tweet); }
public void UnpinTweet(Tweet tweet) { _tweetDbService.DeleteTweet(tweet); }
public void InsertTweet(Tweet tweet) { // TODO Hint: check out the Dapper docs online. https://github.com/StackExchange/dapper-dot-net }