Relationships between related/associated tables must be explicitly established in the information schema of your database.
Express Edition is free. Professional Plus Edition is for sale. Please see the product matrix.
Code is only generated for database tables with a Primary Key.
Some MVC Views such as the "List with Grouping", "List with Totals and Grouping", "List with Master Detail (Grid)", and "List with Master Detail (Sub Grid)" are only generated for tables that have explicit Foreign Key(s).
Some Stored Procedures (or Ad-hoc SQL) such as the "Select All By a Foreign Key", "Select, Skip, and Take By a Foreign Key", "Get Record Count by Foreign Key", and "Select Drop Down List Data" are only generated for tables that have explicit Foreign Key(s).