public static List <Plant> ReadPlantData()
{
var allPlants = new List <Plant>();
//const string connectionString = "";
//var queryString = "SELECT EmpNo, EName FROM Emp";
//using (var connection = new OracleConnection(connectionString))
//{
// var command = new OracleCommand(queryString, connection);
// connection.Open();
// using (var reader = command.ExecuteReader())
// {
// // Always call Read before accessing data.
// while (reader.Read())
// {
// Console.WriteLine(reader.GetInt32(0) + ", " + reader.GetString(1));
// }
// }
//}
var reader = DataReaderGenerator.Plants();
while (reader.Read())
{
var plant = new Plant();
plant.Name = reader["name"] as string;
plant.ID = reader["id"] as string;
plant.Description = reader["desc"] as string;
allPlants.Add(plant);
}
return(allPlants);
}
