如何在.Net Core2.1Web应用程序中显示原始表

<ItemGroup>
  <PackageReference Include="Microsoft.EntityFrameworkCore" Version="2.1.0" />
  <PackageReference Include="Microsoft.EntityFrameworkCore.SqlServer" Version="2.1.0" />
</ItemGroup>

services.AddDbContext<YourDbContext>(options =>
    options.UseSqlServer(Configuration.GetConnectionString("YourConnectionString")));

using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;

namespace YourNamespace.Controllers
{
    public class RawTableController : Controller
    {
        private readonly YourDbContext _dbContext;

        public RawTableController(YourDbContext dbContext)
        {
            _dbContext = dbContext;
        }

        public IActionResult Index()
        {
            var rawTable = _dbContext.YourRawTable.FromSql("SELECT * FROM YourRawTable").ToList();
            return View(rawTable);
        }
    }
}

@model List<YourNamespace.YourRawTable>

<table>
    <thead>
        <tr>
            <th>Column1</th>
            <th>Column2</th>
            <!-- 添加其他列 -->
        </tr>
    </thead>
    <tbody>
        @foreach (var item in Model)
        {
            <tr>
                <td>@item.Column1</td>
                <td>@item.Column2</td>
                <!-- 添加其他列 -->
            </tr>
        }
    </tbody>
</table>

app.UseMvc(routes =>
{
    routes.MapRoute(
        name: "default",
        template: "{controller=Home}/{action=Index}/{id?}");
});