I see that it is easy enough to perform a LeftJoin on types that are known at design time, however I am struggling to write an Ormlite query that allow me to join two types/tables that are not known until runtime.
I have two tables that have the same schema and want to do check whether there are differences between rows based on their Id property.
The first type is the generic type parameter for the class in which I need to make this call. The second type isn’t known until run time as it is read from a dictionary.
I had hoped that I could get something like this to work but it complains that type ‘lambda expression’ cannot be assigned to Expression<Func<T, bool>>
var records = connection.Select(connection.From<T>()
.LeftJoin(typeof(T), secondType)
.Where((c1, c2) => c1.Id == c2.Id));