Linq(最小和最大) [英] Linq (MIN && MAX)

问题描述

LINQ下的sql等于什么

What is equal of below sql in LINQ

select MIN(finishTimestamp) AS FromDate, MAX(finishTimeStamp) AS ToDate From Transactions

??

from t in Transactions
select new {
          FromDate = ?,
          ToDate = ?
        }

谢谢

推荐答案

您可以做

var transactionDates = from t in Transactions 
                       select t.FinishTimeStamp;

var dates = new { 
                   FromDate = transactionDates.Min(), 
                   ToDate = transactionDates.Max() 
                };

这篇关于Linq(最小和最大)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！