如何在没有实体框架的情况下在 ASP.NET 上使用 ajax 和 jquery 从列表创建数据表

我正在try 用ASP.NETMVC创建带有HTML显示的表格.

这是样品

@model IEnumerable
<Vitashopper.Models.Goods>

  <title>
    Master Goods Vitashopper
  </title>
  
  <p>
    @Html.ActionLink("Create New", "Create", new { @class = "btn btn-success" })
  </p>

  <table class="table">
    <tr>
      <th>
        @Html.DisplayNameFor(model => model.ProductId)
      </th>
      <th>
        @Html.DisplayNameFor(model => model.ProductName)
      </th>
      <th>
        @Html.DisplayNameFor(model => model.BuyPrice)
      </th>
      <th>
        @Html.DisplayNameFor(model => model.SellPrice)
      </th>
      <th>
        @Html.DisplayNameFor(model => model.Stock)
      </th>
      <th>
        @Html.DisplayNameFor(model => model.Description)
      </th>
      <th>
        @Html.DisplayNameFor(model => model.Remarks)
      </th>
      <th></th>
    </tr>

    @foreach (var item in Model) {
    <tr>
      <td>
        @Html.DisplayFor(modelItem => item.ProductId)
      </td>
      <td>
        @Html.DisplayFor(modelItem => item.ProductName)
      </td>
      <td>
        @Html.DisplayFor(modelItem => item.BuyPrice)
      </td>
      <td>
        @Html.DisplayFor(modelItem => item.SellPrice)
      </td>
      <td>
        @Html.DisplayFor(modelItem => item.Stock)
      </td>
      <td>
        @Html.DisplayFor(modelItem => item.Description)
      </td>
      <td>
        @Html.DisplayFor(modelItem => item.Remarks)
      </td>
      <td>
        @Html.ActionLink("Edit", "Edit", new { id = item.ProductId }, new { @class = "btn btn-primary" }) | @Html.ActionLink("Delete", "Delete", new { id = item.ProductId }, new { @class = "btn btn-danger", onclick = "return confirm('Are sure wants to delete?');"
        })
      </td>
    </tr>
    }
  </table>

以下是我正在使用的模型:

public class Goods
{
  public int ProductId { get; set; }

  [DisplayName("Product Name")]
  public string ProductName { get; set; }

  public decimal BuyPrice { get; set; }
  public decimal SellPrice { get; set; }

  [Required]
  public int Stock { get; set; }

  public string Description { get; set; }
  public string Remarks { get; set; }
}

这是我的控制器

public List < Goods > GetGoods() 
{
  connection();
  List < Goods > goodslist = new List < Goods > ();

  SqlCommand cmd = new SqlCommand("GetAllGoods", con);
  cmd.CommandType = CommandType.StoredProcedure;

  SqlDataAdapter sd = new SqlDataAdapter(cmd);
  DataTable dt = new DataTable();

  con.Open();
  sd.Fill(dt);
  con.Close();

  foreach(DataRow dr in dt.Rows) {
    goodslist.Add(
      new Goods {
        ProductId = Convert.ToInt32(dr["ProductID"]),
          ProductName = Convert.ToString(dr["ProductName"]),
          BuyPrice = Convert.ToDecimal(dr["BuyPrice"]),
          SellPrice = Convert.ToDecimal(dr["SellPrice"]),
          Stock = Convert.ToInt32(dr["Stock"]),
          Description = Convert.ToString(dr["Description"]),
          Remarks = Convert.ToString(dr["Remarks"])
      });
  }

  return goodslist;
}

我的问题是，有没有可能在没有实体框架的情况下将这个数据表迁移到AJAX和jQuery？我一直在寻找，但问题解决了实体框架不使用SQL Server数据库.

预期输出应如此屏幕截图所示: