I am trying to use the "Always Encrypted" feature in SQL Server 2016 to encrypt some columns. I used this post as a guide to set the columns as encrypted in SSDT.
That part goes fine, it's when I attempt to query the data from the application that I get an error. According to the docs I need to add this:
column encryption setting=enabled
to my connection string. This does not appear to be supported in Entity Framework Core. I get this error:
column encryption setting=enabled is not supported
I tried using the
SqlConnectionStringBuilder to build the string as well and the ability to add that setting is not there. It does appear to be there in .NET 4.6.
So, is anyone aware of a way to connect to an SQL server instance from a .NET Core application using Always Encrypted?
As mentioned by MS folks - Always Encrypted is currently not supported on .Net Core.
We had the same situation, finally we had to make the Core WebApp to target .NET Full Framework, there is no other option.
i.e., Currently not compatible with netcoreapp1.1 (.NETCoreApp,Version=v1.1) Compatible with net452 (.NETFramework,Version=v4.5.2)
From forums - "Eventhough EF Core could work for AE feature, but still the underlying .NET Core SQL Client currently does not support for AE, and it will be in their (MS + Opensource ontributors) future mile stone to support it"
Please refer this GitHub page for any recent updates on this issue: