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