The Many-To-Many relations are defined in the objects – classes with c# attributes.
The above examples let you explore the possibilities with the Many-To-Many method:
If the call is with the type Club we will get only the normal columns, no lists because there are no Many-To-Many relations in that type, even with the recursive option wil change nothing in the output.
With the type Team the output is different, then we get two lists populated:
When we set the Recursive option then we get also the related data of the right table (TeamMatch) the Match information and also the MatchSet information (recursive).
The method can hold also a predicate to narrow down the look-up of the table:
TableManyToMany<Club>(x => x.IdC == 1234, true)
TableManyToMany<Team>(x => x.IdT == 5678, true)
See for all the commands: SQLite-Doc