Join Query Multiple Tables Order by descending Order

var year = (from ep in _adminContext.table1

                    join e in _adminContext.table2 on ep.idequals e.id

                    join t in _adminContext.table3 on e.idequals t.id

                    orderby t.Date descending

                    where t.status == "A"

                    select new

                    {

                        id= ep.id

                    }).FirstOrDefault();