Today I was doing some LINQ to nHibernate and I came to this statement.
Considering that I used a Person class that looks like this.
```vbnet Public Class Person Private _lastName as String Private _id as Integer
End Class``` And what I wanted was the lowest Id number for all people that were named like me. Because I am sure I will always have the lowest id.
In SQL that would look something like this.
Select min(id) from person where person.Lastname = 'baes'
The first linq statement I came up with was this.
_session.Linq(of Person).Where(Function(x) x.LastName.Equals("baes")).Min(Function(x) x.Id)
That gave the right result. But it was loading all of the Person objects and then doing the Min function in memory on those Objects.
So I changed it to this.
(From e in _Session.Linq(Of Person) where e.LastName = "baes" select e.Id).Min
Which did result in the above mentioned select statement.