如代碼1,先把數(shù)據(jù)ToList()到結(jié)果集中,然后再用sum函數(shù)。這樣不會產(chǎn)生對數(shù)據(jù)表的sum聚合算法,而是在結(jié)果集中sum.這樣是不是比代碼2直接在數(shù)據(jù)庫中sum性能要好呢? 代碼1var query = (from x in db.Course
select x.Score).ToList();
int sum = (decimal)query.Sum(); 代碼2var query = from x in db.Course
select x.Score;
int sum = (decimal)query.Sum();
Linq結(jié)果集性能的疑問
慕的地8271018
2018-08-10 08:10:05