C#处理SQL查询的最佳方式

using System;
using System.Data.SqlClient;

namespace SQLQueryExample
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=serverName;Initial Catalog=databaseName;User ID=userName;Password=password";
            
            // 连接数据库
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();
                
                // 创建SQL查询
                string sqlQuery = "SELECT * FROM TableName";
                using (SqlCommand command = new SqlCommand(sqlQuery, connection))
                {
                    // 执行SQL查询
                    using (SqlDataReader reader = command.ExecuteReader())
                    {
                        // 处理查询结果
                        while (reader.Read())
                        {
                            int id = reader.GetInt32(0);
                            string name = reader.GetString(1);
                            
                            Console.WriteLine("ID: " + id + ", Name: " + name);
                        }
                    }
                }
                
                // 关闭数据库连接
                connection.Close();
            }
        }
    }
}