2 ms·
Include() on an ObjectContext will return the corresponding foreign key objects. It's a poor man's join to related entities. There is also Join(), but that wi
by snarfy 12y ago
Include() on an ObjectContext will return the corresponding foreign key objects. It's a poor man's join to related entities. There is also Join(), but that will join by anything.
- virtualwhys 12y agoAh ok, I see. Slick actually does have a nice shorthand for fkey joins: val q = for{ ur <- UserRole; u <- ur.user; r <- ur.role } yield(ur,u,r) which would produce semantic equivalent to: select ur.id, ur.a, ..., u.id, u.a ... from userrole ur join user u on u.id = ur.userId join role r on r. id = ur.roleId grouping and sorting is where Slick becomes less readable SQL-like DSL and more boilerplate DSL full of meaningless tuples O_o