score:1

Accepted answer
from S in db.Students
where S.ID = ID
select new 
{ 
    EMAIL = (S.EMAIL.Contains("@") ? 
                S.EMAIL.Substring(0, S.EMAIL.IndexOf("@")) : 
                S.EMAIL
            ).Replace(".", " ,")
  , S.NAME 
};

score:4

var query =  (from S in db.Students
             where S.ID = ID
             select new { 
                 S.EMAIL, 
                 S.NAME })
             .AsEnumerable()
             .Select(x => new {
                  EMAIL = x.EMAIL.Split('@')[0].Replace(".", " ,"), 
                  NAME = x.NAME});

Related Query

More Query from same tag