public List <IEvolution> GetEvolutions() { const string evolutionQuery = @"SELECT ID, NAME, FILE_NAME, CREATED_DATE, CONTENT, [CHECKPOINT] FROM EVOLUTION"; var results = new DataTable(); List <IEvolution> evolutions = new List <IEvolution>(); IEvolution evolution; using (SqlCommand cmd = new SqlCommand(evolutionQuery, _Connection)) { using (SqlDataReader r = cmd.ExecuteReader()) { results.Load(r); } } foreach (DataRow row in results.Rows) { evolution = new Entity.Evolution() { Id = (Guid)row["ID"], Name = row["NAME"].ToString(), FileName = row["FILE_NAME"].ToString(), Content = row["CONTENT"].ToString(), }; if (!int.TryParse(row["CHECKPOINT"].ToString(), out var checkpoint)) { checkpoint = 0; } evolution.CheckPoint = checkpoint; evolutions.Add(evolution); } return(evolutions); }
public List <IEvolution> GetEvolutions() { const string evolutionQuery = @"SELECT ID, NAME, FILE_NAME, CREATED_DATE, CONTENT, HASH, CHECKPOINT FROM EVOLUTION"; var results = new DataTable(); List <IEvolution> evolutions = new List <IEvolution>(); IEvolution evolution; using (OracleCommand cmd = new OracleCommand(evolutionQuery, _Connection)) { using (OracleDataReader r = cmd.ExecuteReader()) { results.Load(r); } } foreach (DataRow row in results.Rows) { evolution = new Entity.Evolution() { Id = new Guid((byte[])row["ID"]), Name = row["NAME"].ToString(), FileName = row["FILE_NAME"].ToString(), Content = row["CONTENT"].ToString(), //TODO Implement hash //Hash = row["HASH"], Convert.to CheckPoint = int.Parse(row["CHECKPOINT"].ToString()) }; evolutions.Add(evolution); } return(evolutions); }