public int getIndentQty_SumByItemShortItemNo(int shortItemNo) { int result = 0; objF41021 = new F41021Repository(); var resultEntity = (from r in objF41021.GetAll(x => x.ShortItemNo.Equals(shortItemNo)).ToList() group r by r.ShortItemNo into gr select new { shortItemNo = gr.Key, IndentQty_sum = gr.Sum(x => x.QtyIndentResv) }).FirstOrDefault(); if (resultEntity != null) result = resultEntity.IndentQty_sum; return result; }