public Quotes AddQuotes(AddNewQuotesDto newQuote)
{
using (var connection = new SqlConnection(_connectionString))
{
connection.Open();
var sql = @"INSERT INTO QUOTES
([Quote]
,[ArtistName]
,[SongName])
output inserted.*
VALUES (@Quote
,@ArtistName
,@SongName)";
return(connection.QueryFirst <Quotes>(sql, newQuote));
}
}
public void Create(AddNewQuotesDto newQuotes)
{
var repo = new QuoteRepository();
repo.AddQuotes(newQuotes);
}
