Select queries

SQL	Fluent
SELECT foo AS Foo, bar AS Bar, first(baz) AS Baz, baq[0] AS Baq FROM OGraphVertex	List<ODocument> result = database .Select("foo").As("Foo") .Also("bar").As("Bar") .Also("baz").First().As("Baz") .Also("baq").Nth(0).As("Baq") .From("OGraphVertex") .ToList(); or List<MyCustomVertexClass> result = database .Select("foo").As("Foo") .Also("bar").As("Bar") .Also("baz").First().As("Baz") .Also("baq").Nth(0).As("Baq") .From<OGraphVertex>() .ToList<MyCustomVertexClass>();
SELECT FROM OGraphVertex WHERE foo = 'foo string' AND bar != 12345 OR baz <= 10 OR baq >= 50 OR f1 LIKE 'text%' OR f2 IS NULL	List<ODocument> result = database .Select() .From("OGraphVertex") .Where("foo").Equals("foo string") .And("bar").NotEquals(12345) .Or("baz").LesserEqual(10) .Or("baq").GreaterEqual(50) .Or("f1").Like("text%") .Or("f2").IsNull() .ToList(); or List<MyCustomVertexClass> result = database .Select() .From<OGraphVertex>() .Where("foo").Equals("foo string") .And("bar").NotEquals(12345) .Or("baz").LesserEqual(10) .Or("baq").GreaterEqual(50) .Or("f1").Like("text%") .Or("f2").IsNull() .ToList<MyCustomVertexClass>();
SELECT FROM OGraphVertex WHERE foo CONTAINS 'english' AND bar CONTAINS (foo = 123)	List<ODocument> result = database .Select() .From("OGraphVertex") .Where("foo").Contains("english") .And("bar").Contains("foo", 123) .ToList(); or List<MyCustomVertexClass> result = database .Select() .From<OGraphVertex>() .Where("foo").Contains("english") .And("bar").Contains("foo", 123) .ToList<MyCustomVertexClass>();