---

static void UpdateBookPrice(int bookId, decimal newPrice)
{
    string connectionString = @"Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=Library;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False";
    string sql = "UPDATE Books SET Price = @NewPrice WHERE Id = @Id";

    using (SqlConnection conn = new SqlConnection(connectionString))
    {
        conn.Open();
        
        using (SqlCommand cmd = new SqlCommand(sql, conn))
        {
            cmd.Parameters.AddWithValue("@NewPrice", newPrice);
            cmd.Parameters.AddWithValue("@Id", bookId);
            
            int rows = cmd.ExecuteNonQuery();
            Console.WriteLine($"Обновлено строк: {rows}");
        }
    }
}