internal/functions/get-sqlcommand.ps1

function Get-SQLCommand ($DatabaseServer,$DatabaseName, $SqlUser, $SqlPwd) {

    Write-verbose "Server : $DatabaseServer , Database $DatabaseName"

    $sqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $sqlConnection.ConnectionString = "Server=$DatabaseServer;Database=$DatabaseName;User=$SqlUser;Password=$SqlPwd;Application Name=d365fo.tools"

    $sqlCommand = New-Object System.Data.SqlClient.SqlCommand
    $sqlCommand.Connection = $sqlConnection

    return $sqlCommand
}