public T QueryForObject <T>(CfCommandType cmdType, string cmdText,
object cmdParms) where T : new()
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(QueryForObject <T>(cmdType, cmdText, cfParams));
}
public DataSet DataAdapter(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
// we use a try/catch here because if the method throws an exception we want to
// close the connection throw code, because no datareader will exist, hence the
// commandBehaviour.CloseConnection will not work
try
{
Logger.InfoFormat("DataAdapter: {0}", cmdText);
Logger.Info(cmdParms);
_conn.EstablishFactoryConnection();
var dda = _conn.CreateDataAdapter();
PrepareCommand(cmdType, cmdText, cmdParms);
dda.SelectCommand = _cmd;
var ds = new DataSet();
dda.Fill(ds);
return(ds);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new CfException("Unknown Error (Connection Factory: DataAdapter) " + ex.Message, ex);
}
}
public IEnumerable <dynamic> LazyLoadForObjects(
CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(LazyLoadForObjects(cmdType, cmdText, cfParams));
}
//[System.Diagnostics.DebuggerStepThrough]
public int ExecuteNonQuery(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
Logger.Debug("Begin Method");
try
{
Logger.InfoFormat("ExecuteNonQuery: {0}", cmdText);
Logger.Info(cmdParms);
_conn.EstablishFactoryConnection();
PrepareCommand(cmdType, cmdText, cmdParms);
Logger.Debug("End Method");
return(_cmd.ExecuteNonQuery());
}
catch (DbException dbe)
{
Logger.Error(dbe);
throw new CfException("Unknown error in database: " + dbe.Message, dbe);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new CfException("Error on Connection Factory Mechanism: " + ex.Message, ex);
}
}
public T ExecuteScalar <T>(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
try
{
Logger.InfoFormat("ExecuteScalar: {0}", cmdText);
Logger.Info(cmdParms);
_conn.EstablishFactoryConnection();
PrepareCommand(cmdType, cmdText, cmdParms);
var returnValue = _cmd.ExecuteScalar();
_cmd.Dispose();
if (returnValue is DBNull || returnValue == null)
{
return(default(T));
}
try
{
return((T)returnValue);
}
catch (Exception ex)
{
Logger.Error(ex);
throw new CfException(String.Format("Conversion error in ({0})\"{1}\" - (Connection Factory: ExecuteScalar) > {2}", typeof(T).Name, returnValue, ex.Message), ex);
}
}
catch (Exception ex)
{
Logger.Error(ex);
throw new CfException("Unknown Error (Connection Factory: ExecuteScalar) " + ex.Message, ex);
}
}
public dynamic QueryForObject(
CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(QueryForObject(cmdType, cmdText, cfParams));
}
public IEnumerable <T> LazyLoadForObjects <T>(
CfCommandType cmdType, string cmdText, object cmdParms) where T : new()
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(LazyLoadForObjects <T>(cmdType, cmdText, cfParams));
}
public dynamic ExecuteScalar(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
_conn.EstablishFactoryConnection();
PrepareCommand(cmdType, cmdText, cmdParms);
dynamic returnValue = _cmd.ExecuteScalar();
_cmd.Dispose();
if (returnValue is DBNull || returnValue == null)
{
return(default(dynamic));
}
return(returnValue);
}
public IEnumerable <IDataReader> LazyLoad(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
Logger.InfoFormat("LazyLoad: {0}", cmdText);
Logger.Info(cmdParms);
_conn.EstablishFactoryConnection();
PrepareCommand(cmdType, cmdText, cmdParms);
using (var reader = _cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
yield return(reader);
}
}
}
public IDataReader ExecuteReader(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
try
{
Logger.InfoFormat("ExecuteReader: {0}", cmdText);
Logger.Info(cmdParms);
_conn.EstablishFactoryConnection();
PrepareCommand(cmdType, cmdText, cmdParms);
return(_cmd.ExecuteReader(CommandBehavior.CloseConnection));
}
catch (Exception ex)
{
Logger.Error(ex);
throw new CfException("Unknown Error (Connection Factory: ExecuteReader) " + ex.Message, ex);
}
}
private void PrepareCommand(CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
_conn.EstablishFactoryConnection();
_cmd?.Dispose();
_cmd = _conn.CreateDbCommand();
_cmd.CommandText = cmdText;
_cmd.CommandType = (CommandType)cmdType;
if (_commandTimeout > -1)
{
_cmd.CommandTimeout = _commandTimeout;
}
CreateDbParameters(cmdParms);
}
public T QueryForObject <T>(CfCommandType cmdType, string cmdText,
IEnumerable <CfParameter> cmdParms = null) where T : new()
{
return(QueryForObject <T>(ExecuteReader(cmdType, cmdText, cmdParms)));
}
public IEnumerable <T> LazyLoadForObjects <T>(
CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null) where T : new()
{
return(LazyLoadForObjects <T>(LazyLoad(cmdType, cmdText, cmdParms)));
}
public dynamic QueryForObject(
CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
return(QueryForObject(ExecuteReader(cmdType, cmdText, cmdParms)));
}
public dynamic ExecuteScalar(CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(ExecuteScalar(cmdType, cmdText, cfParams));
}
public IEnumerable <IDataReader> LazyLoad(CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(LazyLoad(cmdType, cmdText, cfParams));
}
public int ExecuteNonQuery(CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(ExecuteNonQuery(cmdType, cmdText, cfParams));
}
public IDataReader ExecuteReader(CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(ExecuteReader(cmdType, cmdText, cfParams));
}
public IEnumerable <dynamic> LazyLoadForObjects(
CfCommandType cmdType, string cmdText, IEnumerable <CfParameter> cmdParms = null)
{
return(LazyLoadForObjects(LazyLoad(cmdType, cmdText, cmdParms)));
}
public DataSet DataAdapter(CfCommandType cmdType, string cmdText, object cmdParms)
{
var cfParams = ConvertObjectToCfParameters(cmdParms);
return(DataAdapter(cmdType, cmdText, cfParams));
}
