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