+972 52-548-6969
time to read 2 min | 218 words
Bobby Diaz is still producing some amazing stuff. The new addition is native support for SQL functions. Take a look at this code:
DateTime date = new DateTime(1960, 1, 1);
var query = ( from e in db.Employees
where db.Methods.Year(e.BirthDate) >= date.Year && db.Methods.Len(e.FirstName) > 4
select e.FirstName )
.Aggregate(new StringBuilder(), (sb, name) => sb.Length > 0 ? sb.Append(", ").Append(name) : sb.Append(name));
Console.WriteLine("Birthdays after {0}:", date.ToString("yyyy"));
Console.WriteLine(query);
var query = ( from e in db.Employees
where db.Methods.Year(e.BirthDate) >= date.Year && db.Methods.Len(e.FirstName) > 4
select e.FirstName )
.Aggregate(new StringBuilder(), (sb, name) => sb.Length > 0 ? sb.Append(", ").Append(name) : sb.Append(name));
Console.WriteLine("Birthdays after {0}:", date.ToString("yyyy"));
Console.WriteLine(query);
Check out Bobby's post for the full details. I am going to write a full overview of the current state of Linq for NHibernate soon. The situation so far is looking very nice.