public static List <TValue> GetListDB <TValue>(string instanceDb, string storedProcedureName, BindingHandler <TValue> binding, object[] parameterValues, ParameterOutputHandler parameterOutput) { if (log.IsInfoEnabled) { log.InfoFormat("GetListDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName); } Database db = null; DbCommand commandWrapper = null; db = DatabaseFactory.CreateDatabase(instanceDb); List <TValue> returnValue = null; using (commandWrapper = db.GetStoredProcCommand(storedProcedureName, parameterValues)) { if (binding == null) { returnValue = SqlHelperFactory.SqlDataReaderToList <TValue>(db.ExecuteReader(commandWrapper)); } else { returnValue = SqlHelperFactory.SqlDataReaderToList <TValue>(db.ExecuteReader(commandWrapper), binding); } if (parameterOutput != null) { parameterOutput(db, commandWrapper); } } return(returnValue); }
/// <summary> /// /// </summary> /// <param name="typeReturn"></param> /// <returns></returns> public static List <TValue> GetListDB <TValue>(string instanceDb, string storedProcedureName, BindingHandler <TValue> binding) { if (log.IsInfoEnabled) { log.InfoFormat("GetListDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName); } Database db = null; DbCommand commandWrapper = null; db = DatabaseFactory.CreateDatabase(instanceDb); List <TValue> returnValue = null; using (commandWrapper = db.GetStoredProcCommand(storedProcedureName)) { returnValue = SqlHelperFactory.SqlDataReaderToList <TValue>(db.ExecuteReader(commandWrapper), binding); } return(returnValue); }