/// <summary> /// Fills a single instance with data based on its primary key values. /// </summary> public virtual void Fill(BorrowerResidencyType brt, System.Int16 id) { // create the connection to use SqlConnection cnn = new SqlConnection(BorrowerResidencyType.GetConnectionString()); try { // discover the sql parameters SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(BorrowerResidencyType.GetConnectionString(), "gsp_SelectBorrowerResidencyType"); using (cnn) { // open the connection cnn.Open(); // set the parameters sqlparams["@id"].Value = id; // create an instance of the reader to fill. SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectBorrowerResidencyType", sqlparams); if (datareader.Read()) brt.SetMembers(ref datareader); cnn.Close(); // close the connection } // nullify the connection var cnn = null; } catch (SqlException sqlex) { throw sqlex; } }