如何在SQL中执行ASP.NET查询并传递给视图

using System.Data.SqlClient;
using System.Collections.Generic;

public class HomeController : Controller
{
    public ActionResult Index()
    {
        List<string> results = new List<string>();

        using (SqlConnection connection = new SqlConnection("YourConnectionString"))
        {
            SqlCommand command = new SqlCommand("SELECT * FROM YourTable", connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();
            while (reader.Read())
            {
                results.Add(reader["ColumnName"].ToString());
            }
        }

        return View(results);
    }
}

@foreach (var item in Model)
{
    <p>@item</p>
}

public class YourEntity
{
    public int Id { get; set; }
    public string ColumnName { get; set; }
}

public class YourDbContext : DbContext
{
    public DbSet<YourEntity> YourEntities { get; set; }
}

public class HomeController : Controller
{
    private readonly YourDbContext _context;

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

    public ActionResult Index()
    {
        var results = _context.YourEntities.ToList();
        return View(results);
    }
}

public class HomeController : Controller
{
    private readonly YourDataContext _context;

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

    public ActionResult Index()
    {
        var results = from item in _context.YourTable select item;
        return View(results);
    }
}