public IEnumerable <TaskItem> GetAll() { NpgsqlCommand command = new NpgsqlCommand("select id, title, " + "is_done, list_id from tasks", conn); using (NpgsqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { yield return(TaskMapper.map(dr)); } } }
public IEnumerable <TaskItem> GetByListId(long listId) { NpgsqlCommand command = new NpgsqlCommand("select id, title, " + "is_done, list_id from tasks where list_id = @list_id", conn); command.Parameters.AddWithValue("list_id", NpgsqlDbType.Bigint, listId); using (NpgsqlDataReader dr = command.ExecuteReader()) { while (dr.Read()) { yield return(TaskMapper.map(dr)); } } }