/// <summary> /// Retrieve a record from the database. /// </summary> /// <param name="id"></param> /// <returns></returns> /// <remarks></remarks> public Datafile RetrieveDatafile(int id) { DbCommand cmd = store.GetStoredProcCommand("RetrieveDatafileByID"); store.AddInParameter(cmd, "id", DbType.String, id); using (System.Data.IDataReader reader = store.ExecuteReader(cmd)) { if (reader.Read() == true) { Datafile newfile = new Datafile(); newfile.ID = reader.GetInt32(reader.GetOrdinal("id")); newfile.Category = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("category"))); newfile.Group = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("group"))); newfile.Filename = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("filename"))); newfile.Extension = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("extension"))); newfile.Content = (byte[])(reader.GetValue(reader.GetOrdinal("content"))); return(newfile); } else { return(null); } } }