A second operation started on this context before a previous operation completed

asp.net-core entity-framework-core memorycache

Question

I have a project with asp.net core and entity framework core, for performance reasons I use MemoryCache. ForumQueryManager class is for querying forum data and this class for data use CacheManager Get method and pass cachekey and timeout cache time and a method for when cache is empty for retrieving data from database. this code work almost always. but sometimes throw exception

Exception:

An unhandled exception occurred while processing the request. InvalidOperationException: A second operation started on this context before a previous operation completed. Any instance members are not guaranteed to be thread safe.

Microsoft.EntityFrameworkCore.Internal.ConcurrencyDetector.EnterCriticalSection()

ForumQueryManager:

public class ForumQueryManager : IForumQueryManager
{
    private readonly NashrNegarDbContext _dbContext;
    private readonly ICalender _calender;

    private readonly ICacheManager _cacheManager;

    public ForumQueryManager(NashrNegarDbContext dbContext, ICacheManager cacheManager)
    {
        _dbContext = dbContext;
        _cacheManager = cacheManager;
    }

    public async Task<List<ForumCategoryDto>> GetAll()
    {
        var items = await _cacheManager.Get(CacheConstants.ForumCategories, 20, GetForumCategories);

        return items;
    }

    private async Task<List<ForumCategoryDto>> GetForumCategories()
    {
        var categories = await _dbContext.ForumCategories
            .Select(e => new ForumCategoryDto
            {
                Name = e.Name,
                ForumCategoryId = e.ForumCategoryId
            }).ToListAsync();

        return categories;
    }
}

CacheManager:

public class CacheManager: ICacheManager
{
    private readonly IMemoryCache _cache;
    private readonly CacheSetting _cacheSetting;

    public CacheManager(IMemoryCache cache, IOptions<CacheSetting> cacheOption)
    {
        _cache = cache;
        _cacheSetting = cacheOption.Value;
    }

    public async Task<List<T>> Get<T>(string cacheKey, int expirationMinutes, Func<Task<List<T>>> function)
    {
        List<T> items;

        if (_cacheSetting.MemeoryEnabled)
        {
            var value = _cache.Get<string>(cacheKey);

            if (value == null)
            {
                items = await function();

                value = JsonConvert.SerializeObject(items, Formatting.Indented,
                    new JsonSerializerSettings
                    {
                        NullValueHandling = NullValueHandling.Ignore,
                        MissingMemberHandling = MissingMemberHandling.Ignore,
                        ReferenceLoopHandling = ReferenceLoopHandling.Ignore
                    });

                _cache.Set(cacheKey, value,
                    new MemoryCacheEntryOptions().SetAbsoluteExpiration(TimeSpan.FromMinutes(expirationMinutes)));
            }
            else
            {
                items = JsonConvert.DeserializeObject<List<T>>(value);
            }

        }
        else
        {
            items = await function();
        }

        return items;
    }
}
1
1
5/9/2017 5:00:35 AM

Popular Answer

ForumQueryManager must be transient, otherwise the _dbContext variable will be reused.

0
9/1/2017 9:15:44 AM


Related Questions





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