0.19.2 - Various fixes

Enhancements:

• #191 Improve exception message in AseParameter ctor
• #179 Fixes the incorrect masking in CatchAllToken.
  TDS_CURDECLARE3 also does not obey the rules on token length, so it has been special-cased.
  Additionally, all "Zero-Length" tokens are not actually zero-length; their length is defined by prior tokens in the stream, so it would cause unpredictable errors if they are encountered by the CatchAllToken; as such they now throw exceptions instead.

Bug fixes:

• #196 Caching command parameter metadata is only applicable for TdsDataType.TDS_BLOB and not the other as we still need to determine DataType and UserType both of which depends parameter.SendableValue where that can be null
  Adding more test cases raised by issue #196

• #192 Address issue #192 for duplicate parameter name
  Update test cases for #192
  Fix bug in SchemaTableBuilder to not skip valid table
  Partially address issue #188 by include the IsUnique as well as IsKey in the validation to determine hasKey

Other:

• Full list of issues in this release
• Full list of PRs in this release

0.19.1 - Bug fixes

Bug fixes:

• #194 - Fix issue when reuse of command object with same parameter name but different type

Other:

• Full list of issues in this release
• Full list of PRs in this release

Various Fixes

Bug fixes:

• #182 - Fix throw exception in ExecuteScalar()
• #183 - Fix DataConstraintException throw in ExecuteScalar()
• #185 - Fix correct order of error item
• #186 - Fix Operand type clash:VARBINARY is incompatible with TEXT
• #187 - Fix UserType 36 require for is required for 'text', 'text_locator' or 'unitext' typed input parameter in the stored proc

Improvements

• #178 - Improve x509 related code

Other:

• Full list of issues in this release
• Full list of PRs in this release

0.18.0 - Outbound Parameters

Bug fixes:

• #173 -Fixed support for outbound parameters for decimal and numeric types.

Other:

• Full list of issues in this release
• Full list of PRs in this release

0.17.0 - Various Fixes

Improvements:

• #157 - Enable SourceLink
• #161 - Implement support for TDS_ROWFMT token (improves v15 support)
• #172 - Added TDS_BLOB support to DbType.AnsiString

Bug Fixes:

• #153 - Fix AseDataReader.RecordsAffected to report correct values
• #155 - Fix issue where certs with no chain errors are considered invalid
• #158 & #163 - Fix some connection management issues in the connection pool
• #168 - Fix issue causing connection to report incorrect state
• #170 - Fix issue in sending blob data to the server (message not properly terminated)

Other:

• Full list of issues in this release
• Full list of PRs in this release

0.16.0 - Blobs and Leaky Pools

Improvements:

• #150 - Add support for large (>16KB) binary and string parameters via TDS_BLOB type

Bug Fixes:

• #148 - Fix for connection leak in pool (connections wouldn't get cleaned up if post-login preamble failed)

Other:

• Full list of issues in this release
• Full list of PRs in this release

0.15.0 - Streaming DataReader and TLS Support

Improvements:

• #98 - Add TLS connection support
• #115 - Streaming data reader. Receive data as the server sends it, where previously the driver would cache the entire server response before returning to caller. Benefits can be seen in the cases where:
  • The executing statement is long-running and produces periodic messages to be consumed immediately
  • The executing statement produces very large data sets that would hit memory limitations if cached in their entirety
• #117 - Implement AseConnection.IsCaseSensitive

Bug Fixes:

• #102 - Fix for possible IndexOutOfRangeException on AseDataReader
• #134 - Fix to reproduce the ordering of messages (i.e. from prints) and table results (i.e. selects) as it was output by the server.

Other:

• Full list of issues in this release
• Full list of PRs in this release

0.14.0 - Password encryption

Improvements:

• #27 - This release adds support for password encryption between the client and the server during logon. Set EncryptPassword=1 in your connection string.

Bug fixes:

• #110 - where connections would fail if the connection string defines a charset, but the server is configured with sp_configure 'disable character set conversions', 1.

• #104 - where the length of some tokens being returned by the server was miscalculated - this could probably manifest in many ways, but was reported as System.InvalidOperationException : "Operation is not valid due to the current state of the object.".

Thanks @driseley for your quality contributions to this release.

0.13.1 - Hotfix release

Bug fixes:

• #96 - Fixed issue with inferring AseDbType of string AseParameters where type was not explicitly specified

0.13.0 - External Encoding support + other fixes

Improvements:

• #89 - Add support for external EncodingProviders - read this wiki page for details

Bug fixes:

• #51, #59, #62 - Fix some issues uncovered by the linq2db/linq2db team
• #78 - Emit InfoMessage events when the driver receives messages from the server
• #86 - Allow DbProviderFactory use in .net core 2.0 and standard 2.0
• #90 - Add some robustness around handling of environment-change tokens sent from the server
• #92 - Expose AseConnection.ClearPools() static stub. Note: much like the close-doors button in a lift, this function is not implemented (nor is ClearPool)

Other:

• #43 - Improve CodeFactor grades

Note: if you see a 0.12.0 release on NuGet, do not use it. The assembly version was unintentionally upped, so we trashed that release number.