在C#中查询数据库中的枚举值

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

public class Program
{
    public enum Status
    {
        Active,
        Inactive,
        Pending
    }

    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string query = "SELECT Status FROM YourTable";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();

            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                int statusValue = Convert.ToInt32(reader["Status"]);
                Status status = (Status)statusValue;

                Console.WriteLine("Status: " + status);
            }

            reader.Close();
        }
    }
}