here I want to add branch_name so that the branch name should be taken from table tbl_branch depend on this branch_id.. help me

See more:

LINQ

var result = TblSMSEvent.Where(e=>e.Company_id =51)
           .GroupBy(e=>e.Branch_id)
           .Select(g=>new{ Branch_id=g.Key, Number_sms =g.Count()).ToList();

here I want to add branch_name so that the branch name should be taken from table tbl_branch depend on this branch_id.. help me