CODEWITHSUNDEEP
linqentity-frameworkentity-framework-4
Jean-François Beaulieu
Jean-François Beaulieu

Reputation: 4445

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

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

SELECT        MAX(Game_id) AS MaxValue
FROM          Dim_Game

Upvotes: 5

Views: 8093

Answers (4)

Michael Freidgeim
Michael Freidgeim

Reputation: 28435

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

Upvotes: 1

Niraj
Niraj

Reputation: 1842

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

Upvotes: 0

Pierre-Olivier Pignon
Pierre-Olivier Pignon

Reputation: 747

you can also use a stored procedure like that : 

 select ident_current('table_name')

Upvotes: 0

Sergey Kalinichenko
Sergey Kalinichenko

Reputation: 726559

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

Upvotes: 5

Related Questions