<div>
<br />

<pre><code class="code-1 nolinks" id="code-429865"><span>var collection = es.Where(q =&gt; field.Contains(q.status)).OrderBy(x =&gt; x.dateField);</span>
<span>var difference = (collection.Last().dateField - collection.First().dateField()).Minutes;</span>
</code></pre>
</div>


<div>
Hi,<br />
Neat! but an System.NotSupportedExcepti<wbr />on though.. the Last operator not supported. I've tried corresponding ..OrDefault() but no luck. also the difference query complained on syntax where .Minutes does not contain a definition in System.TimeSpan. My datefield is a DateTime?.
</div>


<div>
Seems still no difference.. we may talk about different things.. I can't do a () after dateField.. it isn't supposed to be called as a method (because it's a object that relates to a table class)
</div>


<div>
<div class="content wysiwyg-content">
I have a query that takes f.e. 5000 rows (can be two or 20.000). I want to calculate the difference between the earliest and latest date in that result. The output should be the difference in ie. minutes. <br />
<br />
I prefferably take the result as es.Where(q =&gt; field.Contains(q.status)))<wbr /> who contains a specific date field that should be used in the calculation,
</div>
</div>


I have a query that takes f.e. 5000 rows (can be two or 20.000). I want to calculate the difference between the earliest and latest date in that result. The output should be the difference in ie. minutes. 

I prefferably take the result as es.Where(q => field.Contains(q.status))) who contains a specific date field that should be used in the calculation,

Calculate Difference between dates in linq

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).