C#

public partial class Form1 : Form
    {
        List<Person> sortedPeople;

        public Form1()
        {
            InitializeComponent();
            List<Person> people = new List<Person> {new Person("wayne"), new Person("sarah"), new Person("mark"), new Person("simon"), new Person("ashleigh"), new Person("dave"), new Person("connor"), new Person("bronwyn"), new Person("chantelle"), new Person("will"), new Person("chris")};
            sortedPeople = people.OrderBy(name = name.Name).ToList();
        }
    }

    class Person
    {
        public Person(string name)
        {
            this.Name = name;
        }

        public string Name { get; set; }
    }

DataContext = new DataClasses1DataContext();

var people = from name in DataContext.Table_Peoples
             where name.IQ < 3
             select name;

var peopleOrdered = people.OrderBy(name => name.Name).ToList();

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Name", DbType="Text", UpdateCheck=UpdateCheck.Never)]
        public string Name
        {
            get
            {
                return this._Name;
            }
            set
            {
                if ((this._Name != value))
                {
                    this._Name = value;
                }
            }
        }

DataContext = new DataClasses1DataContext();

var people = from name in DataContext.Table_Peoples
             where name.IQ < 3
             select name;

List<Table_People> listPeople = people.ToList();

var peopleOrdered = listPeople.OrderBy(name => name.Name).ToList();

Quote:

__John_ wrote:

List<Table_People> listPeople = people.ToList();
 
var peopleOrdered = listPeople.OrderBy(name => name.Name).ToList();
 

-Manognya
__________________________________________________
$ God gives what is best.Not what all you wish

Public Shared Function OrderBy(Of TSource, TKey) ( _
	source As IEnumerable(Of TSource), _
	keySelector As Func(Of TSource, TKey) _
) As IOrderedEnumerable(Of TSource)

Parameters

source
Type: System.Collections.Generic.IEnumerable(Of TSource)
A sequence of values to order.

keySelector
Type: System.Func(Of TSource, TKey)
A function to extract a key from an element.

System.Collections.Generic.IEnumerable

-Manognya
__________________________________________________
$ God gives what is best.Not what all you wish

You cannot set Current to the first element of the collection again; you must create a new enumerator instance instead.

__John_ wrote:

It uses a 'lazy' strategy, ie. only evaluating an expression or executing a function when the result is actually needed, am I right?

List<Person> peoples = new List<Person> {new Person("wayne"), new Person("sarah"), new Person("mark"), new Person("simon"), new Person("ashleigh"), new Person("dave"), new Person("connor"), new Person("bronwyn"), new Person("chantelle"), new Person("will"), new Person("chris")};

int Count = people.Count(p => p.Name.StartsWith("w")); //<-- Count is a greedy operator and all persons are evaluated for a result of 2.

var firstperson = people.Where(p => p.Name.Length == 5).Take(3);
foreach (var p in firstperson) // <-- evaluation start where and only Wayne, Sarah, Mark and Simon will be evaluated. The rest of the list is left alone
{
   Console.WriteLine(p.Name);
}

// And to show you when Linq expression are evaluated, try 
var firstperson2 = people.Where(p => p.Name.Length == 5).Take(3);
people.Insert(1, new Person("Vince"));

foreach (var p in firstperson) // <-- evaluation start where and only Wayne, Vince ans Sarah, will be evaluated. The rest of the list is left alone
{
    Console.WriteLine(p.Name);
}

__John_ wrote:

BTW: How can I enumerate the results more that once?