Convert sub query from SQL to Linq for SQL Server 2008

I have SQL query:

select 
    Photo.[Path]
from 
    Album 
inner join 
    Photo on Album.AlbumId = Photo.AlbumId
where 
    Photo.PhotoId = (select top 1 Photo.PhotoId
                     from Photo 
                     where Photo.AlbumId = Album.AlbumId
                     order by NEWID() )

I want convert to linq to sql. I tried convert below:

var query = from a in db.Album
            join p in db.Photo on a.AlbumId equals p.AlbumId
            select new
                        {
                         photo.Path
                        };

But query below:

            where Photo.PhotoId=
            (
             select top 1 Photo.PhotoId
             from Photo 
            where Photo.AlbumId =Album.AlbumId
            order by NEWID()
)

--> I tried convert but do not success. I have spent all my energy on this. Please help me

Complete convert sql to linq to sql. Thank you very much everybody!