Gainz-SqlDb

0.1.1


Gainz: Sql Db

Database agnostic Powershell functions over ADO.NET.

The primary functions are Invoke-DbCmd, Read-DbData, and Write-DbData. If
a connection or connectionString is not provided to the functions, the functions
will attempt to use the default connection set by Set-DbConnectionString.

Any function that has a -Do parameter, can be passed a script

Gainz: Sql Db

Database agnostic Powershell functions over ADO.NET.

The primary functions are Invoke-DbCmd, Read-DbData, and Write-DbData. If
a connection or connectionString is not provided to the functions, the functions
will attempt to use the default connection set by Set-DbConnectionString.

Any function that has a -Do parameter, can be passed a script block that will
have the $_ context variable set with either the connection or command object.
Show more

Installation Options

Copy and Paste the following command to install this package using PowerShellGet More Info

Install-Module -Name Gainz-SqlDb -RequiredVersion 0.1.1

Copy and Paste the following command to install this package using Microsoft.PowerShell.PSResourceGet More Info

Install-PSResource -Name Gainz-SqlDb -Version 0.1.1

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deploy all the dependencies to Azure Automation. Learn More

Manually download the .nupkg file to your system's default download location. Note that the file won't be unpacked, and won't include any dependencies. Learn More

Owners

Copyright

(c) 2018 Nerdy Mishka, Michael Herndon. All rights reserved.

Package Details

Author(s)

  • Nerdy Mishka Michael Herndon

Tags

SQL ADO.NET Database SqlClient Gainz Gainz-SqlDb

Functions

Set-DbConnectionString Get-DbConnectionString New-DbProviderFactory Set-DbProviderFactory Get-DbProviderFactory Get-DbParameterPrefix Set-DbParameterPrefix New-DbConnection New-DbCommand Read-DbData Write-DbData Invoke-DbCmd

Dependencies

This module has no dependencies.

Release Notes


0.1.1 - Fix Invoke-DbCmd
0.1.0 - Early Release
       
- Read-DbData only supports one return set.
- Tests currently target SqlServer

FileList

Version History

Version Downloads Last updated
0.1.2 414 3/17/2019
0.1.1 (current version) 147 12/29/2018
0.1.0 65 8/31/2018