I am very new to Azure Redis caching. I am using MVC 5 + Entity framework 6.1. and database is Azure SQL Server. Website is also on Azure.
I need to cache few tables in Redis which are used for only read. Current size of these tables are 8 GB and going forward it can increase further.
My questions are: 1) How can I bind these tables in Redis cache? 2) How can I add newly added rows in redis cache? Or do I need to delete and recreate one?
Thanks in advance.
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.