Linq 평균값 가져오기 및 소수점 자리 짜르기쌤플

Posted by Albert 3588Day 15Hour 44Min 24Sec 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;



LIST

Copyright © 2014 visionboy.me All Right Reserved.