Retrieving data from database using SqlDataReader

code06.cs

var result = "";

using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
            {
                connection.Open();

                using (SqlCommand cmd = new SqlCommand(@"SELECT * FROM Table WHERE Id = @Input", connection))
                {
                    cmd.Parameters.Add("Input", SqlDbType.Int).Value = 1;

                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        while (reader.Read())
                        {
                            result =  reader["FirstName"].ToString();
                        }
                    }
                }
            }
            
            return result;