How to use LINQ Select with Max() in C#

Question

I have a linq query by which I wanted to fetch single record on the basis of below criteria-

1. Select column_A (int), column_B (string)
2. Select max value row on the basis of Column_A

I tried with this query-

var result = this.context.Table1
  .Where(x => x.Id == SomeId)
  .Select(s => new { 
     s.column_A, 
     s.column_B })
  .Max(item => item.column_A); 

But I am not sure it's a valid query or not. Can somebody let me know correct way to do this. Also after this query I wanted to get those two fields value like below-

var sequence = result.column_A
var index = result.column_B

Answer 1

You could always do this:

var result = this.context.Table1
         .Where(x => x.Id == SomeId)
         .OrderByDescending(x=>x.columnA)
         .Select(s => new { s.column_A, s.column_B })
         .FirstOrDefault();

For Min(), you can use .OrderBy instead of .OrderByDescending