src/Get-Scalar.psm1
|
using module ./New-Command.psm1 <# .SYNOPSIS Executes a parameterized SQL query that selects a single value. .PARAMETER Connection The connection to the data source. .PARAMETER Command The SQL query to be executed. .PARAMETER Parameters The parameters of the SQL query. .OUTPUTS The value of the first column of the first row returned, or `$null` if not found. #> function Get-Scalar { [CmdletBinding()] [OutputType([object])] param ( [Parameter(Mandatory, Position = 0)] [System.Data.IDbConnection] $Connection, [Parameter(Mandatory, Position = 1)] [string] $Command, [Parameter(Position = 2)] [ValidateNotNull()] [hashtable] $Parameters = @{} ) if ($Connection.State -eq [System.Data.ConnectionState]::Closed) { $Connection.Open() } $dbCommand = New-Command $Connection -Command $Command -Parameters $Parameters $value = $dbCommand.ExecuteScalar() $dbCommand.Dispose() $value -is [DBNull] ? $null : $value } |