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