如何在Web API中使用SQL连接

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Http;

public class DataController : ApiController
{
    private string connectionString = "Server=your_server;Database=your_database;User Id=your_user;Password=your_password;";

    [HttpGet]
    public IHttpActionResult GetData()
    {
        try
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                string query = "SELECT * FROM YourTable";
                SqlCommand command = new SqlCommand(query, connection);
                SqlDataReader reader = command.ExecuteReader();

                DataTable dataTable = new DataTable();
                dataTable.Load(reader);

                return Ok(dataTable);
            }
        }
        catch (Exception ex)
        {
            return InternalServerError(ex);
        }
    }
}