Home

Error trying to connect to SqlServer database using Always Encrypted

rickyhicksrickyhicks

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?

· Share on FacebookShare on Twitter

Comments

  • JoeAlbahariJoeAlbahari

    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.

    · Share on FacebookShare on Twitter
Sign In or Register to comment.