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