Using SqlServer 2008. LLBLGen Pro 3.1.

I am a noob with lambda syntax as well as LLBLGen pro.

I want to sum the TotalCharge column but i want Sql Server to do the summing.

The following causes the summing to happen on the client, not the server:

WithMetadata(lmd => lmd.BillingDetail.Where(c => (c.BillId ==billEntity.BillId)) .Select(t=>t.TotalCharge).Sum());

That query should do the sum on the server. Please post the generated SQL. Also, make sure you are using the latest version of the runtime library version. What does the WithMetadata(...) ?