HorkerDataQuery
1.0.3
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
- Returns query results as PowerShell objects, and exports PowerShell objec
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
- Returns query results as PowerShell objects, and exports PowerShell objects into database tables
- Reads app.config or web.config 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
Owners
Copyright
(c) 2018 horker. All rights reserved.
Package Details
Author(s)
- horker
Tags
database relational rdb rdbms query schema sql server sqlserver oracle mysql postgresql sqlite access msaccess data analysis conversion pandas dplyr
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.2, v1.0.3
Several bug fixes
v1.0.1
Bug fix: Added a missing file in the 32-bit environment
v1.0.0
First release
FileList
- HorkerDataQuery.nuspec
- Horker.Data.dll
- Horker.Data.dll-Help.xml
- HorkerDataQuery.psd1
- HorkerDataQuery.psm1
- sqlite.config
- System.Data.SQLite.dll
- x64\SQLite.Interop.dll
- x86\SQLite.Interop.dll