如何从数据库填充ASP.NET实体框架中的列表

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

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }
}

public class EmployeeRepository
{
    private string connectionString = "YourConnectionString";

    public List<Employee> GetEmployees()
    {
        List<Employee> employees = new List<Employee>();

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            string query = "SELECT Id, Name, Department FROM Employees";
            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Employee employee = new Employee();
                employee.Id = Convert.ToInt32(reader["Id"]);
                employee.Name = reader["Name"].ToString();
                employee.Department = reader["Department"].ToString();

                employees.Add(employee);
            }

            reader.Close();
        }

        return employees;
    }
}

// 在页面或控制器中使用EmployeeRepository类来填充实体列表
EmployeeRepository repository = new EmployeeRepository();
List<Employee> employees = repository.GetEmployees();