LINQ statement to retrieve random record with GUID

Hello all,

I am a newbie to LINQ

Recently I posted a question to get a random record.  I was using  a two step approach to first get the list then use a second list with .skip()  and .take() and a random number using the max records in the returned list.  I wanted to do this in one LINQ statement.  One of the members here Fernando Soto,  submitted an idea to use GUID as part of the mix which is random and doing a orderby on it.  I though the idea was brilliant, however it did not work.  I like the approach and think it is close. Any help please?  And again thanks to Fernando for suggesting the idea.

var AdList =
    (from a in Advertisements
     join c in Companies on a.AdvertiementOwnerID equals c.CompanyID
     where a.AdvertisementType=="Banner"
    orderby Guid.NewGuid()
     select new {
        a.AdvertisementID,
        a.AdvertisementType,
        a.AdvertiementActive,
        a.AdvertisementText,
        a.AdvertisementImageLocation,
        a.AdvertisementAlt,
        c.CompanyName,
        c.Website
    }).ToList();          // This will return all records in random order
   
//  }).FirstOrDefault();  // This will return one records randomly each time  
//  }).Take(X);           // This will return X random record


Here was my first question that had my original (bloated) approach

https://www.experts-exchange.com/questions/28690437/Simplify-LINQ-statement-getting-random-record.html