Cache table with Entity Framework Core

Question

I have a database (SQL Server for your information but I don't think it's very important) with some tables, and a ASP.NET Core web application who implements Entity Framework Core to manage data.

In my database, I have 4 tables who are very often used and joined to almost each requests, and the data in this tables are very rarely updated, si I would like to put them in cache to not fetch data in database each time, but only for this tables.

How can I do that with Entity Framework Core ?

I read the documentation but I didn't found anything about caching : https://docs.efproject.net/en/latest

Ok... this issue on GitHub let me think there is nothing available yet in Entity Framework Core for caching : github.com/aspnet/EntityFramework/issues/5858 — AdrienTorris
– AdrienTorris, Commented Oct 25, 2016 at 12:35
I have to deal with ASP.NET Core caching module docs.asp.net/en/latest/performance/caching/index.html — AdrienTorris
– AdrienTorris, Commented Oct 25, 2016 at 12:38
Have tried docs.asp.net/en/latest/performance/caching/memory.html ? — Shyju
– Shyju, Commented Oct 25, 2016 at 14:18

Sampath · Accepted Answer · 2016-10-25 13:43:09Z

1

You can use StackExchange.Redis cache for that.You just need to store your tables data on it and invalidate it when tables will be updated.That is it.

Here is the Link : StackExchange.Redis

answered Oct 25, 2016 at 13:43

Sampath

66.2k70 gold badges327 silver badges462 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitry · Accepted Answer · 2016-10-27 14:33:20Z

0

I don't think you will be able to use "cached" table rows in your EF queries. You can cache tables (in redis, memory - any on your choice), but when you will make queries to your DB - you will need to perform additional manual processing in your code (in server memory) for joining results from EF with cached tables.

answered Oct 27, 2016 at 14:33

Dmitry

17k4 gold badges66 silver badges79 bronze badges

Comments

cemdev · Accepted Answer · 2018-03-15 14:17:09Z

0

AFAIK, EF doesn't have caching. NHibernate however has excellent caching support. It's a little bit painful to have to use EF now instead of NHibernate, but NHibernate doesn't support Core quite yet.

answered Mar 15, 2018 at 14:17

cemdev

111 bronze badge

Collectives™ on Stack Overflow

Cache table with Entity Framework Core

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related