public async Task <Meal> Add(Meal entity)
{
Meal insertedMeal;
using (var connection = new SqlConnection(_config.GetConnectionString("RestaurantAPI")))
{
await connection.OpenAsync();
using (var transaction = await connection.BeginTransactionAsync())
{
insertedMeal = await connection.QueryFirstOrDefaultAsync <Meal>(SqlQueriesFactory.AddMeal(), entity);
await transaction.CommitAsync();
}
}
return(insertedMeal);
}
