将oracle行读取到对象Asp.net中

using Oracle.DataAccess.Client; // 或者使用Oracle.ManagedDataAccess.Client;

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

public class OracleDataReaderExample
{
    public List<Employee> ReadEmployeesFromOracle()
    {
        string connectionString = "Data Source=OracleDB;User Id=username;Password=password;";
        string query = "SELECT * FROM Employees";

        List<Employee> employees = new List<Employee>();

        using (OracleConnection connection = new OracleConnection(connectionString))
        {
            connection.Open();

            using (OracleCommand command = new OracleCommand(query, connection))
            {
                using (OracleDataReader 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);
                    }
                }
            }
        }

        return employees;
    }
}