Is it possible to do sub-query join using ServiceStack's OrmLite?

Question

Something like this?

var q = Db.From<Customer>()
    .Join<Customer, subq>((c, subq) => c.CustomerID == subq.CustomerID)

mythz mythz · Accepted Answer · 2017-07-04T09:27:57

There's no Typed API support for joining on a sub select but you can use a CustomJoin to do this, e.g:

var q = Db.From<Customer>()
    .CustomJoin("INNER JOIN (SELECT Id FROM ...) sub ON sub.Id = Customer.Id")