With LINQ how do you return a string const in the result from the select operator.
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
With LINQ how do you return a string const in the result from the select operator.
===

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