Cache table with Entity Framework Core

asp.net-core-1.0 asp.net-core-mvc 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

1
3
10/25/2016 12:31:32 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

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

1
10/25/2016 1:43:09 PM

Related Questions

Entity Framework - How to Insert to table with foreign keys without retrieving foreign table rows first

I'm having a hard time finding the exact answer to this question, so my apologies if this is redundant....So I have 3 tables defined such that:...Person :PersonId, FirstName, LastName...Company: CompanyId, CompanyName...Order: OrderId, PersonId, CompanyId...On the Order table, there is a foreign key defined on the PersonId and CompanyId columns, th...
entity-framework entity-framework-6 insert
asked by WerkingWill

Entity Framework, Load multiple entities by primary key in a single query while still using caching

I have a list of primary key ids for a table whose entities I want to pull into EF memory, modify, and then save....With a single id you would do something like...var entity = dbContext.Entity.Find(id); entity.SomeColumn = "something"; dbContext.SaveChanges() ...Currently I'm doing something like this to pull all the entities to be modified in on...
.net c# entity-framework entity-framework-6
asked by Slight

.net core entity framework (EF Core) table naming convention

In short...Extend ModelBuilder with an extension method, do some regex, and call the method in you DbContext ...In Detail...Create an extension for ...ModelBuilder... class...public static class ModelBuilderExtensions { public static void SetSimpleUnderscoreTableNameConvention(this ModelBuilder modelBuilder) { foreach (IMutableEnti...
c# entity-framework entity-framework-core
asked by Faraj Farook

Pattern for caching data in Asp.Net Core + EF Core?

I have an Asp.Net Core + EF Core REST service. I created a DbContext class for a DB I want to call a SP on. The method pretty much looks like:...public IQueryable<xxx> Getxxxs() { return Set<xxx>().FromSql("pr_Getxxx"); } ...This all works, but there isn't any point in calling the SP every single time since the data the SP returns rarely change...
asp.net-core c# entity-framework-core
asked by SledgeHammer

How to get Table Name of mapped entity in Entity Framework Core

Using the ...Microsoft.EntityFrameworkCore.Relational... package in 2.X:...var mapping = dbContext.Model.FindEntityType(typeof(YourEntity)).Relational(); var schema = mapping.Schema; var tableName = mapping.TableName; ...This assumes that ...dbContext... is a instance of class that inherits from ...DbContext... and that you have ...YourEntity... co...
.net-core asp.net-core entity-framework-core
asked by Krzysztof Branicki

Log DbContext.SaveChanges Exception to the database in Entity Framework/Entity Framework Core

In Entity framework Core, I have solved the problem easily using EF-Core ...Transaction...try { _unitOfWork.Repository<Product>().InsertEntity(product); await _unitOfWork.SaveChangesAsync();//This throws exception due the model validation failure } catch (Exception exception) { ExceptionModel exceptionModel = new ExceptionModel(); ...
asp.net-core c# entity-framework entity-framework-core
asked by TanvirArjel

How to use a table like a reference table in Entity Framework Core

I have three tables, one for storing meta information, on for storing sites and one table for refencing the meta information to the sites....But I can't seem to figure out how to implement it correctly. It would be fairly easy in plain sql, but I want to learn the entity framework core method....How would you solve this?...IncludeHubEntry;...public...
c# entity-framework entity-framework-core
asked by Stein The Ruler

No method to map entity to table in entity framework core

You can use the below approach. You have to use ...Table... data annotation....DBContext:...public virtual DbSet<Article> Article { get; set; } protected override void OnModelCreating(ModelBuilder modelBuilder) { base.OnModelCreating(modelBuilder); modelBuilder.Entity<Article>(b => { b.Property(e => e.Property1).HasDefaultValu...
.net c# entity-framework-core
asked by vivek nuna

Force inherited classes in ASP.NET Core Entity Framework Core to dedicated MySQL table

Having a model ...Thread... that should countain all attributes of another model called ...Post... I use inheritance:...class Post { public int Id{get;set;} public string Title{get;set;} // ... } class Thread: Post { public int ForumId{get;set;} // ... } ...EF Core put both in a single table and adds the column ...Discriminator....
asp.net-core c# ef-code-first entity-framework-core mysql
asked by Lion

Caching entity itself in IMemoryCache in ASP.NET Core MVC with Entity Framework

In an ASP.NET Core MVC app I'm using ...IMemoryCache... in ...ConfigureServices()...:...services.AddMemoryCache(); ...In a controller, I originally had this code:...// List<> of POCOs: var myLines = await _context.MyEntity.Where(somecondition).ToListAsync(); ...and I've changed it to:...// List<> of POCOs: var myLines = await _cache.GetOrCreate...
asp.net-core-mvc caching entity-framework-core
asked by Feri

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow