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