Add support for MemoryScope#not
Use in-memory state to avoid lazy loads and DB round trip