May 02, 2019 08:03 AM|Yuki Tao|LINK
According to your requirement,I find
this post is similar to you.
Someone suggest use Service stack redis implementation,here are all the details required.
Redis is particularly good when doing caching in compare to other nosql.
But if you are having high read - write application, I will insist to check out nosql database as database combined with SQL server. That will help in case of scalability.
You can serialize your tables and store them in the Cache.
The following blog explains how you can store your information in SQL Server and
Redis Cache. It using MVC and EntityFramework as well: