execute database update insert or delete

execute-nonquery

function Execute-NonQuery([psobject[]]$sqlCommands, $connectionString) {
    $connection = new-object system.data.SqlClient.SQLConnection($connectionString)
    $connection.Open()

    $command = $connection.CreateCommand()
    $transaction = $connection.BeginTransaction()
    $command.Connection = $connection
    $command.Transaction = $transaction
    
    try {
        for($i=0;$i -lt $sqlCommands.Length;$i++){
            $command.CommandText = $sqlCommands[$i].commandText

            $parameters = $sqlCommands[$i].parameters
            $command.Parameters.Clear()

            $parameters | Select-Object -ExpandProperty Keys | %{ 
                $command.Parameters.Add($_, $parameters[$_])
            }

            $command.ExecuteNonQuery()
        }
        $transaction.Commit()
    }
    catch {
        $transaction.Rollback()
    }
    finally {
        $connection.Close()
    }
}