保存临时数据

Question

有时我们需要在事务中保存一些临时数据。如果它没有被强制执行，它将被删除。例如，上传图像。

那么最好的策略是什么呢？将数据保存在实际的数据库中，并执行删除不完整数据(行)的任务调度，或者将其保存在临时空间中，还是什么？

非常感谢。

Answer 1

以临时数据为例，我希望我做得对。以busroute为例：

  if (id != busRoute.BusRouteCode)
        {
            return NotFound();
        }

        if (ModelState.IsValid)
        {
            try
            {
                _context.Update(busRoute);
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!BusRouteExists(busRoute.BusRouteCode))
                {
                    return NotFound();
                }
                else
                {
                    throw;
                }
            }
            return RedirectToAction(nameof(Index));
        }
        return View(busRoute);
    }

    public async Task<IActionResult> Create([Bind("BusRouteCode,RouteName")] BusRoute busRoute)
    {
        if (ModelState.IsValid)
        {
            _context.Add(busRoute);
            await _context.SaveChangesAsync();
            return RedirectToAction(nameof(Index));
        }
        return View(busRoute);
    }

索引消息：-TempData“”=“欢迎加入成员列表...”；

        if (MemberId == null)
        {
            TempData["message"] = "Please select a Member...";
            RedirectToAction("SHMember", "Index");
        }

        string memberId = MemberId.ToString();
        var FullName = _context.Membership
            .Include("FullName")
            .Where(m => m.MemberId == MemberId)
            .Select(m => m.Member.FullName)
            .FirstOrDefault(); 

        if (memberId != null)
        {
            HttpContext.Session.SetString("MemberId", memberId);
            HttpContext.Session.SetString("FullName", FullName);
        }
        else
        {
            memberId = HttpContext.Session.GetString("MemberId");
            FullName = HttpContext.Session.GetString("FullName");

            if (memberId == null)
            {
                //return to View and Display Message
                TempData["message"] = "Please select a Member...";
                return RedirectToAction("Index", "Member");
            }
        }

        ViewBag.FullName = HttpContext.Session.GetString("FullName");

        var MembershipContext = _context.Membership
            .Where(m => m.MemberId == MemberId)
            .OrderByDescending(m=>m.Year);



        return View(await MembershipContext.ToListAsync());