code:

        public Person GetPersonById(int id)
        {
            Person SingularInst = null;
            SqlConnection conn = ConnectionManager.GetConnection();
            SqlCommand comm = conn.CreateCommand();

            comm.CommandText = "getPersonById";
            comm.CommandType = CommandType.StoredProcedure;

            SqlParameterCollection SPParams = comm.Parameters;
            SPParams.Add(new SqlParameter("@ID", SqlDbType.Int)).Value = id;

            try
            {
                conn.Open();
                SqlDataReader Reader = comm.ExecuteReader(CommandBehavior.CloseConnection);

                while (Reader.Read())
                    SingularInst = BuildPerson(Reader);
                Reader.Close();
            }
            catch (Exception e)
            {
                throw new Exception("Database Layer: " + e.Message);
            }
            finally
            {
                conn.Close();
            }
            return SingularInst;
        }