The new 0.38.0 release brings enhanced database support across all database providers, for both on-premises and cloud deployments.
- Improved GetTableColumnsAsync(String) and GetTableTypeAsync(String), which also helps AdbInsertTarget<TInputError> and AdbTableNonQueryWorker:
- MariaDB™ and MySql™:
- Fixed quoting bug.
- MySql™:
- Fixed table metadata bug for 4GB column types
longblobandlongtext.
- Fixed table metadata bug for 4GB column types
- PostgreSQL®:
- Added support for temporary tables and PostgreSQL schema
search_path. - Added support for BitArray to
bit varyingtype mapping (in addition to the existingvarbitmapping). - Fixed bug in GetTableColumnsAsync(String) overloads when no schema specified.
- Added support for temporary tables and PostgreSQL schema
- SQLite: Added support for views.
- SQL Server®: Improved
Precision,Scale,LengthInBytes, andLengthInCharacterscolumn metadata from GetTableColumnsAsync(String) overloads.
- MariaDB™ and MySql™:
- AdbExecuteScalarWorker<TResult> converts (with ChangeType(Object, Type)) the worker result if casting fails, thereby handling more data type mismatches.
- Verified actionETL on Azure for MariaDB, MySql, PostgreSQL, and Azure SQL Database.
Check out all the actionETL features and try it out today with the Free 30-day Trial!