public virtual IEnumerable <T> LoadObjectAsStreamResults <T>(IDbCommandDef db_command_def)
{
if (db_command_def == null)
{
throw new ArgumentException("Missing db command def object");
}
using (IDbConnection conn = DbConnection)
using (IDbCommand cmd = DbCommand)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandType = db_command_def.DbCommandType;
cmd.CommandText = db_command_def.DbCommandText;
cmd.CommandTimeout = CommandTimeout;
cmd.Connection = conn;
if (db_command_def.DbParameters != null)
{
foreach (IDbDataParameter param in db_command_def.DbParameters)
{
cmd.Parameters.Add(param);
}
}
IDataReader dreader = cmd.ExecuteReader();
while (dreader.Read())
{
yield return(FillItem <T>(dreader));
}
}
}
public object ExecuteDbScalar(IDbCommandDef commandDef)
{
try
{
using (IDbConnection conn = DbConnection)
using (IDbCommand cmd = DbCommand)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandType = commandDef.DbCommandType;
cmd.CommandText = commandDef.DbCommandText;
cmd.CommandTimeout = CommandTimeout;
cmd.Connection = conn;
if (commandDef.DbParameters != null)
{
foreach (IDbDataParameter param in commandDef.DbParameters)
{
cmd.Parameters.Add(param);
}
}
return(cmd.ExecuteScalar());
}
}
catch { throw; }
}
public object ExecuteDbScalar(IDbCommandDef db_command_def)
{
try
{
using (IDbConnection conn = DbConnection)
using (IDbCommand cmd = DbCommand)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandType = db_command_def.DbCommandType;
cmd.CommandText = db_command_def.DbCommandText;
cmd.CommandTimeout = CommandTimeout;
cmd.Connection = conn;
if (db_command_def.DbParameters != null)
{
foreach (IDbDataParameter parm in db_command_def.DbParameters)
{
if ((parm.Direction == ParameterDirection.InputOutput || parm.Direction == ParameterDirection.Output) && parm.Value == null)
{
parm.Value = DBNull.Value;
}
cmd.Parameters.Add(parm);
}
}
return(cmd.ExecuteScalar());
}
}
catch { throw; }
}
public IEnumerable <T> LoadObject <T>(IDbCommandDef db_command_def, Func <IDataReader, T> row_to_object)
{
try
{
if (db_command_def == null)
{
throw new ArgumentException("Missing db command def object");
}
List <T> itms = new List <T>();
using (IDbConnection conn = DbConnection)
using (IDbCommand cmd = DbCommand)
{
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandType = db_command_def.DbCommandType;
cmd.CommandText = db_command_def.DbCommandText;
cmd.CommandTimeout = CommandTimeout;
cmd.Connection = conn;
if (db_command_def.DbParameters != null)
{
foreach (IDbDataParameter param in db_command_def.DbParameters)
{
cmd.Parameters.Add(param);
}
}
IDataReader dreader = cmd.ExecuteReader();
while (dreader.Read())
{
itms.Add(row_to_object(dreader));
}
}
catch { throw; }
}
return(itms);
}
catch { throw; }
}
public IEnumerable <T> LoadObject <T>(IDbCommandDef commandDef) where T : class
{
try
{
if (commandDef == null)
{
throw new ArgumentException("Missing Db Command Def");
}
List <T> itms = new List <T>();
using (IDbConnection conn = DbConnection)
using (IDbCommand cmd = DbCommand)
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
cmd.CommandType = commandDef.DbCommandType;
cmd.CommandText = commandDef.DbCommandText;
cmd.CommandTimeout = CommandTimeout;
cmd.Connection = conn;
if (commandDef.DbParameters != null)
{
foreach (IDbDataParameter param in commandDef.DbParameters)
{
cmd.Parameters.Add(param);
}
}
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
itms.Add(FillItem <T>(reader));
}
}
return(itms);
}
catch
{
throw;
}
}
public int NonQueryExecute(IDbCommandDef db_command_def)
{
return(DbAdapter.ExecuteQuery(db_command_def));
}
public void DeleteDataFromDB(IDbCommandDef db_command_def)
{
DbAdapter.ExecuteQuery(db_command_def);
}
public int SaveDataFromObject <T>(IDbCommandDef db_command_def)
{
return(DbAdapter.ExecuteDbScalar(db_command_def).ToInt32());
}
public int SaveDataFromObject <T>(IDbCommandDef db_command_def, Func <IDbCommandDef, int> object_saver)
{
return(object_saver(db_command_def));
}
public IEnumerable <T> LoadObjectFromDB <T>(IDbCommandDef db_command_def)
{
return(DbAdapter.LoadObject <T>(db_command_def));
}
public IEnumerable <T> LoadObjectFromDB <T>(IDbCommandDef db_command_def, Func <IDbCommandDef, IEnumerable <T> > object_loader)
{
return(object_loader(db_command_def));
}
