In LinqPad I have the following query statements...
var genre = "Anime & Animation";
var minRating = 3.0;
var topNum = 30;
var query =
(from g in Genres
from t in g.Titles
where g.Name==genre
&& t.Instant.Available==true
&& t.AverageRating >= minRating
orderby t.AverageRating descending
select new {t.Name, t.Rating, t.AverageRating, t.ShortSynopsis}).Take(topNum);
query.Dump(string.Format("Top {0} {1} Instant Watch Movies with a {2:0.0} minimum average rating sorted by average rating in descending order.",topNum,genre,minRating));
I want to return the genre string variable in the result set.
Another way to ask, with TSQL I would do "SELECT field1, field2, 'Action & Adventure' as genre from MyTitles". So how do you do that in Linq.
Seth