public UserProducts AddUserProducts(AddUserProductsCommand newUserProducts) { using (var connection = new SqlConnection(_connectionString)) { connection.Open(); var sql = @"INSERT INTO [dbo].[UserProducts] ([ProductId] ,[UserId]) output inserted.* VALUES (@ProductId ,@UserId)"; return(connection.QueryFirst <UserProducts>(sql, newUserProducts)); } }
public void Create(AddUserProductsCommand newUserProducts) { var repo = new UserProductsRepository(); repo.AddUserProducts(newUserProducts); }