SQLite uses SQLite-Net to add Windows 8 Metro C #

db.Query("SELECT * FROM Person, Job WHERE Person.JobID = Job.ID");

db.Query("SELECT * FROM Person, Job WHERE Person.JobID = Job.ID");

SELECT * FROM Person INNER JOIN Job ON Person.JobID = Job.ID

db.Query(" SELECT Person.* FROM Person INNER JOIN Job ON Person.JobID = Job.ID"); 
 db.Query("SELECT Job.* FROM Person INNER JOIN Job ON Person.JobID = Job.ID" );

I am using C# and SQLite as the database of Windows-8-Metro-App. I want to use Join-Command, but I don’t know how to read the given Return data. This does not work:

db.Query("SELECT * FROM Person, Job WHERE Person.JobID = Job.ID"); 

This is not implemented:

db.Query("SELECT * FROM Person, Job WHERE Person.JobID = Job.ID" );

Does anyone know how to do this?

The connection is fine, if outdated-you should use the updated syntax

SELECT * FROM Person INNER JOIN Job ON Person.JobID = Job.ID

Your problem lies in the content you return – you are returning Person data and Job data – so you need to create a The data structure matches the class – or just return one person or one job.

db.Query("SELECT Person.* FROM Person INNER JOIN Job ON Person. JobID = Job.ID"); 
 db.Query("SELECT Job.* FROM Person INNER JOIN Job ON Person.JobID = Job.ID");