Hi guys, is there any particular reason for entity to be inside transaction block if i want to know id value in reference column? For example

entity.parent?.id?.value

code will throw

No transaction in context

although entity table has parent_id column and it should know parent id value when you fetched it, so no additional queries needed to DB. And exposed seems to know that, cause if i put this code under transaction block - parent id will be returned without any additional queries

All references keept in EntityCache bound to transaction. When you use

entity.parent

the Parent instance is looked up from cache and it is absent there then Exposed will load it. You can define

parentId

field on the Entity and then it will just return the field value and will not require the transaction.