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