HorkerDataQuery

1.0.5

Horker DataQuery is a database query utility based on ADO.NET.

The main features are:
- Written in C# so that it works fast for large data
- Supports every database product that provides the ADO.NET driver, including SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Access, OLEDB and ODBC
- PowerShell interoperatability; gets query results as PowerShell objects and
Horker DataQuery is a database query utility based on ADO.NET.

The main features are:
- Written in C# so that it works fast for large data
- Supports every database product that provides the ADO.NET driver, including SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Access, OLEDB and ODBC
- PowerShell interoperatability; gets query results as PowerShell objects and exports PowerShell objects into database tables
- Reads app.config or web.config in your app to define database providers and connection strings
- Gets information from the database schema
- Provides the built-in SQLite driver

This module would be helpful for software development, data analysis, and various data manipulation tasks.

For more details, see the project site: https://github.com/horker/dataquery

Installation Options

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

Install-Module -Name HorkerDataQuery

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)

horker

Copyright

(c) 2018 horker. All rights reserved.

Owners

Tags

database relational rdb rdbms schema table column data analysis conversion query select insert update delete create drop sql server sqlserver oracle mysql postgresql firebird db2 sqlite access msaccess

Cmdlets

Invoke-DataQuery Get-DataQueryResult Export-DataTable New-DataConnection Close-DataConnection Get-DataConnectionHistory Register-DataConnectionString Unregister-DataConnectionString Get-DataConnectionString New-DataConnectionString Register-DbProviderFactory Unregister-DbProviderFactory Get-DbProviderFactory Register-DataConfiguration Get-DataSchema

Dependencies

This module has no dependencies.

Release Notes

v1.0.5
- Earlier release of native resources (database connections)
- Improvements of data handling in Export-DataTable
- Query results as System.Data.DataTable
- Several improvements and bug fixes

v1.0.1 - v1.0.4
Bug fixes

v1.0.0
First release

Version History

Version Downloads Last updated
1.0.5 (current version) 227 9/25/2018
1.0.4 52 3/31/2018
1.0.3 3 3/31/2018
1.0.2 4 3/30/2018
1.0.1 8 3/19/2018
1.0.0 4 3/18/2018