How to implement using statement in powershell?

Question

How can I write using in power shell ?

This is working example in C#

using (var conn = new SqlConnection(connString)) {     Console.WriteLine("InUsing"); } 

I need same in Powershell (not working):

Using-Object ($conn = New-Object System.Data.SqlClient.SqlConnection($connString)) {      Write-Warning -Message 'In Using';           } 

It is working without using:

$conn = New-Object System.Data.SqlClient.SqlConnection($connString) 

Thank you for help.

Answer 1

Here is a solution from Using-Object: PowerShell version of C#’s “using” statement which works by calling .Dispose() in a finally block:

function Using-Object {     [CmdletBinding()]     param (         [Parameter(Mandatory = $true)]         [AllowEmptyString()]         [AllowEmptyCollection()]         [AllowNull()]         [Object]         $InputObject,          [Parameter(Mandatory = $true)]         [scriptblock]         $ScriptBlock     )      try     {         . $ScriptBlock     }     finally     {         if ($null -ne $InputObject -and $InputObject -is [System.IDisposable])         {             $InputObject.Dispose()         }     } } 

And here's how to use it:

Using-Object ($streamWriter = New-Object System.IO.StreamWriter("$pwd\newfile.txt")) {     $streamWriter.WriteLine('Line written inside Using block.') }