1
2
3
4
5
6
7
8
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
origin - https://www.pipiscrew.com/?p=18967 linq-to-entities-does-not-recognize-the-method-system-string-method-and-this-method-cannot-be-translated-into-a-store-expression