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;
}
}
}
}