在MVC Core 3.1中显示最后一条Sql记录

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using System.Linq;

public class HomeController : Controller
{
    private readonly YourDbContext _context;

    public HomeController(YourDbContext context)
    {
        _context = context;
    }

    public IActionResult GetLastSqlRecord()
    {
        var lastRecord = _context.YourTableName
            .FromSqlRaw("SELECT TOP 1 * FROM YourTableName ORDER BY Id DESC")
            .FirstOrDefault();

        return View(lastRecord);
    }
}

@model YourModel

<h1>Last SQL Record</h1>

<p>Id: @Model.Id</p>
<p>Column1: @Model.Column1</p>
<p>Column2: @Model.Column2</p>
<!-- 其他列 -->