Order by navigation properties

Hi,

I have the model below and Would like to order my list of Categories by Product.CreationDate Desc ?

var result = this.ListCategory.OrderBy(c => c.LisProduct.OrderByDescending(p => p.CreationDate));

does not work

 public class Category
        {
            public int id { get; set; }
            public string name { get; set; }

            public virtual List<Product>  LisProduct { get; set; }
        }

        public class Product
        {
            public int id { get; set; }
            public string name { get; set; }
            public DateTime CreationDate { get; set; }

            public virtual Category Category { get; set; }
        }

Re: Order by navigation properties

Hello

Since your Product has a Category mapping to the CategorySo you can have a try like this

var result = (from p in XXX.Products

order p by p.CreationDate

select p.Category.name).Distinct();

Re: Order by navigation properties

Ok,

I will try this if work

But I will select select p.Category and not select p.Category.name

Because I need other properties of Category.

Best regards

Re: Order by navigation properties

Goraleye

But I will select select p.Category and not select p.Category.name

Because I need other properties of Category.

Hello again

If you can get the instance of Category from ProductYou should get other public properties from Category instance

Re: Order by navigation properties

Hi this does not work

Because I've list of categories and I would like to order by product.dtcreation and return again my list of categories.

For sample : Category with product creation date at 02/01/2012 must be displayed after Category with product creation date at 01/01/2012

var result = (from c in listCategories
                          orderby c.Products.OrderByDescending(p => p.DtCreation)
                          select c);

Re: Order by navigation properties

Goraleye

Hi this does not work

Because I've list of categories and I would like to order by product.dtcreation and return again my list of categories.

For sample : Category with product creation date at 02/01/2012 must be displayed after Category with product creation date at 01/01/2012
var result = (from c in listCategories
                          orderby c.Products.OrderByDescending(p => p.DtCreation)
                          select c);

You mean you cannot get c as Category

Re: Order by navigation properties

No,

I can get C as Category but the oder by does not return a good shorted list categories

Re: Order by navigation properties

Goraleye

No,

I can get C as Category but the oder by does not return a good shorted list categories

What do u wantYou want to sort Category by Products