/// <inheritdoc/>
public int Insert(IDbTransaction trans, SQLStrings sql, object param = null)
{
try
{
return(this._conn.Execute(sql.ToString(), param, trans));
}
catch (Exception)
{
trans.Rollback();
throw;
}
}
/// <inheritdoc/>
public List <dynamic> Select(SQLStrings sql, object param = null)
{
this._ConnectionTask.Wait();
var retValue = this._conn.Query(sql.ToString(), param);
if (retValue.IsEmpty())
{
return(new List <dynamic>());
}
else
{
return(retValue.AsList());
}
}
/// <inheritdoc/>
public List <T> Select <T>(SQLStrings sql, object param = null)
where T : class
{
this._ConnectionTask.Wait();
var retValue = this._conn.Query <T>(sql.ToString(), param);
if (retValue.IsEmpty())
{
return(new List <T>());
}
else
{
return(retValue.AsList());
}
}
