Ormlite query using SUM and Having

1

Hi,

i have a query where i want to left join a table and filter on some properties and also where the rowcount for the joined table is greater than

var q = Db.From<Customer>()
         .Where(c => c.Active && c.CompanyId == request.CompanyId)
         .LeftJoin<Customer, Booking>((cust, b) => cust.CompanyId == b.CompanyId
          **//Here i want to have a check WHERE number of Booking (the joined table) rows is greater than xx** 
         .Select();

Any idea how i can solve this?

2

Not supported in a Typed SQL Expression, you’d need to use Custom SQL.