LINQ query + pass result to the view in MVC

See more:

LINQ

MVC6

I have a collection of CDs recorded in a db table.
Each one is assigned a GenreID. eg. 1= Classical, 2 = Pop, 3= Folk etc.
Each CD is assigned a number from a sequence for each Genre. This is done manually at the moment.
When I record a new CD,I would like to have the next number in my chosen Genre allocated to an input form in my view.
I would welcome help with the Linq query and with getting the result to the input box within the view.
Kind regards
Jim

What I have tried:

My view currently sends the GenreId to the Controller.
The method has the following Linq:-
<pre>var query =( from DM in c.DiscMain
                        where DM.GenreId==GenreId       
                        orderby DM.DiscNo descending
                        select DM).Take(1);
                        return Json(query);