Release Notes for Database plugin

1.16.7.0

23 Jun 2022

  • Fix bug: Database ExecuteSQL Result Editor does not update column types

1.16.6.0

13 Apr 2022

  • Fix bug: Do not save design-time connection string in Database plugin
  • Fix bug: ExecuteSQL result type types not always mapped

1.16.4.0

29 Mar 2022

  • Fix bug: Object reference error in ExecuteStoredProcedure result fields editor

1.16.3.0

26 Nov 2021

  • Fix bug: Undo action in ExecuteSQL function not reverting all changes

1.16.2.0

22 Sep 2021

  • Update third-party libraries
  • Remove Sort property from MongoDBMapReduce function

1.16.1.0

1 Sep 2021

  • Update third-party libraries
  • Fix bug: Error when trying to use a MySql stored procedure with a LONGTEXT parameter in ExecuteStoredProcedure function

1.16.0.0

17 Jun 2021

  • Change batch size property to accept a dynamic value on DbBulkCopy function
  • Update third-party libraries
  • Fix bug: Sequence error thrown when connecting to a Mongo cluster
  • Fix bug: Dragging or double-clicking variable on icon not working in SQL editor

1.15.4.0

16 Jul 2020

  • Fix bug: SQL editor displays incorrect column names for SQLite connection in ExecuteSQL function

1.15.2.0

11 Mar 2020

  • Fix bug: Multi-line expressions in SQL editor not working correctly

1.15.1.0

17 Jan 2020

  • Update third-party libraries

1.15.0.0

11 Dec 2019

  • Add Timeout property to ExecuteStoredProcedure function
  • Persist size and position of Result type editor in ExecuteSQL function
  • Wrap ExecuteSQL result type query in transaction to prevent database modification
  • Fix bug: Result type editor allowed invalid scenarios when mapping results to a custom type

1.14.1.0

6 Sep 2019

  • Fix bug: DbBulkCopy throws runtime exception when table name contains spaces or is reserved word

1.14.0.0

8 Mar 2019

  • Move focus to first value item in connection string editor
  • Display null values in SQL test editor
  • Display datetime values in current culture in SQL test editor
  • Fix bug: OLE DB wizard does not populate connection string editor correctly
  • Fix bug: DbBulkcopy throws unhandled exception when saving invalid table name
  • Fix bug: Connection string editor throws away user info for SQL Server connections
  • Fix bug: Connection string property cannot be set to empty string
  • Fix bug: MongoDB functions cannot resolve connection string from setting value at design time
  • Fix bug: ExecuteSQL function does not update result type correctly when column type changes
  • Fix bug: MongoDBRead/Write does not compile when hidden properties contains invalid references

1.13.752.0

13 Sep 2018

  • Change editor styles to conform with Linx
  • Add validation on Connection string property
  • Improve retrieval speed of available procedures in stored procedure editor
  • Add items in ExecuteSQL function SQL editor by double-clicking on them
  • Update Linx plugin
  • Update third-party libraries
  • Fix bug: ExecuteSQL function does not support all SQL Server types
  • Fix bug: Find references did not find references in ExecuteSQL function
  • Fix bug: ExecuteSQL function does not return schema for multi-statement table-valued function

1.12.100.660

29 Dec 2017

  • Fix object reference error when adding output field.

1.11.98.655

23 Oct 2017

  • Fix SqlBulkCopy does not show Loader.Write properties.
  • Add Sql script generation to SqlEditor.
  • Update Linx Plugin library.
  • Update Oracle database client.
  • Update UI styles.
  • Improve SqlEditor drop zone.
  • Improve MongoDb editors.
  • Fix ExecuteSQL field mapping error.
  • Fix ExecuteSQL output field creation when using temp table.
  • Fix ODBC insert query adds record when connectionstring/query changes.
  • Fix ExecuteSql Connection Editor overwrites properties.
  • Fix Cannot assign String to ExecuteSQL.ConnectionString.

1.10.76.559

23 Jun 2017

  • Fix DBBulkCopy fails silently on exception.
  • Update Linx plugin
  • SqlEditor persists last size and layout.
  • Allow MongoDbRead and MongoDbMapReduce to return string output.
  • Fix ExecuteSql insert null fails.
  • Improve SqlEditor UI.
  • Persist size and position of custom editors between sessions.
  • Fix ExecuteStoredProcedure error when returning binary.
  • Fix duplicate parameters in connection string error.
  • Fix SqlBulkCopy shows no properties when setting Write property.

1.9.66.521

12 Apr 2017

  • Fix ExecuteSql properties load when hidden.
  • Fix DBBulkCopy fails silently on exception.

1.8.63.514

20 Jan 2017

  • MongoDbRead: Replace Loop results with Return options.
  • MongoDbMapReduce: Replace Loop results with Return options.
  • Update Linx plugin.

1.7.60.504

9 Sep 2016

  • SQLEditor: Fix Fetch button border.
  • Update NuGet packages.
  • Update Linx plugin.
  • Update UI styles.
  • MongoDbRead: Split Find and Aggregate operations.
  • Add MongoDBMapReduce function.
  • MongoDBRead: Change editors.
  • MongoDBMapReduce: Add editors.
  • Update plugin utilities.

1.6.45.451

3 Jun 2016

  • Fix validation error for multiple missing custom type fields.
  • Fix parameter name clash with properties.

1.5.42.443

29 Apr 2016

  • Update Linx Plugin.
  • Add variable panel to SQLEditor.
  • Fix duplicate variable in ODBC sql causes error.

1.4.35.419

11 Feb 2016

  • Update database drivers.
  • Improve tab order on editors.
  • Fix Insert Expression on Mongo Editors.

1.3.31.407

3 Feb 2016

  • Fix DbBulkCopy output not changed when table is changed.
  • Update Linx Plugin.
  • Changed tab order on controls.

1.3.25.387

7 Dec 2015

  • Display new connection string editor when cannot parse existing connection string successfully.
  • Fix "SET FMTONLY ON" scenario for stored procedures that contain dynamic SQL (replace default parameter values with null).

1.3.22.381

26 Oct 2015

  • Fix reader with blank column names cause index out of bounds exception.

1.3.20.377

20 Oct 2015

  • Update Linx plugin
  • Fix object reference bug for invalid number of result sets.
  • Fix duplicate parameter bug.
  • Add logging.
  • Resolve dynamic transaction connectionstring when queried as reference.
  • DbBulkCopy: Add Timeout property. Default is 30 seconds.
  • Fix ExecuteSql and StoredProcedure forces use of Oracle even if OLEDB is selected.
  • Fix StoredProcedure shows user defined functions.
  • Add CustomType option to ExecuteSQL Output Editor.
  • ExecuteSQL ResultTypeEditor: Make drag-drop consistent with ExecuteStoredProcedure grids.
  • ExecuteSQL ResultTypeEditor: Name column now defaults to value in ColumnName.
  • Fix ExecuteSQL: CustomType does not save.
  • Fix ExecuteSQL ResultTypeEditor: Validation.
  • Fix ExecuteSQL: Validation on CustomType of result type.
  • ExecuteStoredProcedure: Add validation on CustomTypes of result sets.
  • ExecuteSQL and ExecuteStoredProcedure: Replaced result set custom type selector with TypeReferenceEditor.
  • ExecuteSQL ResultTypeEditor: Use TypeReferenceEditor for field types.
  • Add CustomType option to ExecuteSQL Output Editor
  • Update ExecuteSQL function output from Int32 to Int64

1.3.3.327

11 Aug 2015

  • Update MongoDb drivers.
  • ExecuteSQL to use Transaction.
  • BeginTransaction: Test all isolation levels.
  • BeginTransaction: Added icon for Transaction object.
  • ExecuteStoredProcedure to use Transaction.
  • Update Linx plugin.
  • Fix bug: Database connection wizard stays open after update.

1.2.3.303

19 Jun 2015

  • ConnectionEditor: Add Wizard to OLEDB type.
  • Update Linx Plugin API.
  • ExecuteSQL: Replace ConnectionString with ConnectionType and ConnectionString to give finer grained control over which drivers to use.
  • Sort output tables.
  • Fix bug: String as enumerable conversion error.
  • ExecuteSQL (OLEDB): Fix locale settings related conversion issue with floating point valued sql parameters.
  • Add BeginTransaction Function.

1.1.48.273

15 May 2015

  • Add DbBulkCopy function
  • Update Linx plugin
  • ExecuteStoredProcedure: Detect connection type when changing connection string
  • ExecuteStoredProcedure: Fixed crash when setting connection string to a variable
  • UI changes

1.0.37.241

25 Feb 2015

  • Add ExecuteSQL function
  • Add ExecuteStoredProcedure function
  • Add MongoDBRead function
  • Add MongoDBWrite function