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