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
}
