<div>
Try this:<br />
<br />

<pre><code id="code-20-35211179-1">var LastRcdId = (from c in dbTimeClockPlus.EmployeeList select c.RecordId).Max(c.RecordId);</code></pre>
</div>


Try this:



var LastRcdId = (from c in dbTimeClockPlus.EmployeeList select c.RecordId).Max(c.RecordId);

<div>
pretty much a repeat of kaufmed's solution.<br />
//using System.Linq;<br />
int LastRcdId = dbTimClockPlus.EmployeList<wbr />.Max(rec =&gt; rec.RecordId);
</div>


pretty much a repeat of kaufmed's solution.
//using System.Linq;
int LastRcdId = dbTimClockPlus.EmployeList.Max(rec => rec.RecordId);

<div>
Thank you both for your quick response. &nbsp;Kaufmed was 1st and it worked like a charm! &nbsp;So I awarded him points but I think all you EE guys are great! &nbsp;Thanks again!
</div>


Thank you both for your quick response.  Kaufmed was 1st and it worked like a charm!  So I awarded him points but I think all you EE guys are great!  Thanks again!

<div>
ya, didn't expect points just offering another way to do the same thing.<br />
glad you got your answer.
</div>


ya, didn't expect points just offering another way to do the same thing.
glad you got your answer.

<div>
<div class="content wysiwyg-content">
I have a field (RcdId) which is of Int type. &nbsp;I would like to extract the value of the largest one in the table. &nbsp;In this example I want the result of 236. &nbsp;I posted code using Max and Asc but they do not work in C#. &nbsp;Your help is appreciated.<br />
Emp No &nbsp; &nbsp; &nbsp; &nbsp; RcdId<br />
101 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;235<br />
102 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<b>236</b><br />
103 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;222<br />
104 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;24<br />
105 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;91<br />
<br />
My environment is Visual Studio, the language is C# and I'm attached to a SQL Server db.<br />
<br />

<pre><code id="code-8072300">var LastRcdId = (from c in dbTimeClockPlus.EmployeeLists where Max(c.RecordId)ASC select c.RecordId).FirstOrDefault();</code></pre>
</div>
</div>


I have a field (RcdId) which is of Int type.  I would like to extract the value of the largest one in the table.  In this example I want the result of 236.  I posted code using Max and Asc but they do not work in C#.  Your help is appreciated.
Emp No         RcdId
101	235
102	236
103	222
104	24
105	91

My environment is Visual Studio, the language is C# and I'm attached to a SQL Server db.


Largest value of a field (type int) in C#

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).

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.