Efcore: Unable to find options to change ColumnEncryptionKeyCacheTtl

[chintan3100]

Unable to find options to change ColumnEncryptionKeyCacheTtl

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.columnencryptionkeycachettl?redirectedfrom=MSDN&view=netframework-4.8&viewFallbackFrom=netcore-3.1#System_Data_SqlClient_SqlConnection_ColumnEncryptionKeyCacheTtl

Steps to reproduce

Further technical details

EF Core version:
Database provider: (e.g. Microsoft.EntityFrameworkCore.SqlServer)
Target framework: (e.g. .NET Core 3.0)
Operating system:
IDE: (e.g. Visual Studio 2019 16.3)

[roji]

@chintan3100 I'm not very familiar with it, but that is a static property. That means you should be able to set it yourself on SqlConnection, and there's no real need or value in EF Core doing anything with it.

[chintan3100]

Looks like not supported in net core. It's supported in .net framework :(

[roji]

Microsoft.Data.SqlClient does have this property - consider switching from System.Data.SqlClient to that (see this blog post for more details).

Am going to close this issue as nothing seems to be needed from the EF Core side, but if you encounter further difficulties feel free to post back.