是否等待数据库中的列值更新并在C#中返回值？

using System;
using System.Data.SqlClient;
using System.Threading.Tasks;

public class Program
{
    public static async Task Main()
    {
        string connectionString = "your_connection_string";
        string query = "SELECT column_name FROM table_name WHERE condition";

        string result = await WaitForColumnValueUpdate(connectionString, query);
        Console.WriteLine(result);
    }

    public static async Task<string> WaitForColumnValueUpdate(string connectionString, string query)
    {
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            await connection.OpenAsync();

            using (SqlCommand command = new SqlCommand(query, connection))
            {
                string currentValue = await command.ExecuteScalarAsync() as string;

                while (currentValue == null || currentValue != "desired_value")
                {
                    await Task.Delay(1000); // Wait for 1 second before checking again

                    currentValue = await command.ExecuteScalarAsync() as string;
                }

                return currentValue;
            }
        }
    }
}