A relational database is named so because it makes the relationship between entities (Tables) a first-class citizen and gives means to validate and query those relationships (that is, foreign key constraints and joins).
The power of EF Core as an O/RM is that it bridges the world of object-oriented class associations and the world of relational database joins. It does so by treating the class properties that reference another entity (or a collection of entities) as a Navigation Property. With a Navigation Property, each operation you do on the property will generate the equivalent SQL join statement. For example, GiveNTake allows its users to search for products in a specific category. This is what it looks like: ...