Pb when dealing with string that include a ' in bulk insert

[jbpaux]

When variable has a ' in it, it is not escaped and thus the SQL insert is failing. Proper escape is required

[RamblingCookieMonster]

Just ran into this working on a project for a blog post - will look into using parameters for these inserts, which should avoid this issue. Thanks for the reminder!

[jbpaux]

I tried something like this: (sorry, I know I should do a pull request)

$Query = "INSERT INTO $Table ($($Columns -join ", ")) VALUES (@$($Columns -join ", @"))"
foreach ($Column in $Columns) {
                $param = new-object System.Data.SQLite.SqLiteParameter $Column
                $Command.Parameters.Add($param)
            }

for ($RowNumber = 0; $RowNumber -lt $RowCount; $RowNumber++)
            {
                $row = $Datatable.Rows[$RowNumber]
                foreach($Column in $Columns) {
                    $Command.Parameters[$Column].Value = $row[$Column]
                }
...
}

[RamblingCookieMonster]

Thanks for the help! Should be good to go.