[ASP.NET] LINQ to SQL(group by, sum)

// LINQ query (SUM)

var tSum =

from p in db.TBSimulation    // from절

where p.USERID == ""         // where절

        group p by new { p.GROUPID,p.USERID } into grouping  // group by

        select new // sum column

        {

                 grouping.Key,

                 Totalprice = grouping.Sum(p => p.RESULT)

};

            

        // sum값 바인딩

        foreach (var grp in tSum)

        {

                this.lblTPROFIT.Text = grp.Totalprice.ToString();

        }