linq.cs

linq.cs

Objects<Person>().FirstOrDefault(p => p.Name == "Roger");
Objects<Person>().FirstOrDefault(p => p.Name != "Roger");
Objects<Employee>().FirstOrDefault(p => p.Department.Company.Name == "Starcounter");
Objects<Person>().FirstOrDefault(p => p.Name.Contains("oge"));
Objects<Person>().FirstOrDefault(p => !p.Name.Contains("oge"));
Objects<Person>().FirstOrDefault(p => p.Name.StartsWith("Ro"));
Objects<Person>().FirstOrDefault(p => p.Name.EndsWith("er"));
Objects<Person>().FirstOrDefault(p => p.Age > 0 && p.Age < 100);
Objects<Person>().FirstOrDefault(p => p.Name == null);
Objects<Person>().Sum(p => p.Age);
Objects<Person>().Min(p => p.Age);
Objects<Person>().Max(p => p.Age);

//X6Decimal mumbo jumbo
//Objects<Person>().Average(p => p.Age);

Objects<Person>().Count();

var ages = new[] {1, 2, 3, 4, 5};
Objects<Person>().FirstOrDefault(p => ages.Contains(p.Age));

/*
SQL: SELECT p FROM Demo.Person p WHERE (p.Name = ?) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE (NOT p.Name = ?) FETCH ?
SQL: SELECT p FROM Demo.Employee p WHERE (p.Department.Company.Name = ?) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE (p.Name like ?||?||?) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE (NOT (p.Name like ?||?||?)) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE (p.Name like ?||?) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE (p.Name like ?||?) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE ((p.Age > ?) AND (p.Age < ?)) FETCH ?
SQL: SELECT p FROM Demo.Person p WHERE (p.Name = ?) FETCH ?
SQL: SELECT SUM(p.Age) FROM Demo.Person p
SQL: SELECT Min(p.Age) FROM Demo.Person p
SQL: SELECT Max(p.Age) FROM Demo.Person p
SQL: SELECT COUNT(generated_1) FROM Demo.Person generated_1
SQL: SELECT p FROM Demo.Person p WHERE (p.Age = ? OR p.Age = ? OR p.Age = ? OR p.Age = ? OR p.Age = ?) FETCH ?
*/