Hi there I'm about to develop a data managemant system for inhouse use as replacement for our old one (MS Access based). I'll make heavy use of inheritance such as:

DataItem > Product Product > Software Software>OperatingSystem Product > Hardware Hardware > Device Device > Computer DataItem > Credential Credential > WindowsDomainLogin 

I know there is PostgreSQL which supports table inheritance, but efcore does not. Also PostgreSQL supports foreign data from other sql servers. Is there (besides NHibernate) a good ORM or ORDBMS that supports this (inheritance and optional foreign data)?

Regards patahel