public IEnumerable <TaskList> GetAll()
{
NpgsqlCommand command = new NpgsqlCommand("select id, name from tasks_list", conn);
using (DbDataReader dr = command.ExecuteReader())
{
while (dr.Read())
{
yield return(TaskListMapper.map(dr));
}
}
}
public TaskList GetById(long id)
{
NpgsqlCommand command = new NpgsqlCommand("select id, name from tasks_list where id = @id", conn);
command.Parameters.AddWithValue("id", NpgsqlDbType.Bigint, id);
using (NpgsqlDataReader dr = command.ExecuteReader())
{
dr.Read();
return(TaskListMapper.map(dr));
}
}
