Public/New-Instance.ps1

function New-Instance {

    <#
 
    .SYNOPSIS
    Returns connection parameter for a SQL server.
 
    .DESCRIPTION
    Checks different versions of local db or creates a Docker container with a SQL server installed.
    Returns a object with the properties DataSource and ConnectionString.
 
    .EXAMPLE
    PS> New-SqlTestInstance
    ConnectionString DataSource
    ---------------- ----------
    Data Source=(LocalDb)\MSSQLLocalDB;Integrated Security=True (LocalDb)\MSSQLLocalDB
 
    #>


    [CmdletBinding()]
    param ()

    if ( Test-LocalDb ) {
        Get-LocalInstance |
            Write-Output
    }
    elseif ( Test-Docker )
    {
        New-DockerInstance -AcceptEula |
            Write-Output
    }
    else {
        Write-Error 'No SQL server provider like Docker or LocalDb is available.'
    }
}