LINQ to Entities does not recognize the method 'System.String' method and this method cannot be translated into a store expression

[Costas]

src - https://stackoverflow.com/a/10071105

var list = db.Brand.Where(c => c.Title.Contains("test"))
                   .Select(c => new { c.Title, c.Brand })
                   .AsEnumerable() // Rest of the query in-process
                   .Select(x => x.Title + " " + x.Brand)
                   .ToList();

https://stackoverflow.com/a/21406163