How to select an enum to a new list?

Question

var menuQuery = repository.MenuMasters.OrderBy(c => c.Position).Select(c => new { ID = c.MenuMasterID, Position = (MenuItemPosition)c.Position + " - " + c.SitePage.Title });
ViewBag.ParentID = new SelectList(menuQuery, "ID", "Position", selectedParentId);


public int Position { get; set; }
    public MenuItemPosition MenuPosition {
        get { return (MenuItemPosition)Position; }
        set { Position = (int)value; }
    }

public enum MenuItemPosition {
    Top = 1, Main = 2, Footer = 3
}

I got an error which said "Unable to cast the type 'Type Name' to type 'Type Name'. LINQ to Entities only supports casting Entity Data Model primitive types."

MenuItemPosition is "Enum", Title is "string"

How can I fix this? Many thanks~!

score 1 · Answer 1 · answered Mar 06 '12 at 09:34

I think you need to add .ToList after OrderBy, as string concatenation is not supported with Linq to Entities.. So your query will look something like :

var menuQuery = repository.MenuMasters.OrderBy(c => c.Position).ToList().Select(c => new { ID = c.MenuMasterID, Position = ((MenuItemPosition)c.Position).convertToString() + " - " + c.SitePage.Title });

score 0 · Answer 2 · answered Mar 06 '12 at 05:16

0

Try something like

var menuQuery = repository.MenuMasters.OrderBy(c => c.Position).Select(c => new { ID = c.MenuMasterID, Position = c.Position.ToString() + " - " + c.SitePage.Title });

answered Mar 06 '12 at 05:16

Jayanga

889
6
15

what do you really want to put there enum name? can you update your question with the enum – Jayanga Mar 06 '12 at 06:58

How to select an enum to a new list?

2 Answers2