Random Order with Entity Framework

Question

I would like to translate the following SQL statement to an expression lambda:

SELECT TOP 1 * FROM tbPessoa order by NEWID()

What do I put in OrderBy that will be accepted?

var pessoa = contexto.tbPessoa.OrderBy(???).FirstOrDefault()

Note: the table has more than 3000 records, so ideally this should not be done in memory.

Answer 1

Use the Guid.NewGuid():

var pessoa = contexto.tbPessoa.OrderBy(a => Guid.NewGuid()).FirstOrDefault()

I put in the Github for future reference.