3.0.0

• Change license to MIT.
• Change target to PowerShell 7.2 / .NET 6.
• Change how the module loads dependencies. Now, the module loads dependencies into a private context using the recommended technique to prevent errors if other moduels load conflicting dependencies.
• Change Cmdlet, renaming to PSqlCmdlet.
• Remove IConsole, replacing it with a simpler ISqlMessageLogger.
• Update Microsoft.Data.SqlClient to 5.2.3
• Add -ReplaceVariablesInComments switch to Expand-SqlCmdDirectives.
• Add retries on transient failures.
• Fix EncryptionMode.Default requiring certificate validation for local connections.

2.1.0

• Update Microsoft.Data.SqlClient to 4.1.0
• Add dependency Prequel, which is PSql's SQLCMD preprocessor moved to its own NuGet package.
• Add support for a line comment at end of a SQLCMD directive.

2.0.1

• Fix GetConnectionString error with -AuthenticationMode SqlPassword and SqlClientVersion.Legacy:

  The specified SqlClient version 'Legacy' does not support
  authentication mode 'SqlPassword'."

• Fix GetConnectionString with -AuthenticationMode Default choosing mode SqlPassword instead of AadIntegrated when no credential is specified. This resulted in the error:

  A credential is required when connecting to Azure SQL Database using
  authentication mode 'SqlPassword'.

2.0.0

2.0.0

The 2.0.0 release is a complete rewrite of PSql.

• Change module type to binary.
• Change target to PowerShell 7.0+ / .NET Core 3.1.
• Change ADO.NET implementation to Microsoft.Data.SqlClient.
• Add numerous SQL context properties and methods.
• Add support for Azure Active Directory authentication modes.
• Add automated build and publish via GitHub Actions.