public List<MyTask> GetAllTasks() { using (XmlReader reader = XmlReader.Create(_connectionString)) { List<MyTask> listOfTasks = new List<MyTask>(); while (reader.Read()) { switch (reader.NodeType) { case XmlNodeType.Element: break; case XmlNodeType.Text: MyTask myTask = new MyTask(); myTask.TaskId = Convert.ToInt32(reader.Value); listOfTasks.Add(myTask); break; case XmlNodeType.XmlDeclaration: case XmlNodeType.ProcessingInstruction: //reader.WriteProcessingInstruction(reader.Name, reader.Value); break; case XmlNodeType.Comment: //reader.WriteComment(reader.Value); break; case XmlNodeType.EndElement: //reader.WriteFullEndElement(); break; } } return listOfTasks; } }
public List<MyTask> GetAllTasks() { using (var connection = new SqlConnection(this._connectionString)) { connection.Open(); using (var command = new SqlCommand()) { command.Connection = connection; command.CommandText = SELECT_SECTIONS; command.CommandType = System.Data.CommandType.Text; using (var reader = command.ExecuteReader()) { List<MyTask> listOfTasks = new List<MyTask>(); while (reader.Read()) { MyTask myTask = new MyTask(); myTask.TaskId = (int)reader["Id"]; listOfTasks.Add(myTask); } return listOfTasks; } } } }