'C# System.Data.SQLite details on how a row was built

I'm writing a lot of pretty complex SQLite queries, and what I'd like to do is gather information on how exactly a given row, returned from the query was constructed.

For example:

Execute complex SQL query
Returns 1 row
Read from `Table1` row 1
Read from `Table2` row 6
Read from `Table3` row 69
etc...

I've looked into the SQLiteConnection.Trace event, but it doesn't seem to contain the information I'm looking for. I'm not sure if this is a terrible idea, and I should do it another way.

Any information or advice would be greatly appreciated.

Thanks



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source