.NET Core SQL Server Session State

Question

I need to use SQL Server session state with my website and use it with the existing ASPState database that the customer has, this was a requirement.

However I noticed the table structure for doing session state in .NET Core differs from how the structure used to be. Does anyone know how to implement this or a work around?

.NET Core Session State DB

Previous Session State Versions

Answer 1

What you're wanting is not possible. Not only is the database table different, ASP.NET Core uses DataProtectionProvider for encryption, whereas ASP.NET utilizes the machine key. In other words, even if the schema was the same, one site wouldn't be able to decrypt the session state from the other.