Is it Possible to set a Default Order By in Linq Attribute Mappings?

Question

I it was possible to do this in Active Record, but is this feasible with Linq to SQL?

Answer 1

You can if you use stored procedures or views to retrieve your data. The ORDER BY can then be in the stored proc or view but LINQ to SQL doesn't support this out of the box.

Answer 2

You can always add a property to the data-context / entities objects in a partial class file:

partial class MyDataContext {
    public IOrderedQueryable<Foo> FoosByName {
        get {return Foos.OrderBy(foo=>foo.Name);}
    }
}

Then any queries started from FoosByName will be pre-ordered (but still composable).