How to reuse param on Powershell?

Question

Let's say I have the following function:

function Get-DBStatus
{
  <# .. removed help section for brevity .. #>
  [CmdletBinding()]
  [OutputType([System.Object])]
  param
  (
    [Parameter(Mandatory = $true)]
    [String]$ServerName,
    [Parameter(Mandatory = $true)]
    [String]$ServerUser,
    [Parameter(Mandatory = $true)]
    [String]$ServerPassword,
    [Parameter(Mandatory = $true)]
    [String]$DatabaseName,
  )

  try
  {
    $params = @{ ... } # <<< It's possible to avoid this duplication ?
    $dbStatus = Invoke-SqlConnection @params
  }
  catch
  {
    Write-Error -Message ('An error has occured while ...')

  }
  ...

I would like to avoid the need to declare @params once my parameters were already declared and set. It's possible to do it with Powershell ?

You could use $PsBoundParameters.

BenH
– BenH

2017-05-30 16:52:08 +00:00
Commented May 30, 2017 at 16:52 — BenH
– BenH, Commented May 30, 2017 at 16:52
@BenH is right,Invoke-SqlConnection @PSBoundParameters

Mathias R. Jessen
– Mathias R. Jessen

2017-05-30 17:13:39 +00:00
Commented May 30, 2017 at 17:13 — Mathias R. Jessen
– Mathias R. Jessen, Commented May 30, 2017 at 17:13
@BenH, Please make it as an answer and I will accept it :)

Valter Silva
– Valter Silva

2017-05-30 18:02:00 +00:00
Commented May 30, 2017 at 18:02 — Valter Silva
– Valter Silva, Commented May 30, 2017 at 18:02

BenH · Accepted Answer · 2017-05-30 18:08:17Z

5

The parameters that are passed in are saved in the automatic variable $PSBoundParameters. This can then be used by your command by splatting this variable with @PSBoundParameters.

function Get-DBStatus {
    <# .. removed help section for brevity .. #>
    [CmdletBinding()]
    [OutputType([System.Object])]
    param (
        [Parameter(Mandatory = $true)]
        [String]$ServerName,
        [Parameter(Mandatory = $true)]
        [String]$ServerUser,
        [Parameter(Mandatory = $true)]
        [String]$ServerPassword,
        [Parameter(Mandatory = $true)]
        [String]$DatabaseName,
    )

try {
    $dbStatus = Invoke-SqlConnection @PSBoundParameters
}
catch {
    Write-Error -Message ('An error has occured while ...')
}
...

answered May 30, 2017 at 18:08

BenH

10.1k1 gold badge26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to reuse param on Powershell?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related