How can I write this in the simplest way using LINQ?
SELECT MAX(Game_id) AS MaxValue FROM Dim_Game
Try context.Dim_Games.Max(g => g.Game_id);
context.Dim_Games.Max(g => g.Game_id);