public List <T> ExecuteReader(string where, string orderBy)
{
QueryBuilder <T> queryBuilder = new QueryBuilder <T>();
List <T> returnList = new List <T>();
if (oracleConnection.State != ConnectionState.Open)
{
oracleConnection.Open();
}
OracleCommand cmd = new OracleCommand();
cmd.Connection = oracleConnection;
cmd.CommandText = queryBuilder.GetSelectAllQuery(where, orderBy);
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
PropertyReader <T> propertyReader = new PropertyReader <T>();
T obj = propertyReader.CreateObjectFromDataReader(dr);
returnList.Add(obj);
}
oracleConnection.Close();
return(returnList);
}
public List <T> ExecuteReader(string command)
{
if (oracleConnection.State != ConnectionState.Open)
{
oracleConnection.Open();
}
List <T> returnList = new List <T>();
OracleCommand cmd = new OracleCommand();
cmd.Connection = oracleConnection;
cmd.CommandText = command;
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
PropertyReader <T> propertyReader = new PropertyReader <T>();
T obj = propertyReader.CreateObjectFromDataReader(dr);
returnList.Add(obj);
}
oracleConnection.Close();
return(returnList);
}
