Error trying to connect to SqlServer database using Always Encrypted
Just bought and installed Linqpad 7 and I can't query tables with encrypted columns. In Linqpad 5 you could add the additional connection string parameter "Column Encryption Setting=enabled" however in Linqpad 7 I get an error when I do, Keyword not supported.
How can I connect to an Always Encrypted database?
This is because LINQ-to-SQL depends on the System.Data.SqlClient library which doesn't support that option in .NET Core and above. It's likely that support for Microsoft.Data.SqlClient will be added to LINQPad's LINQ-to-SQL implementation in the future, fixing the issue. In the meantime you could try using LINQPad's EF Core driver which uses Microsoft.Data.SqlClient.