Linq 평균값 가져오기 및 소수점 자리 짜르기쌤플
Posted by Albert 3589Day 15Hour 56Min 5Sec ago [2015-06-23]
var avg =
(from prod in context.tcn_training_center_live_mov_comment.Where(x => x.language_cd == language_cd && x.company_seq == company_seq && x.ref_seq == mov_seq)
select prod.grade_num).Average();
string result = (avg==null) ? "0" : string.Format("{0,10:N1}", avg);
return result;