Gainz-SqlDb

0.1.2


Gainz: Sql Db

Deprecated: Renaming to Gz-Sql

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

Gainz: Sql Db

Deprecated: Renaming to Gz-Sql

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.

Installation Options

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

Install-Module -Name Gainz-SqlDb

You can deploy this package directly to Azure Automation. Note that deploying packages with dependencies will deloy 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

Author(s)

Nerdy Mishka Michael Herndon

Copyright

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

Owners

Tags

SQL ADO.NET Database SqlClient Gainz Gz 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.3 - Renaming
0.1.1 - Fix Invoke-DbCmd
0.1.0 - Early Release
       
- Read-DbData only supports one return set.
- Tests currently target SqlServer

Version History

Version Downloads Last updated
0.1.2 (current version) 80 3/17/2019
0.1.1 126 12/29/2018
0.1.0 44 8/31/2018