The script create_db.sqlcreates two tables parent and child in a Postgres schema of your choice and populates them with data. Please adjust DEFAULT_CONNECTION in SetupBase.cs accordingly.
To demonstrate the issue please run dotnet test in the project directory.
If you uncomment the SYNC define in GenericRepository.cs the problem vanishes.