Linq Query Leading To Invalid Column Name Sqlexception

ASPNET MVC5 web app, Visual Studio 2015 The website is language localized, so I need to get localized Categories depending on culture parameter. The category_trans table accounts f

Solution 1:

try this;

public static IQueryable<Product> ActiveProductsPerUser(BaseContext db, string userid, string culture)
    {
        var query = (from p in db.Products
                     join ct in db.category_trans
                     on p.CategoryID equals ct.category_id
                     join l in db.ISO_Languages
                     on ct.language_id equals l.ID
                     where l.code.Substring(0, 2) == culture)
                     select p).ToList();

        return query;
    }