If I have a query with WHERE clause and if I use string concatenation in SELECT clause, then no records are returned.
Try this code:
Code: Select all
var query = from u in DB.Users
where u.Active == 1
select new { Name = u.Username + " abc " };
foreach(var row in query)
{
// no records returned;
}