New-SqliteConnectionString.ps1
|
function New-SQLiteConnectionString { [cmdletbinding()] [OutputType([String])] param( [Parameter( Position=0, Mandatory=$true, ValueFromPipeline=$true, ValueFromPipelineByPropertyName=$true, ValueFromRemainingArguments=$false, HelpMessage='SQL Server Instance required...' )] [Alias( 'Instance', 'Instances', 'ServerInstance', 'Server', 'Servers','cn','Path','File','FullName','Database' )] [ValidateNotNullOrEmpty()] [string[]] $DataSource, [Parameter( Position=2, Mandatory=$false, ValueFromPipelineByPropertyName=$true, ValueFromRemainingArguments=$false )] [System.Security.SecureString] $Password, [Parameter( Position=3, Mandatory=$false, ValueFromPipelineByPropertyName=$true, ValueFromRemainingArguments=$false )] [Switch] $ReadOnly ) Begin { $SqliteFactory = Get-SqliteDbProviderFactory } Process { foreach($DataSRC in $DataSource) { $ConnectionStringBuilder = $SqliteFactory.CreateConnectionStringBuilder() Write-Verbose "Creating connection string for Data Source '$DataSRC'" $PSBoundParameters.Keys | ForEach-Object { $Name = $_ switch($Name) { "Password" { $BSTR = [System.Runtime.InteropServices.Marshal]::SecureStringToBSTR($Password) $PlainPassword = [System.Runtime.InteropServices.Marshal]::PtrToStringAuto($BSTR) $ConnectionStringBuilder.Password = $PlainPassword } "DataSource" { $ConnectionStringBuilder.DataSource = $DataSrc } default { if($PSBoundParameters[$Name] -is [System.Management.Automation.SwitchParameter]) { $Value = [Boolean]$PSBoundParameters[$Name] } else { $Value = $PSBoundParameters[$Name] } $ConnectionStringBuilder."$Name" = $Value } } } $ConnectionString = $ConnectionStringBuilder.ConnectionString Write-Debug "ConnectionString $ConnectionString" [PSCustomObject]@{ ConnectionString = $ConnectionString DbProviderName = "System.Data.SQLite" } } } } |