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.
Installation Options
Author(s)
Nerdy Mishka Michael Herndon
Copyright
(c) 2018 Nerdy Mishka, Michael Herndon. All rights reserved.
Package Details
Owners
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
- Gainz-SqlDb.nuspec
- Gainz-SqlDb.psd1
- Gainz-SqlDb.psm1
- LICENSE
- README.md
- public\Add-DbParameters.ps1
- public\Add-DbProviderFactory.ps1
- public\Get-DbConnectionString.ps1
- public\Get-DbParameterPrefix.ps1
- public\Get-DbProviderFactory.ps1
- public\Get-SqlDbOptions.ps1
- public\Invoke-DbCmd.ps1
- public\New-DbCommand.ps1
- public\New-DbConnection.ps1
- public\New-DbProviderFactory.ps1
- public\New-SqlClientParameter.ps1
- public\Read-DbData.ps1
- public\Set-DbConnectionString.ps1
- public\Set-DbProviderFactory.ps1
- public\Write-DbData.ps1
Version History
Version | Downloads | Last updated |
---|---|---|
0.1.2 | 371 | 3/17/2019 |
0.1.1 (current version) | 140 | 12/29/2018 |
0.1.0 | 58 | 8/31/2018 |