Preferred Language:

Listing 18.11 - Entities\App_Code\Movie.cs

Listing 18.11 - Entities\App_Code\Movie.cs (C#)
Copy 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Data.Linq;

public partial class Movie
{
    public static IEnumerable<Movie> Select()
    {
        MyDatabaseDataContext db = new MyDatabaseDataContext();
        return db.Movies;
    }

    public static IEnumerable<Movie> SelectByBoxOfficeTotals()
    {
        return Select().OrderBy(m => m.BoxOfficeTotals);
    }
}