Execution timeout expired in distributed SQL server cache?

See more:

C#

SQL-Server

MVC

cache

, +

"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding." in distributed sql server cache

My Method to call in controller

public async Task<IEnumerable<NormalDeposit_DepositDetails>> GetAllNormalDeposit_DepositDetails_Async()
    {
        if (IsCacheEnable == true)
        {
            IEnumerable<NormalDeposit_DepositDetails> NormalDeposit_DepositDetails_AllList;
            var KeyHere = KeyCache.GenCacheKey(CacheKeyList.NormalDeposit_DepositDetails_CacheSecurityKeyString, SecurityKey);
            var GetCachehere = await distributedCache.GetStringAsync(KeyHere);
            if (string.IsNullOrEmpty(GetCachehere))
            {
                context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
                NormalDeposit_DepositDetails_AllList = await context.NormalDeposit_DepositDetails.AsNoTracking().ToListAsync();


                DistributedCacheEntryOptions options = new DistributedCacheEntryOptions();
                options.AbsoluteExpiration = DateTime.Now.AddHours(12);
                options.SlidingExpiration = TimeSpan.FromMinutes(30);
                var Value = JsonConvert.SerializeObject(NormalDeposit_DepositDetails_AllList);
               await distributedCache.SetStringAsync(KeyHere, Value, options);
                return NormalDeposit_DepositDetails_AllList;
            }
            else
            {
                return JsonConvert.DeserializeObject<IEnumerable<NormalDeposit_DepositDetails>>(GetCachehere);
            }
        }
        else
        {
            IEnumerable<NormalDeposit_DepositDetails> NormalDeposit_DepositDetails_AllList;
            context.ChangeTracker.QueryTrackingBehavior = QueryTrackingBehavior.NoTracking;
            NormalDeposit_DepositDetails_AllList = await context.NormalDeposit_DepositDetails.AsNoTracking().ToListAsync();
            return NormalDeposit_DepositDetails_AllList;
        }
    }

My controller method

[AllowAnonymous]
[HttpPost]
public async Task<IActionResult> GetDataHere()
{
    var ItemsHere = await normalDeposit_DepositDetailsInterface.GetAllNormalDeposit_DepositDetails_Async();
    decimal NormalDeposit_Deposit_AfterDeposit = ItemsHere.Where(a => a.Status == true ).Sum(s => s.Amount);

    return View("Index");
}

App.json method

"ConnectionStrings": {
   "ConnectionVar": "Server=DESKTOP-IACJQY;Database=$aZ1*,z.ahbz.@!78z)c;User Id=*&zkaUI190%$User{]z!Z,a;password=+1z)9.,!aEL%ZKI9@$MnaL><f;Trusted_Connection=False;MultipleActiveResultSets=true;Connection Timeout=1800;"
 }

Startup.cs

services.AddDistributedSqlServerCache(options =>
        {
            options.ConnectionString = _config.GetConnectionString("ConnectionVar");
            options.SchemaName = "dbo";
            options.TableName = "SQLSessions";
            options.DefaultSlidingExpiration = TimeSpan.FromMinutes(30);
            options.ExpiredItemsDeletionInterval = TimeSpan.FromMinutes(30);
        });

My problems:-

1) {"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."} in distributed sql server cache

When debug hits the line await distributedCache.SetStringAsync(KeyHere, Value, options); . the record is more then 3000 rows.

Please help if i am missing something. or need to be added in code. Thanks in advance for support and concern.

What I have tried:

I have tried Async method to wait it it complete, but still it appear have same problem. I have increase the connection timeout but nothing works.

Connection Timeout=1800;