It says that only parameterless constructors and initializers are supported in LINQ to Entities when I attempt to combine two tables and build a tuples list....var list = (
from a in db.CategoryRatings
join c in db.OverallPerformanceByCategories
on a.CategoryRatingId equals c.CategoryRatingId
where c.ReviewId == review.ReviewId
...
Depending on whether the query was run or not, the behavior of the following changes and is difficult to manage:...using (var db = new DbContext())
{
db.Entities.Select(x => Math.Round(0.5)).First(); // return 1
db.Entities.ToList().Select(x => Math.Round(0.5)).First(); // returns 0
db.Entities.AsEnumerable().Select(x => Math.Round(0.5...
