Question

我从林克·托施克尔开始,我仍然有一些问题要问我。

例如,我要在同一问询中收回两个价值,一个要素子集,另一个要素的分类。这是我如何单独这样做:

  int totalElements;
  IEnumerable<ClsTax> result;
  result = (from t in db.tax 
           select new ClsTax { Tax = t.tax1, Increase = t.increase }).Take(25);

  totalElements = (from t in db.tax 
             select new ClsTax { Tax = t.tax1, Increase = t.increase }).Count();

如你所看到,我可以不使用结果。

是否有办法只使用一只lin子获得这两种数值?

感谢!

Answer 1

如何:

var all = (from t in db.tax select new ClsTax { Tax = t.tax1, Increase = t.increase });
var count = all.Count();
var result = all.Take(25);

范围较简单?

Answer 2

为此:

var result = (from t in db.tax group t by t.ID into g select new { Tax = g.First().tax1, Increate = t.First().Increase, TotalElements = g.Count() });

友情链接