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> /// <typeparam name="TValue"></typeparam> /// <param name="instanceDb"></param> /// <param name="storedProcedureName"></param> /// <param name="binding"></param> /// <param name="parameterValues"></param> /// <returns></returns> public static TValue GetObjectDB <TValue>(string instanceDb, string storedProcedureName, CreateInstanceBindingHandler <TValue> binding, params object[] parameterValues) { if (log.IsInfoEnabled) { log.InfoFormat("GetObjectDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName); } return(SqlHelperFactory.SqlDataReaderToObject <TValue>(instanceDb, storedProcedureName, binding, parameterValues)); }
public static TValue SqlDataReaderToObject <TValue>(string instanceDb, string storedProcedureName, params object[] parameterValues) { return(SqlHelperFactory.SqlDataReaderToObject <TValue>(instanceDb, storedProcedureName, delegate(TValue o, IDataReader dataReader) { ((IBindingObject)o).Binding(dataReader); }, parameterValues)); }
public static TValue SqlDataReaderToObject <TValue>(string instanceDb, string storedProcedureName, BindingHandler <TValue> binding, params object[] parameterValues) { Database db = null; DbCommand commandWrapper = null; db = DatabaseFactory.CreateDatabase(instanceDb); TValue returnValue; using (commandWrapper = db.GetStoredProcCommand(storedProcedureName, parameterValues)) { returnValue = SqlHelperFactory.SqlDataReaderToObject <TValue>(db.ExecuteReader(commandWrapper), binding); } return(returnValue); }
public static Dictionary <TKey, TValue> GetDictionaryDB <TKey, TValue>(string instanceDb, string storedProcedureName, params object[] parameterValues) { if (log.IsInfoEnabled) { log.InfoFormat("GetDictionaryDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName); } Database db = null; DbCommand commandWrapper = null; db = DatabaseFactory.CreateDatabase(instanceDb); Dictionary <TKey, TValue> returnValue = null; using (commandWrapper = db.GetStoredProcCommand(storedProcedureName, parameterValues)) { returnValue = SqlHelperFactory.SqlDataReaderToDictionary <TKey, TValue>(db.ExecuteReader(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); }