CODEWITHSUNDEEP
c#.netentity-framework.net-3.5
Ben Hoffman
Ben Hoffman

Reputation: 8259

LINQ Join for Orderby only

I am trying to run this code:

ItemTaxonomy iTaxonomy = from itemTaxonomy in connection.ItemTaxonomy
                         where itemTaxonomy.Item.ID == itemView.ID
                         orderby itemTaxonomy.Taxonomy.Name
                         select itemTaxonomy;

When I compiled it I get the error:

Cannot implicitly convert type 'System.Linq.IOrderedQueryable<Website.Models.ItemTaxonomy>' to 'Website.Models.ItemTaxonomy'. An explicit conversion exists (are you missing a cast?)

I believe the issue is with orderby itemTaxonomy.Taxonomy.Name but I am just trying to order by the name of Taxonomy items instead of their IDs. Is there a way to do that?

Upvotes: 1

Views: 1074

Answers (3)

Jon Skeet
Jon Skeet

Reputation: 1499900

No, the problem is that the result is a sequence whereas your variable is a single item.

Given that you're expressing ordering, you must be expecting multiple values - so what do you want to do with them? Options:

  • Use First():

    ItemTaxonomy iTaxonomy = (from itemTaxonomy in connection.ItemTaxonomy
                          where itemTaxonomy.Item.ID == itemView.ID
                          orderby itemTaxonomy.Taxonomy.Name
                          select itemTaxonomy).First();

    This will return the ItemTaxonomy with the earliest name out of all the ones with the appropriate item ID.

  • Change your variable type:

    IEnumerable<ItemTaxonomy> taxonomies = 
    from itemTaxonomy in connection.ItemTaxonomy
    where itemTaxonomy.Item.ID == itemView.ID
    orderby itemTaxonomy.Taxonomy.Name
    select itemTaxonomy;

    Now you've got a sequence of taxonomies to deal with, instead of a single item.

Upvotes: 5

Marc Gravell
Marc Gravell

Reputation: 1062580

You seem to be capturing a single value from a query. Try:

var iTaxonomy = from itemTaxonomy in connection.ItemTaxonomy
                where itemTaxonomy.Item.ID == itemView.ID
                orderby itemTaxonomy.Taxonomy.Name
                select itemTaxonomy;

or to be more explicit:

IQueryable<ItemTaxonomy> iTaxonomy = ...

If you do want a single item, use ,First() or .Single().

Upvotes: 2

SLaks
SLaks

Reputation: 887285

The LINQ query returns a set (IEnumerable<T>) of ItemTaxonomy objects, which you are trying to assign to a variable of type ItemTaxonomy.

You need to change the type of the variable to IEnumerable<ItemTaxonomy>. (Or call First())

Upvotes: 0

Related Questions