sql server - Using a custom join with summing in ServiceStack.OrmLite -

sql server - Using a custom join with summing in ServiceStack.OrmLite -

i haven't found illustration allows following...

select o.*, total.ordertotal orders o bring together (select orderid,sum(productcost) ordertotal orderitems grouping orderid) total on o.orderid=total.orderid

i able around putting sum custom select column, avenue failed 1 time wanted add together ability filter results ordertotal can done in above adding having sum(productcost)>??.

is possible without doing straight custom sql?

sql-server servicestack ormlite-servicestack