i have made auto refreshment for every 10 seconds while running my application suddenly came error below

Question

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

I am using entity framework but I got this error. I am using visual studio 2012 (MVC)and SQL Server 2012.

public JsonResult LineChart()
{
    List<AssetMigrationDetails> listDashBoard = new List<AssetMigrationDetails>();
    decimal sumTotal = 0;
    try
    {
          demoEntities2 objentity = new demoEntities2();
          var _objdBoard = (from data in objentity.tbl_dashboard
                               select new
                               {
                                   data.id
                               }).Count();

        sumTotal = Convert.ToDecimal(_objdBoard.ToString());

        var _objuserdetail = (from data in objentity.tbl_dashboard
                              where (data.isMigrated == "Y" && data.migrationdate <= System.DateTime.Now)
                              group data by EntityFunctions.TruncateTime(data.migrationdate) into k
                              select new
                              {
                                  date = k.Key,
                                  count = k.Count()
                              });

        foreach (var item in _objuserdetail)
        {
            AssetMigrationDetails objAsset = new AssetMigrationDetails();
            objAsset.Completion = (Convert.ToDecimal(item.count) / sumTotal) * 100;
            listDashBoard.Add(objAsset);

        }

        decimal sum = 0;
        decimal sum1 = 0;
        for (var i = 0; i < listDashBoard.Count(); i++)
        {
            sum = sum + Convert.ToDecimal(listDashBoard[i].Completion);
            sum1 = decimal.Parse(sum.ToString("0.00"));
            listDashBoard[i].Completion = sum1;
        }

        }

        catch (Exception ex)
        {
            var msg=ex.Message;
        }
        return Json(listDashBoard, JsonRequestBehavior.AllowGet);
 }

Answer 1

Replace Your Jquery for Auto Refresh

 $(document).ready(
              function () {
                  setInterval(function () {
                      $(".status").change();
                  }, 10000);
              });

---

Instead of .status you can use Your class name or id names