public async Task <IEnumerable <T> > FindALLRecords() { try { using (IDbConnection db = new SqlConnection(_config.Connection._ConnectionString)) { var _ret_val = await db.QueryAsync <T>(MSSQLQueryCreater.CombineQueryForSelectAll(_tablename, "Id")); return(_ret_val); } } catch (Exception ex) { throw ex; } }
public async Task <T> FindOneRecord(int _FK_value) { try { using (IDbConnection db = new SqlConnection(_config.Connection._ConnectionString)) { var _ret_val = await db.QuerySingleOrDefaultAsync <T>(MSSQLQueryCreater.CombineQueryForSelect(_tablename, "Id", _FK_value)); return(_ret_val); } } catch (Exception ex) { throw ex; } }
public async Task <bool> DeleteSingle(int Id) { try { using (IDbConnection db = new SqlConnection(_config.Connection._ConnectionString)) { var _ret_val = await db.ExecuteAsync(MSSQLQueryCreater.CombineQueryForDelete(_tablename, "Id", Id)); return(_ret_val > 0 ? true : false); } } catch (Exception ex) { throw ex; } }