Options
Linq To SQL Driver Column Encryption Setting=Enabled
Hello,
I tried to pass "Column Encryption Setting=Enabled" to a Linq to SQL connection using the additional connection parameters.
However, I received the error message "Keyword not supported," even though the version of System.Data.SqlClient should actually support this.
Am I doing something wrong?
If I use the Entity Framework Core (multi-provider), I can specify the additional parameter and query the column.
I'm using LinqPad 8.8.9 x64 on Windows 11 24H2.
Comments
Are you sure this option is supported by System.Data.SqlClient? The following throws for me when I reference the latest version of System.Data.SqlClient:
new SqlConnection ("Data Source=.;Integrated Security=SSPI;Column Encryption Setting=Enabled").Open();Note that LINQPad 9 will support Microsoft.Data.SqlClient with LINQ-to-SQL as well as EF Core. An early preview will be available in a day or two.
I found the "error". System.Data.SqlClient only supports column encryption with .NET Framework 4.6 or newer.
But if Linq-to-SQL works with Microsoft.Data.SqlClient soon, then the issue will be resolved.
Thank you for this great app.
LINQPad 9 is now in early preview:
https://www.linqpad.net/linqpad9.aspx
Let me know how you get along.