SQLite join in embedded database tables
You are not missing anything. Joins via linq are not supported by Sqlite-net at this time. You can work around this by providing your own SQL and using the Query
method. Your first query from above would look something like:
var q = db.Query<Questions>( "select Q.* from Questions Q inner join GameSaved G" + " on Q.QuestionId = G.QuestionId").First();
If you are so inclined, the Query
method also supports parameters. From the Sqlite-net readme:
db.Query<Val>( "select 'Price' as 'Money', 'Time' as 'Date' from Valuation where StockId = ?", stock.Id);