public async Task UpdateAsync(ITradingRoute tradingRoute) { using (var conn = new SqlConnection(_connectionString)) { await conn.ExecuteAsync( $"update {TableName} set {GetUpdateClause} where Id=@Id", _convertService.Convert <ITradingRoute, TradingRouteEntity>(tradingRoute)); } }
public async Task <bool> TryInsertAsync(ITradingRoute tradingRoute) { using (var conn = new SqlConnection(_connectionString)) { try { await conn.ExecuteAsync( $"insert into {TableName} ({GetColumns}) values ({GetFields})", _convertService.Convert <ITradingRoute, TradingRouteEntity>(tradingRoute)); } catch (Exception ex) { _log?.WriteWarningAsync(nameof(TradingRoutesRepository), nameof(TryInsertAsync), $"Failed to insert a trading route with Id {tradingRoute.Id}", ex); return(false); } return(true); } }