I am new to Linq and I am having trouble constructing the following query. Any help would b great!
select
ucs.actualvalue,
sum(t.quantity)
from
userprofile u inner join
user_customsetting ucs on u.userid = ucs.userid inner join
customsetting cs on ucs.customsettingid = cs.customsettingid left join
[transaction] t on t.userid = u.userid
where
cs.customsettingnm = 'User_LeaderBoardName'
group by
ucs.actualvalue
