LINQ

Eloquera DB starting from version 2.5 supports LINQ

Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.

Traditional LINQ example:

var res = from Movie m in db where m.Year > x select m;

LINQ can also be used like this:

var movies = from m in db.Query<Movie>() where m.Title == "Joe" && m.Year > 1950 orderby -m.Year select m;

Some more details on LINQ syntax, tutorial, examples can be found here

http://msdn.microsoft.com/en-us/netframework/aa904594.aspx