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