Insert custom object to Database

Write-SqlTableFromObj.ps1

function Write-SqlTableFromObj {
    <#
    .SYNOPSIS
    Insert custom object to Database
    
    .DESCRIPTION
    Assume PSCustomObject key names is SQL Table column names and inserts values to SQL Table
    
    .PARAMETER ServerInstance
    SQL Server Instance
    
    .PARAMETER Database
    SQL Server Database
    
    .PARAMETER TableName
    SQL Table to Insert into
    
    .PARAMETER Data
    Custom Object(s) to import in SQLTable
    
    .EXAMPLE
    $data = @(@{ID=1; Namn="Gunde"}, @{ID=2; Namn="Barbro"})
    Write-SqlTableFromObj @SQLSettings -Data $Data

    .EXAMPLE
    $data = @(@{ID=1; Namn="Gunde"}, @{ID=2; Namn="Barbro"})
    $data | Write-SqlTableFromObj @SQLSettings
    
    .NOTES
    General notes
    #>
    [CmdletBinding()]
    param (
        [parameter(Mandatory = $True)]
        $ServerInstance,

        [parameter(Mandatory = $True)]
        $Database,

        [parameter(Mandatory = $True)]
        $TableName,

        [parameter(ValueFromPipeline = $True, Mandatory = $True)]
        [PSCustomObject[]]
        $Data
    )
    
    begin {
        $SQLConnStr = @{
            ServerInstance = $ServerInstance
            Database = $Database
        }
    }
    
    process {
        foreach ($Row in $Data) {
            $Columns = $Row.Keys -join ','
            $Values = $Row.Values -join "','"
            $SQLString = "INSERT INTO [$($TableName)] ($($Columns)) VALUES ('$($Values)')"
            Write-Verbose $SQLString
            Invoke-Sqlcmd @SQLConnStr -Query $SQLString
        }
    }
}