Search code examples
subsonic3

How I do a select max(field) in Subsonic 3.0?


Yes, there is a method max with 13 overloads, none it's simply the name of the column. Something can post an example in VB.NET?


Solution

  • VB.NET:  maxField = SomeTableClass.All().Max(Function(p As SomeTableClass) p.someField).
    

    Is an option. Using LINQ can be

    (From x in SomeTableClass.All() select x.someField).Max()