如何使用c#将sql查询的结果值作为回复返回给bot应用程序

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

public class BotResponse
{
    public string Reply { get; set; }
}

public class Bot
{
    public BotResponse GetBotReply(string userInput)
    {
        // 建立与数据库的连接
        string connectionString = "Your_Connection_String";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            // 构建SQL查询语句
            string query = "SELECT Reply FROM BotResponses WHERE UserInput = @UserInput";

            // 创建并执行SqlCommand对象
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                // 添加参数
                command.Parameters.AddWithValue("@UserInput", userInput);

                // 执行查询并获取结果
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    if (reader.Read())
                    {
                        // 获取查询结果的值
                        string reply = reader["Reply"].ToString();

                        // 构造回复对象
                        BotResponse botResponse = new BotResponse { Reply = reply };
                        
                        // 返回回复对象
                        return botResponse;
                    }
                }
            }
        }

        // 如果没有查询到结果，则返回空回复
        return new BotResponse { Reply = "Sorry, I don't have a response for that." };
    }
}

// 使用示例
Bot bot = new Bot();
string userInput = "Hello";
BotResponse botReply = bot.GetBotReply(userInput);
Console.WriteLine(botReply.Reply);