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.aspxLet me know how you get along.