How can I use alias in linq to sql for columns ? I want to join name and surname as "author". This code doesn't work:from x in db.autors orderby x.surname select x.name+" "+x.surname as author; ...