reviewing-oracle-to-postgres-migration
Audited by Runlayer on Mar 11, 2026
Risky tool definition detected
Configure Npgsql for UTC via Connection String or AppContext Npgsql 6+ ships with `EnableLegacyTimestampBehavior` set to `false` by default, which causes `timestamptz` values to be returned as `DateTime` with `Kind=Utc`. Explicitly setting the switch at startup is still recommended to guard against accidental opt-in to legacy mode (e.g., via a config file or a transitive dependency) and to make the intent visible to future maintainers: ```csharp // Program.cs / Startup.cs — apply once at applica
Tool: reviewing-oracle-to-postgres-migration/references/oracle-to-postgres-timestamp-timezone.md [2/2] Description: Assert.True(retrieved.CreatedAt >= before, "Persisted CreatedAt should not be earlier than the pre-insert UTC timestamp."); } ``` ### Test: Verify timestamp comparisons across Oracle and PostgreSQL baselines ```csharp [Fact] public async Task TimestampComparison_ShouldReturnSameRowsAsOracle() { var cutoff = DateTime.UtcNow.AddDays(-1); var oracleResults = await oracleRepository.Get
Tool passed security scan
Passed Files (9)Click to expand
Tool passed security scan
Tool passed security scan
Tool passed security scan
Tool passed security scan
Tool passed security scan
Tool passed security scan
Tool passed security scan
Tool passed security scan
Tool passed security scan