1. Can someone help me out converting the following query to return an IENumerable?
select s.SID, S.title, s.StoryText, Isnull(Round(AVG(CAST(R.RatingValue as float)),1), 0) as AVGRating
from TableS s
left join TableR r on s.SID = r.SID
Group By s.SID, S.title, s.StoryText, R.SID
2. Is it possible to store such a query as a view in the database and use that view to create a EDMX Data Model in my project? Wouldn't this be easier than creating the Model with two entities and the matching LINQ query from 1. ?