internal/functions/Get-SqlCommand.ps1
|
<# .SYNOPSIS Gets a configured SqlCommand object for local SQL Server LocalDB access. .DESCRIPTION Creates a command for SQL Server LocalDB using encryption and trusting the local instance's certificate. .EXAMPLE PS C:\> $sqlCommand = Get-SqlCommand This will create and return a SqlCommand object configured to connect to the local SQL Server LocalDB instance. .NOTES Author: Mötz Jensen (@Splaxi) #> function Get-SqlCommand { [CmdletBinding()] [OutputType([System.Data.Common.DbCommand])] param ( ) end { $sqlConnection = $script:SqlClientFactory.CreateConnection() $sqlCommand = $sqlConnection.CreateCommand() try { $sqlConnection.ConnectionString = "Server='(LocalDB)\MSSQLLocalDB';Database='master';Integrated Security='SSPI';Application Name='d365bap.tools';Encrypt=True;TrustServerCertificate=True" $sqlCommand.Connection = $sqlConnection $sqlCommand.CommandTimeout = 0 } catch { Write-PSFMessage -Level Important ` -Message "Something went wrong while working with the sql server connection objects" ` -Exception $PSItem.Exception Stop-PSFFunction -Message "Stopping because of errors" ` -StepsUpward 1 return } $sqlCommand } } |