使用MS SQL中的API检索表的简单方法

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

class Program
{
    static void Main()
    {
        // 数据库连接字符串
        string connectionString = "Server=your_server_name;Database=your_database_name;User Id=your_username;Password=your_password;";

        // SQL查询
        string sqlQuery = "SELECT * FROM Employees";

        try
        {
            // 创建数据库连接
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                // 打开连接
                connection.Open();

                // 创建SQL命令对象
                using (SqlCommand command = new SqlCommand(sqlQuery, connection))
                {
                    // 执行查询并获取数据
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // 遍历结果集
                        while (reader.Read())
                        {
                            // 假设Employees表有FirstName和LastName两列
                            Console.WriteLine($"FirstName: {reader["FirstName"]}, LastName: {reader["LastName"]}");
                        }
                    }
                }
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("An error occurred: " + ex.Message);
        }
    }
}