Sort data using entity model

Question

I am trying to sort different field. i.e. blogID, date, author I found order by method but dont know how to pass the value in the method... help please

public List<blog> BlogFetch(string key)
{
    List<blog> blogRes = new List<blog>();

    using (var be = new BlogEntities())
    {
        blog res = new blog();

        foreach (var User in be.blogs.OrderBy(<what goes here?>))
        {
            res = User;
            blogRes.Add(res);
        }
    }
    return blogRes;
}

Darren Lewis · Accepted Answer · 2011-11-30 08:05:32Z

3

be.blogs.OrderBy(b => b.NameOfPropertyOnBlogClass)

It's a Lambda expression which is used heavily in LINQ. Here's a good "cheatsheet" on getting started with LINQ syntax.

As an aside if you want to load a List of items when using EF you can just call ToList().

answered Nov 30, 2011 at 8:05

Darren Lewis

8,5083 gold badges39 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bas · Accepted Answer · 2011-11-30 07:55:20Z

2

The OrderBy method takes a function with the following signature:

TResult PropertyRetrieval<TInput, TResult>(TInput obj);

So, if you have a Blog and you want to sort by BlogID, the result will be this (assuming BlogID is an int):

int SortBy(Blog obj)
{
    return obj.BlogId;
}

You can enter this by a Lambda expression:

be.blogs.OrderBy(blog => blog.BlogID); 
be.blogs.OrderBy(blog => blog.Date);
be.blogs.OrderBy(blog => blog.Author);

etc.

answered Nov 30, 2011 at 7:55

Bas

27.2k8 gold badges56 silver badges89 bronze badges

Collectives™ on Stack Overflow

Sort data using entity model

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related