/// <summary> /// Fills a single instance with data based on its primary key values. /// </summary> public virtual void Fill(CreditScoreExclusionReasonType csert, System.Int16 id) { // create the connection to use SqlConnection cnn = new SqlConnection(CreditScoreExclusionReasonType.GetConnectionString()); try { // discover the sql parameters SqlParameterHash sqlparams = SqlHelperParameterCache.GetSpParameterSet(CreditScoreExclusionReasonType.GetConnectionString(), "gsp_SelectCreditScoreExclusionReasonType"); 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_SelectCreditScoreExclusionReasonType", sqlparams); if (datareader.Read()) csert.SetMembers(ref datareader); cnn.Close(); // close the connection } // nullify the connection var cnn = null; } catch (SqlException sqlex) { throw sqlex; } }