SELECT BusinessEntityID, FirstName + ' ' + LastName AS "FullName"
FROM Person WHERE FullName LIKE  'a%'

using(var db= new db_Context)
 {
      var query = db.Person.Select(q=> q.FirstName  + " "+ q=>q.FullName)
 }