将带实体框架的GET转换为不带实体框架的GET

using System;
using System.Data;
using System.Data.SqlClient;

public class DatabaseHelper
{
    private string connectionString = "your_connection_string_here";

    public DataTable ExecuteGetQuery(string sql, SqlParameter[] parameters = null)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(sql, connection);
            if (parameters != null)
            {
                command.Parameters.AddRange(parameters);
            }

            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable dataTable = new DataTable();
            adapter.Fill(dataTable);
            return dataTable;
        }
    }
}

// 使用示例
public void GetUsers()
{
    DatabaseHelper dbHelper = new DatabaseHelper();
    string sql = "SELECT * FROM Users WHERE Age > @Age";
    SqlParameter ageParam = new SqlParameter("@Age", SqlDbType.Int) { Value = 18 };

    DataTable users = dbHelper.ExecuteGetQuery(sql, new SqlParameter[] { ageParam });
    foreach (DataRow row in users.Rows)
    {
        Console.WriteLine($"User ID: {row["UserId"]}, Name: {row["Name"]}");
    }
}