How go get max value of a unique id column using LINQ

Question

How can I write this in the simplest way using LINQ?

SELECT        MAX(Game_id) AS MaxValue
FROM          Dim_Game

score 5 · Accepted Answer · edited Nov 09 '12 at 19:43

5

Try context.Dim_Games.Max(g => g.Game_id);

edited Nov 09 '12 at 19:43

NET3

1,520
1
16
25

answered Dec 18 '11 at 02:32

Sergey Kalinichenko

714,442
84
1,110
1,523

I get: `'Project.Models.Dim_Game' does not contain a definition for 'Max'` – Jean-François Beaulieu Dec 18 '11 at 02:35
What is the name of the EF entity container that corresponds to `Dim_Game` table in the database? – Sergey Kalinichenko Dec 18 '11 at 02:39
@JFB Do you have `using System.Linq;` at the top of your .cs file? – Reed Copsey Dec 18 '11 at 02:42
@dasblinkenlight You were thinking the correct thing ;) http://msdn.microsoft.com/en-us/library/bb549271.aspx Was my mistake... – Reed Copsey Dec 18 '11 at 02:43
If your column is not nullable and result of you query can be empty, see my answer below [How go get max value of a unique id column using LINQ](http://stackoverflow.com/a/38396527) – Michael Freidgeim Jul 15 '16 at 12:49

score 1 · Answer 2 · edited May 23 '17 at 10:30

If your column is not nullable and result of you query is empty, you will receive the error

"The cast to value type 'System.Int32' failed because the materialized value is null. Either the result type's generic parameter or the query must use a nullable type."

To avoid the error you should cast column to nullable and result coalesce with 0.

int max=(surveys.Max(g =>( int?)g.SurveyID) ?? 0);

See more details in The cast to value type 'Int32' failed because the materialized value is null

score 0 · Answer 3 · answered Feb 20 '13 at 15:30

0

you can also use a stored procedure like that :

 select ident_current('table_name')

answered Feb 20 '13 at 15:30

Pierre-Olivier Pignon

679
7
18

score 0 · Answer 4 · answered May 22 '15 at 06:44

0

you can use following code, if identity increment is on

Convert.ToInt32(_entities.Database.SqlQuery("SELECT IDENT_CURRENT('table') + IDENT_INCR('table')", new object[0]).FirstOrDefault())

answered May 22 '15 at 06:44

Niraj

1,782
1
22
32

How go get max value of a unique id column using LINQ

4 Answers4

Linked