在数据表中查找一行并在.Net中删除它

using System;
using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Server=localhost;Database=myDatabase;User Id=myUsername;Password=myPassword;";
        string searchQuery = "SELECT * FROM myTable WHERE id = @id";
        string deleteQuery = "DELETE FROM myTable WHERE id = @id";
        int idToDelete = 1;

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();

            using (SqlCommand searchCommand = new SqlCommand(searchQuery, connection))
            {
                searchCommand.Parameters.AddWithValue("@id", idToDelete);

                using (SqlDataReader reader = searchCommand.ExecuteReader())
                {
                    if (reader.HasRows)
                    {
                        // The row was found
                        Console.WriteLine("The row was found and will be deleted.");

                        using (SqlCommand deleteCommand = new SqlCommand(deleteQuery, connection))
                        {
                            deleteCommand.Parameters.AddWithValue("@id", idToDelete);
                            deleteCommand.ExecuteNonQuery();
                            Console.WriteLine("The row was deleted successfully.");
                        }
                    }
                    else
                    {
                        // The row was not found
                        Console.WriteLine("The row was not found.");
                    }
                }
            }
        }
    }
}