Q:

Linq - Join results from 2 columns from same table

I would like to join results from a table, to sum up the results from a where condition on 2 different rows, as this code:
        var a = (from o in _DB.Services
                where (o.description.Contains(searchText) || o.nom.Contains(searchText))
                orderby o.date
                select new { results = ?????, id = ?????? }).Take(maxResults).ToList();

What can I put, in order to take into account the results=???? and id=??? 
Thanks

A:

Based on your comment, can't you just do the following?
var a = (from o in _DB.Services
            where (o.description.Contains(searchText) || o.nom.Contains(searchText))
            orderby o.date
            select new  
                   { 
                       results = o.description,
                       id = o.nom
                   })
            .Take(maxResults)
            .ToList();

