Can sombody, please, convert this simple SQL statment to Linq? [closed]

This question is unlikely to help any future visitors; it is only relevant to a sma开发者_Python百科ll geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. Closed 11 years ago.

select * 
    , (
    select AVG(RatingVal)  
    from Ratings 
    where Ratings.AppID = ID
    ) as average 
from Applications

---

var result = from r in Ratings
             group by r.AppID into rg
             from a in applications
             where a.ID = rg.Key
             select new {Application = a, AvgRating = rg.Avg(r=>r.RatingVal)};

Haven't tested it, but that should work.