/// <summary> /// Implementation of Scalar Query with Single Parameter for Prepared Query /// </summary> /// <param name="SQLCommand">Scalar Command</param> /// <param name="param">Parameter for Single Command</param> /// <param name="retrieveLastInsertID">Return Last Insert ID of each Command instead of Scalar</param> /// <returns>Object Returned by Scalar</returns> protected object ExecuteScalarImpl(string SQLCommand, QueryParameter param, bool retrieveLastInsertID = false) { return(ExecuteScalarImpl(SQLCommand, new [] { new [] { param } }, retrieveLastInsertID).First()); }
/// <summary> /// Raw Non-Query Implementation with Single Parameter for Prepared Query /// </summary> /// <param name="SQLCommand">Raw Command</param> /// <param name="param">Parameter for Single Command</param> protected int ExecuteNonQueryImpl(string SQLCommand, QueryParameter param) { return(ExecuteNonQueryImpl(SQLCommand, new [] { new [] { param } }).First()); }
public TObject SelectObject <TObject>(string whereExpression, QueryParameter param) where TObject : DataObject { return(SelectObjects <TObject>(whereExpression, param).FirstOrDefault()); }
/// <summary> /// Raw SQL Select Implementation with Single Parameter for Prepared Query /// </summary> /// <param name="SQLCommand">Command for reading</param> /// <param name="param">Parameter for Single Read</param> /// <param name="Reader">Reader Method</param> /// <param name="Isolation">Transaction Isolation</param> protected void ExecuteSelectImpl(string SQLCommand, QueryParameter param, Action <IDataReader> Reader, Transaction.IsolationLevel Isolation) { ExecuteSelectImpl(SQLCommand, new [] { new [] { param } }, Reader, Isolation); }
protected abstract DbParameter ConvertToDBParameter(QueryParameter queryParameter);