Get the pipe name for a Local DB instance in powershell

GetLocalDBNamedPipe.ps1

Function GetLocalDBNamedPipe()
{
 
    param( [string]$DB)
    
    # This function can accept instance names in the format '(localdb)\Instance'
    $DB = $DB.replace("(localdb)\", '')
 
    # Ensure that it is running (assumes the DB already exists)
    # Note: pipe names change each time the database starts
     sqllocaldb start $DB | Out-Null
     
    return ((sqllocaldb info $DB | Select-String -Pattern "Instance pipe name") -split " ")[3]
 
}
 
sqllocaldb create TheDatabase
$ThePipe = GetLocalDBNamedPipe -DB TheDatabase