none
How to convert the following sql query to lamda expression? RRS feed

  • Question

  • How to convert the following sql query to lamda expression?

    select cg.Code, ci.ChangeType, SUM(oc.Value) from OtherCharges oc  
    left join changeitems ci on oc
    .ChangeItemKey = ci.ChangeItemKey 
    left join
    ChangeGroups cg on ci.ChangeGroupKey = cg.ChangeGroupKey 
    where OtherKey = 'AB235A00-FEB2-4C4F-B0F9-3239FD127A8F' 
    group by cg.Code, ci.ChangeType 
    order
    by cg.Code, ci.ChangeType 

    Friday, September 14, 2012 1:03 AM

Answers