How to get the max row number from a table by using linq

Question

SELECT ISNULL(MAX(ColumnName) + 1, 1) AS ColumnName 
FROM TableName

How to write this query in LINQ.Is there any way to convert sql to linq . i want a converter.

Above query works well but i want the same output on linq .How to ?

I know how to select max

  var products = ((from p in db.TableName
                            select p.ColumnName).Max());

Answer 1

This should do it:

return (myContext.MyTable.Max(t => (int?) t.MyColumn) ?? 0) + 1