/// <summary>
///
/// </summary>
/// <param name="instanceDb"></param>
/// <param name="storedProcedureName"></param>
/// <param name="parameterValues"></param>
public static void ExecuteNonQuery(string instanceDb, string storedProcedureName, object[] parameterValues, ParameterOutputHandler parameterOutput)
{
if (log.IsInfoEnabled)
{
log.InfoFormat("ExecuteNonQuery(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName);
}
Database db = null;
DbCommand commandWrapper = null;
db = DatabaseFactory.CreateDatabase(instanceDb);
using (commandWrapper = db.GetStoredProcCommand(storedProcedureName, parameterValues))
{
db.ExecuteNonQuery(commandWrapper);
if (parameterOutput != null)
{
parameterOutput(db, commandWrapper);
}
}
}
public static List <TValue> GetListCreateInstanceDB <TValue>(string instanceDb, string storedProcedureName, CreateInstanceBindingHandler <TValue> binding, object[] parameterValues, ParameterOutputHandler parameterOutput)
{
if (log.IsInfoEnabled)
{
log.InfoFormat("GetListCreateInstanceDB(instanceDb:{0}, storedProcedureName:{1})", instanceDb, storedProcedureName);
}
SqlDatabase db = null;
DbCommand commandWrapper = null;
db = DatabaseFactory.CreateDatabase(instanceDb) as SqlDatabase;
List <TValue> returnValue = new List <TValue>();
using (commandWrapper = db.GetStoredProcCommand(storedProcedureName, parameterValues))
{
IDataReader sdrReader = db.ExecuteReader(commandWrapper);
while (sdrReader.Read())
{
returnValue.Add(binding(sdrReader));
}
sdrReader.Close();
if (parameterOutput != null)
{
parameterOutput(db, commandWrapper);
}
}
return(returnValue);
}
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);
}
