System.ENUM has no supported translation to SQL

I'm trying to do a group by in LINQ to SQL but I want to base the grouping on the text description of my ENUM items.

        var qry = from s in _db.Complaints 
                  where s.Site.SiteDescription.Contains(searchTextSite)
                    && (s.Raised >= startDate &a开发者_Go百科mp;& s.Raised <= endDate)
                  group s by s.ComplaintNatureTypeId.ToDescription()
                      into grp
                      select new
                      {
                          Site = grp.Key,
                          Count = grp.Count()
                      };

I'm thinking this must be supported since its very fundamental and think i'm missing something simple.

Anyone any ideas on how i'm getting runtime error & how to remedy this

thanks in advance

Linq to Sql is translated to Sql query so everything must be convertable to query. You can not group items by something that is only in your code. If u want to group by enum you can use ints its unique as your string enums.