actionETL 0.38.0
See the version list below for details.
dotnet add package actionETL --version 0.38.0
NuGet\Install-Package actionETL -Version 0.38.0
<PackageReference Include="actionETL" Version="0.38.0" />
paket add actionETL --version 0.38.0
#r "nuget: actionETL, 0.38.0"
// Install actionETL as a Cake Addin
#addin nuget:?package=actionETL&version=0.38.0
// Install actionETL as a Cake Tool
#tool nuget:?package=actionETL&version=0.38.0
Cross-platform ETL library for easily writing high performance, highly productive ETL data processing applications in C#, VB, etc. running on Windows and Linux. It is well-suited to both small and truly large and complex projects.
- Trial: Get your free 30-day trial key at https://envobi.com/trial
- Commercial: Purchase the product at https://envobi.com/
Supported platforms:
- .NET Framework 4.6.1+
- .NET Standard 2.0+
- .NET Core 2.1+ (via .NET Standard 2.0)
- Windows and Linux
- On-premises and cloud
Features:
- Extensive dataflow and control flow capabilities
- MariaDB, MySQL, PostgreSQL, SQLite, and SQL Server targeted database providers
- ODBC database provider for other databases
- Spreadsheet, delimited, fixed format, etc.
- Use nuget.org to easily retrieve new versions of actionETL
and much more, see https://envobi.com/ for details.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
| .NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
| .NET Standard | netstandard2.0 is compatible. netstandard2.1 was computed. |
| .NET Framework | net461 is compatible. net462 was computed. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
| MonoAndroid | monoandroid was computed. |
| MonoMac | monomac was computed. |
| MonoTouch | monotouch was computed. |
| Tizen | tizen40 was computed. tizen60 was computed. |
| Xamarin.iOS | xamarinios was computed. |
| Xamarin.Mac | xamarinmac was computed. |
| Xamarin.TVOS | xamarintvos was computed. |
| Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.1
- EPPlus (>= 4.5.3.3)
- FileHelpers (>= 3.4.1)
- Microsoft.Data.SqlClient (>= 2.0.0)
- MySql.Data (>= 8.0.21)
- Newtonsoft.Json (>= 12.0.3)
- NLog (>= 4.7.3)
- NodaTime (>= 2.4.8)
- Npgsql (>= 4.1.4)
- Sentry.PlatformAbstractions (>= 1.1.1)
- System.Collections.Immutable (>= 1.7.1)
- System.Data.SQLite.Core (>= 1.0.113.1)
- System.Net.NameResolution (>= 4.3.0)
- System.Net.Primitives (>= 4.3.1)
- System.Runtime.CompilerServices.Unsafe (>= 4.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
- System.ValueTuple (>= 4.5.0)
-
.NETStandard 2.0
- EPPlus (>= 4.5.3.3)
- FileHelpers (>= 3.4.1)
- Microsoft.Data.SqlClient (>= 2.0.0)
- MySql.Data (>= 8.0.21)
- Newtonsoft.Json (>= 12.0.3)
- NLog (>= 4.7.3)
- NodaTime (>= 2.4.8)
- Npgsql (>= 4.1.4)
- Sentry.PlatformAbstractions (>= 1.1.1)
- System.Collections.Immutable (>= 1.7.1)
- System.Configuration.ConfigurationManager (>= 4.7.0)
- System.Data.Odbc (>= 4.7.0)
- System.Data.SQLite.Core (>= 1.0.113.1)
- System.Net.NameResolution (>= 4.3.0)
- System.Net.Primitives (>= 4.3.1)
- System.Reflection.Emit.Lightweight (>= 4.7.0)
- System.Runtime.CompilerServices.Unsafe (>= 4.7.1)
- System.Threading.Tasks.Extensions (>= 4.5.4)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
This release brings enhanced database support across all database providers, for both on-premises and cloud deployments.
Improved GetTableColumnsAsync() and GetTableTypeAsync(), which also helps AdbInsertTarget and AdbTableNonQueryWorker:
- MariaDB and MySql: Fixed quoting bug
- MySql: Fixed table metadata bug for 4GB column types 'longblob' and 'longtext'
- PostgreSQL:
-- Added support for temporary tables and PostgreSQL schema search_path
-- Added support for BitArray to 'bit varying' type mapping (in addition to the existing 'varbit' mapping)
-- Fixed bug in GetTableColumnsAsync() overloads when no schema specified
- SQLite: Added support for views
- SQL Server: Improved 'Precision', 'Scale', 'LengthInBytes', and 'LengthInCharacters' column metadata from GetTableColumnsAsync() overloads
AdbExecuteScalarWorker converts (with System.Convert.ChangeType()) the worker result if casting fails, thereby handling more data type mismatches.
Verified actionETL on Azure for MariaDB, MySql, PostgreSQL, and Azure SQL Database.