public List <GroceryItem> GetGroceryListQuery() { // Create and open database connection string connectionString = GetConnectionString(); NpgsqlConnection conn = new NpgsqlConnection(connectionString); conn.Open(); // Define Query var sql = "SELECT * FROM GroceryItems " + "ORDER BY last_modified ASC NULLS LAST;"; NpgsqlCommand cmd = new NpgsqlCommand(sql, conn); // Execute Query NpgsqlDataReader dataReader = cmd.ExecuteReader(); List <GroceryItem> groceryList = new List <GroceryItem>(); // try // { groceryList = _dataMapper.GetGroceryItemsMapper(dataReader); // } // catch (NpgsqlException e) // { // Console.WriteLine(e); // throw; // } // finally // { // Console.WriteLine("Closing connections"); conn.Close(); // } return(groceryList); }