markrendle/Simple.Data — Issue #142: Explicit joins do not work with the InMemoryAdapter
Author: Molokai
Created: 2012-01-29 14:05:46+00:00
State: open

I have tried running joins with the database.User.Query().Join(database.Department).On().Select() syntax (where the columns to join on are specified, since there is no referential integrity with the InMemoryAdapter). The query returns data, but not joined data as far as I can tell.

All the selected fields from the Department table are null, and the number of rows returned are the number of rows in the User table. If I switch so that the first table is Department, then all the User fields are null and the number of rows is the same as in the Department table.

This was tested with 0.14.0.1