读书人

LINQ中求和和汇总只想做一次如何实现?

发布时间: 2012-01-13 22:43:30 作者: rapoo

LINQ中求和和汇总只想做一次怎么实现?.
SQL语句为:select Sum(t.b), Count(t.a) from tbl_customer t

LINQ分开实现:
SumA = (from c in vSession.Linq<Customer>()
select c.a).Sum();
CountB = (from c in vSession.Linq<Customer>()
select c.b).Count();

[解决办法]

C# code
//更改成这种形式 var query = from w in data.News                        select new                        {                            sum=data.News.Sum(m=>m.NewsId),                            count=data.News.Select(m=>m.NewsState).Count()                        }; 

读书人网 >.NET

热点推荐