HorkerDataQuery
1.0.4
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 schema table column data analysis conversion query select insert update delete create drop sql server sqlserver oracle mysql postgresql firebird db2 sqlite access msaccess 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.1 - v1.0.4
Bug fixes
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