Nanite

1.0.9

Private/Database.ps1


function Open-Database {
    $database = New-Object System.Data.SqlClient.SqlConnection
    $database.ConnectionString = "Server=tcp:nanite.database.windows.net,1433;Initial Catalog=nanite;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication='Active Directory Integrated';"
    Try {
        $database.Open()
        Return $database
    }
    Catch {
        Return $NULL
    }
}

function Invoke-Database {
    param (
        [Parameter(
            Mandatory = $FALSE
        )][string]$query
    )
    $command = $Global:database.CreateCommand()
    $command.CommandText = $query
    $adapter = New-Object System.Data.SqlClient.SqlDataAdapter $command
    $data = New-Object System.Data.DataSet
    $adapter.Fill($data)
    Return $data
}